sql-server-toolbox
SQL Server Toolbox
Getting Started
A loose assembly of files use for day-to-day administration, performance tuning, troubleshooting and investigation of Microsoft SQL Server databases.
Prerequisites
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.
Contributing
Suggestions/corrections welcome. Collaboration limited to Sparkhound SQL DBA team.
Contributors
- William Assaf - williamadba
- Colby Loupe - cloupe
- David Nguyen - davidnguyen2889
- Bill Carter - wfc1973
Acknowledgments
- Code snippet source documented with URL where appropriate, if lacking, please notify us.
Easy Download
- 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.