picklerick

Please see dbatools.io/picklerick. The most important change here is that we fixed our SQL connection pooling.

bagofbobbish beta

Please read more on our blog

realfakedoors

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.

pieceoftoast

This is really long and I'm sorry, I'm lazy 👎 Please see dbatools.io/pieceoftoast.

snowball for real

This release is all about Backup and Restore - but mostly about Restore - you should see that 🏆 . Read more at dbatools.io/snowball.

New Commands

• Backup-DbaDatabase
• Get-DbaDatabase
• Restore-DbaDatabase

(many others that will be featured in an upcoming release)

schwifty

This release is all about Service Principal Names. Read more at dbatools.io/schwifty

New Commands

• Get-DbaSpn
• Set-DbaSpn
• Test-DbaSpn
• Remove-DbaSpn

twentyfiveschmeckles

New Commands

• Export-SqlUser
  Exports SQL Server Database Users creation script with all database permissions (database and object level) to a T-SQL file. This is a function that is not available in SQL Server Management Studio.
• Find-DbaAgentJob
  Finds agent job(s) that fit certain search criteria.
• Find-DbaDatabase
  Search SQL Server instances for database that have either the same name, owner or service broker guid.
• Find-DbaStoredProcedure
  Returns all stored procedures that contain a specific string or regex pattern.
• Get-DbaAgentAlert
  Return all SQL Agent alerts on a SQL Server Agent.
• Get-DbaAgentOperator
  Returns all SQL Agent operators on a SQL Server Agent.
• Get-DbaDatabaseState
  Gets some common “states” on databases like Read-Write (READ_ONLY or READ_WRITE), Status (ONLINE, OFFLINE, EMERGENCY) and Access options (SINGLE_USER, RESTRICTED_USER, MULTI_USER)
• Get-DbaHelpIndex
  This function will return detailed information on indexes (and optionally statistics) for all indexes in a database, or a given index should one be passed along.
• Get-DbaMemoryUsage
  Get amount of memory in use by all SQL Server components and instances. SSAS and SSIS are included.
• Get-DbaMsdtc
  Displays information about the Distributed Transactioon Coordinator (MSDTC) on a server.
• Get-DbaPageFileSetting
  Returns detailed information about the Windows page file.
• Get-DbaTrigger
  Get all existing triggers at instance and database level.
• Get-DbaUptime
  Returns the uptime of the SQL Server instance. If you want you can get the value for the hosting windows server too.
• Get-DbaXEventsSession
  Retrieves a list of Extended Events Sessions.
• Invoke-SqlCmd2
  Runs a T-SQL script. But only captures the first selected result set, such as the output of PRINT statements when Verbose parameter is specified.
  
  A big plus when comparing with native Invoke-SqlCmd cmdlet is that this one supports parameterized queries.
• New-DbaDatabaseSnapshot
  Do you need to create a database snapshot? This command will do it without hassles.
• Out-DbaDataTable
  Will creates a DataTable based on an objects properties.
  This allows you to easily write to SQL Server tables.
• Rename-DbaLogin
  It can be a pain to update all of the mappings for a specific user when you rename a SQL login this does it for you, will rename login and database mapping for a specified login.
• Restore-DbaFromDatabaseSnapshot
  Restores the database from the snapshot, discarding every modification made to the database.
• Set-DbaDatabaseState
  Want to change a database state? With this command you can chose between ReadOnly, ReadWrite, Online, Offline, Emergency, plus a special “Detached”, SingleUser, RestrictedUser, MultiUser.
• Test-DbaOptimizeForAdHoc
  Displays information relating to SQL Server Optimize for AdHoc Workloads setting.
• Write-DbaDataTable
  Quickly and efficiently writes data to a SQL Server Table using a .NET DataTable to a SQL Server table using SQL Bulk Copy.

Improvements

