Tools and Scripts
Most open source, all free. Scripts, tools, and resources pertinent to SQL Server and beyond.
T-SQL Scripts
- Ola's Maintenance Scripts
- Brent Ozar's First Responder Kit
- Glenn Berry's Diagnostic Queries
- SQL CAT's Tiger Tool Box
- Adam Machanic's sp_WhoIsActive
- Aaron Bertrand's sp_InEachDB - replacement for the undocumented sp_MSForEachDB
- Jeff Moden's DelimitedSplit8k - string splitter function
- John McCall's DBA MultiTool - Suite of administrative scripts
References
- SQL Style Guide
- T-SQL Style Guide
- DBATools Build Reference - Open source SQL Server build tracker
- SQLServerUpdates.com - Brent Ozar's SQL Server build tracker
- MSSQL Waitopedia
- Module Signing Info
- SQL Server & Azure Database Permissions Poster
- The Data Loading Performance Guide
- Database Hiearachy of Monitoring Infographic
- Scheduling Powershell Tasks With SQL Agent
- ColumnScore.com - Quiz to find if you should use columnstore indexes on your table
- Use the Index, Luke! - A site explaining SQL indexing to developers—no crap about administration.
- Modern SQL - A site explaining modern features of the SQL standard & which products use them.
- EndofLife.Date - EOL for MSSQL (and many others).
- Query Store Best Practices - by Erin Stellato
SSMS Plugins
Azure Data Studio Extensions
Micosoft curates a list of first and third party extensions here.
Github Actions
Name | Type | Open Source | Author |
---|---|---|---|
tsqlt-installer | Testing | ✅ | John McCall |
tsqllint-action | Testing | ✅ | John McCall |
Tools
Name | Type | Open Source | Author |
---|---|---|---|
DBA Tools | Admin | ✅ | SQL Collaborative |
DBA Checks | Admin | ✅ | SQL Collaborative |
MinionWare | Admin | ❌ | MinionWare |
DLM Dashboard | Devops | ❌ | Redgate |
DBOps | Migrations | ✅ | SQL Collaborative |
Flyway | Migrations | ✅ | Axel Fontaine |
Is It SQL? | Monitoring | ❌ | Bill Graziano |
lowlydba.sqlserver Ansible collection | Admin | ✅ | John McCall |
OpServer | Monitoring | ✅ | Stack Exchange |
Spotlight Cloud Basic | Monitoring | ❌ | Quest |
SQLTop | Monitoring | ✅ | Channel Advisor |
SQL Watch | Monitoring | ✅ | Marcin Gminski |
SchemaZen | Scripting | ✅ | Seth Reno |
mssql-scripter (may be dead) | Scripting | ✅ | Microsoft |
DBDiagram.io | Sharing | ❌ | holistics.io |
Format Text as Table | Sharing | ❌ | Senseful Solutions |
DBFit | Testing | ❌ | Yavor Nikolov |
tSQLt | Testing | ✅ | SQLity.net |
DB Fiddle | Testing/Sharing | ❌ | Jack Douglas |
SQL Fiddle | Testing/Sharing | ❌ | Jake Feasel |
SQL Query Stress | Testing | ✅ | Erik Ejlskov Jensen |
Paste The Plan | Tuning/Sharing | ❌ | Brent Ozar Unlimited |
Education
- Vertabelo's Academy - Various database patterns and schema design examples
- 5 Rules of Normalization by Marc Rettig
- SQL Murder Mystery - Introduction to SQL as a murder mystery story
- Select Star - Interactive introduction to SQL
Articles
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
Patterns / Anti-Patterns
- SQL Server UPSERT Patterns and Antipatterns by Michael J Swart
- T-SQL Code Smells by Phil Factor
- Fighting Evil in Your Code: Comments on Comments by Michael Sorens
- The Data Loading Performance Guide
Misc
- Erland Sommarskog's articles on SQL Server
- Modern Data Analysis: Don't Trust Your Spreadsheet
- T-SQL Interview Questions by Jeremy Kadlec
- Developer Interview Questions by Brent Ozar
- Tuning Cost Threshold
- The Security of Modern Password Expiration: An Algorithmic Framework and Empirical Analysis
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
- SQL Server Kit - Compendium of everything SQL Server & R by Konstantin Taranov