Home
README.mdTable of Contents
Technical Resources for SQL Server & more
Most open source, all free. Scripts, tools, and resources pertinent to SQL Server and beyond.
T-SQL Scripts
- Ola's Maintenance Scripts
- Brent's First Responder Kit
- Glenn Berry's Diagnostic Queries
- Tiger Tool Box
- sp_WhoIsActive
- sp_InEachDB - replacement for the undocumented sp_MSForEachDB
- Jeff Moden's DelimitedSplit8k - string splitter function
References
- SQL Style Guide
- T-SQL Style Guide
- DBATools Build Reference
- MSSQL Waitopedia
- Module Signing Info
- SQL 2017 & Azure Database Permissions Poster
- The Data Loading Performance Guide
- Database Hiearachy of Monitoring Infographic
- Scheduling Powershell Tasks With SQL Agent
SSMS Plugins
- Apex SQL Refactor
- Apex SQL Complete
- Apex SQL Search
- SQL Sentry Plan Explorer
- Dell Spotlight Essentials
Tools
| Name | Type | Open Source | Author |
|---|---|---|---|
| DBA Tools | Admin | 👍 | SQL Collaborative |
| DBA Checks | Admin | 👍 | SQL Collaborative |
| MinionWare | Admin | MinionWare | |
| DLM Dashboard | Devops | Redgate | |
| Flyway | Migrations | 👍 | Axel Fontaine |
| Is It SQL? | Monitoring | Bill Graziano | |
| Spotlight Cloud Basic | Monitoring | Quest | |
| SQL Watch | Monitoring | 👍 | Marcin Gminski |
| SchemaZen | Scripting | 👍 | Seth Reno |
| mssql-scripter | Scripting | 👍 | Microsoft |
| DBDiagram.io | Sharing | holistics.io | |
| Format Text as Table | Sharing | Senseful Solutions | |
| DBFit | Testing | Yavor Nikolov | |
| DB Fiddle | Testing/Sharing | Jack Douglas | |
| SQL Fiddle | Testing/Sharing | Jake Feasel | |
| Paste The Plan | Tuning/Sharing | Brent Ozar Unlimited |
Other
- Wide World Importer Database - Successor to the AdventureWorks sample database for SQL Server 2016+
- Stack Overflow Database - Brent Ozar's packaging of the Stack Overflow database
- idownvotedbecau.se - Linkable downvoting rationale for Stack Exchange comments.
- Open Source Pull Request Template - Whimsical choose-your-own-adventure that climaxes with a customized pull request template by Tal Ater
Good Reads
AlwaysOn
- The AlwaysOn Health Model Part 2 - Extending the Health Model
- When Always On Isn't: Handling Outages In Your Application by Brent Ozar
- SQL Server 2016/2017: Availability group secondary replica redo model and performance - Detailed information on parallelism in redo worker threads
Misc.
- Modern Data Analysis: Don't Trust Your Spreadsheet
- T-SQL Interview Questions by Jeremy Kadlec
- Developer Interview Questions by Brent Ozar
- Tuning Cost Threshold
- 5 Rules of Normalization by Marc Rettig
- T-SQL Code Smells by Phil Factor
- Fighting Evil in Your Code: Comments on Comments by Michael Sorens
- The Security of Modern Password Expiration: An Algorithmic Framework and Empirical Analysis