SQL Server Toolbox

A loose assembly of files use for day-to-day administration, performance tuning, troubleshooting and investigation of Microsoft SQL Server databases.

Many scripts have alternative versions for backwards compatibility with SQL Servers prior to SQL Server 2012, most scripts developed for SQL Server 2012 or higher, many with comments indicating features added in specific versions of SQL Server.

Execution intended with SSMS/VSCode without SQLCMD mode enabled for most scripts, unless otherwise noted.

PowerShell should be supported for PowerShell 3+ unless otherwise noted.

Suggestions/corrections welcome. Collaboration limited to Sparkhound SQL DBA team.

• William Assaf - williamadba
• Colby Loupe - cloupe
• David Nguyen - davidnguyen2889
• Bill Carter - wfc1973

• Code snippet source documented with URL where appropriate, if lacking, please notify us.

• A regularly updated .zip file of the toolbox is available here: https://github.com/williamadba/sql-server-toolbox/blob/master/toolbox.zip for quick download of the entire folder. It is not guaranteed to contain all recent changes, but it usually does.