SQL Server List of Tools and Scripts¶
Source: expressdb.io/sql-server-resources.md at master · LowlyDBA/expressdb.io (github.com)
Most open source, all free. Scripts, tools, and resources pertinent to SQL Server and beyond.
Contents¶
- T-SQL Scripts
- References
- SSMS Plugins
- Azure Data Studio Extensions
- Tools
- Education
- Articles
- AlwaysOn
- Patterns / Anti-Patterns
- Misc
- Other
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).
SSMS Plugins¶
Azure Data Studio Extensions¶
Micosoft curates a list of first and third party extensions here.
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 | |
| 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 | |
| DB Fiddle | Testing/Sharing | Jack Douglas | |
| SQL Fiddle | Testing/Sharing | Jake Feasel | |
| ExtendsClass | Testing/Sharing | Cyril Bois | |
| 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
Appendix: Links¶
Backlinks:
list from [[SQL Server List of Tools and Scripts]] AND -"Changelog"