dataplat/dbatools v0.8.942

realfakedoors

on GitHub

Please see dbatools.io/realfakedoors for more info.

New Commands

Of the 23 new commands in this release, one command, Get-DbaSqlBuildReference, fulfills a need that I've seen talked about in the community for quite some time. Major Contributor Simone Bizzotto parsed a ton of SQL Server build information, created a JSON database then coded Get-DbaSqlBuildReference to parse it. We'll also be placing the data on sqlcollaborative.github.io once we get that going. Thank you, Simone!

• Get-DbaLocaleSetting
  Gets the Locale settings on one or more computers.

• Get-DbaNetworkActivity
  Gets the Current traffic on every Network Interface on a computer.

• Get-DbaQueryExecutionTime
  Displays Stored Procedures and Ad hoc queries with the highest execution times. Works on SQL Server 2008 and above.

• Get-DbaSqlBuildReference
  Returns info about the specific build of a SQL instance, including the SP, the CU and the reference KB, wherever possible.

• Get-DbaTempdbUsage
  Gets Tempdb usage for running queries.

• Find-DbaDatabaseGrowthEvent
  Finds any database AutoGrow events in the Default Trace.

• New-DbaSsisCatalog
  Enables the SSIS Catalog on a SQL Server 2012+

• Remove-DbaDatabase
  Drops a database, hopefully even the really stuck ones.

• Test-DbaIdentityUsage
  Displays information relating to IDENTITY seed usage. Works on SQL Server 2008 and above.

• Test-DbaLinkedServerConnection
  Test all linked servers from the sql servers passed.

• Read-DbaTransactionLog
  Reads the live Transaction log from specied SQL Server Database

General commands

Based on the popularity of Get-DbaDatabase and a general agreement within the team, 1.0 will include a bunch of basic Gets and Sets within the module that return SMO objects. Here's the first batch!

• Get-DbaAgentJob
  Gets SQL Agent Job information for each instance(s) of SQL Server.

• Get-DbaAgentJobOutputFile
  Returns the Output File for each step of one or many agent job with the Job Names provided dynamically if required for one or more SQL Instances.

• Get-DbaBackupDevice
  Gets SQL Backup Device information for each instance(s) of SQL Server.

• Get-DbaCredential
  Gets SQL Credential information for each instance(s) of SQL Server.

• Get-DbaCustomError
  Gets SQL Custom Error Message information for each instance(s) of SQL Server.

• Get-DbaDatabaseAssembly
  Gets SQL Database Assembly information for each instance(s) of SQL Server.

• Get-DbaDatabaseEncryption
  Returns a summary of encryption used on databases based to it. Shows if a database has Transparent Data encryption, any certificates, asymmetric keys or symmetric keys with details for each.

• Get-DbaJobCategory
  Gets SQL Agent Job Category information for each instance(s) of SQL Server.

• Get-DbaServerAuditSpecification
  Gets SQL Security Audit Specification information for each instance(s) of SQL Server.

• Get-DbaTable
  Shows table information around table row and data sizes and if it has any table type information.

• Set-DbaAgentJobOutputFile
  Sets the OutPut File for a step of an agent job with the Job Names and steps provided dynamically if required.

• Set-DbaSpConfigure
  This function changes the configured value for sp_configure settings. If the setting is dynamic this setting will be used, otherwise the user will be warned that a restart of SQL is required.