• Test-SqlMigrationConstraint
  Added support for SQL Server 2016 SP1 outstanding news! Almost all editions supports what was, until now, Enterprise features only. (#512)
• Get-SqlServerKey
  Added support for SQL Server 2016 (#610)
• Copy-SqlLogin
  If you try to transfer a local account (non-domain) you get a "Skipped", because is a local machine account. (#275)

Notable bug fixes

• Copy-SqlDatabase
  Fixed an issue where -WithReplace was not working properly (#601)
• Expand-SqlTLogResponsibly
  Fixed an issue where Expand-SqlTLogResponsibly grew TLog all at once. (#503)
• Remove-SqlOrphanUser
  Fixed an issue where Remove-SqlOrphanUser fails when the user was the owner of one or more schemas. (#296)
• Remove-SqlDatabaseSafely
  Remove-SqlDatabaseSafely failed to perform final drop w/ no additional information. (#238)

schleem

New Commands

• Export-DbaAvailabilityGroup
• Get-DbaBackupHistory
• Get-DbaDatabaseSnapshot
• Get-DbaRoleMember
• Read-DbaBackupHeader
• Remove-DbaDatabaseSnapshot
• Resolve-DbaNetworkName
• Test-DbaLastBackup
• Test-DbaMaxMemory
• Test-DbaValidLogin

Selected Bug fixes

Find-DbaOrphanedFile - speed improvements, added trims to remove null bytes for sql2000
Remove-SqlDatabaseSafely - Fixed SQL Agent Running check
Fix Export-SqlLogin not enumerating database permissions
Test-SqlMaxMemory - renamed all the MaxMemory commands
Get-DbaRestoreHistory - output directly to pipeline
Get-DbaBackupHistory - added device type
Copy-SqlLogin SQL Login not migrating when mixed mode not enabled on destination
Get-SqlRegisteredServerName - fix to allow working with nested groups

Testing

Added Appveyor + Pester

antsinmyeyesjohnson

New Commands

Connect-DbaSqlServer
Get-DbaLastBackup
Get-DbaPermission
Get-DbaStartupParameter
Remove-DbaBackup

Bug Fixes & Enhancements

Copy-SqlCredential and Copy-SqlLinkedServer unneeded connect attempts/errors removed
Copy-SqlDatabase - added example, and fixed a filestream check
Find-DbaOrphanedFile - Fixed bug that reported some valid directories and files as orphaned.
Get-DbaTcpPort -Fixed a bug that hid a real exception message behind one that basically said “Something didn’t work right.”
Set-SqlMaxMemory - fixed error message
Start-SqlMigration - Corrected error that made Copy-SqlCredential and Copy-SqlLinkedServer only work with Windows auth
Test-SqlNetworkLatency -Fixed a logic bug that produced inaccurate results.
Test-SqlPath - Now works in all languages!

mrmeeseeks v2

New Commands

Copy-SqlSsisCatalog
Find-DbaOrphanedFile
Get-DbaAvailabilityGroup
Get-DbaLastGoodCheckDb
Get-DbaProcess
Get-DbaRunningJob
Set-DbaMaxDop
Test-DbaFullRecoveryModel
Test-DbaMaxDop

Bug Fixes & Enhancements

Fix Test-DbaPowerPlan powerplan language not being native
Set-SqlTempDbConfiguration calculation bug
Test-SqlTempDbConfiguration - Improved output
Copy-SqlLogin - moved kill closer to drop
Get-ParamSqlDatabases - Adding -NoSystem to dynamic parameter to include SystemDB's
Get-DbaDiskSpace - Output format issue bug general tools
Copy-SqlDatabase - Fixed Check for ROWS or LOG
Set-SqlTempDbConfiguration errors when more than 1 data file already exists best practices bug
Set-SqlTempDbConfiguration can't set data file growth
Copy-SqlLogin - Fixed language being dropped in some circumstances
Get-DbaDiskSpace - added bytes as unit, filesystem, fragmentation and -Detailed
install.ps1 to point to updated location
Copy-SqlLogin and Database in Availability Group issue resolved
Get-DbaDatabaseFreeSpace added columns enhancement
Update-SqlPermissions, Sync-SqlLoginPermissions - Fixes for inaccessible databases