# Tools and Scripts
Most open source, all free. Scripts, tools, and resources pertinent to SQL Server and beyond.
| Table of Contents |
|---|
| T-SQL Scripts |
| References |
| SSMS Plugins |
| Tools |
| Education |
| Articles |
| Other |
# 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 - 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
# 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 | |
| DBA MultiTool | Admin | 👍 | John McCall |
| 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 | |
| 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
# 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