Fetching latest commit…
MiscMSSQL
Various MSSQL scripts and tools. Contained herein or linked to for ease of aggregation. Mostly if not all free.
T-SQL Scripts
- Ola's Maintenance Scripts
- Brent's First Responder Kit
- Glenn Berry's Diagnostic Queries
- Tiger Tool Box
- sp_WhoIsActive
- sp_ForEachDB - 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
SSMS Plugins
- Apex SQL Refactor
- Apex SQL Complete
- Apex SQL Search
- SQL Sentry Plan Explorer
- Dell Spotlight Essentials
Tools
| Name | Type | Open Source | Author |
|---|---|---|---|
| Is It SQL? | Monitoring | Bill Graziano | |
| DBFit | Testing | Yavor Nikolov | |
| SchemaZen | Scripting | Seth Reno | |
| DLM Dashboard | Devops | RedGate | |
| SQL Fiddle | Testing/Sharing | Jake Feasel | |
| mssql-scripter | Scripting | Microsoft | |
| DBA Tools Powershell Scripts | Admin | SQL Collaborative | |
| DBA Checks Powershell Scripts | Admin | SQL Collaborative | |
| Flyway | Migrations | Axel Fontaine | |
| Paste The Plan | Tuning/Sharing | Brent Ozar Unlimited | |
| Format Text as Table | Sharing | Senseful Solutions | |
| SQL Watch | Monitoring | Marcin Gminski |
Other
- Wide World Importer Database - Successor to the AdventureWorks sample database for SQL 2016+
- Stack Overflow Database - Brent Ozar's packaging of the Stack Overflow database for demoing and testing
- idownvotedbecau.se - Pages containing downvoting rationale for adding to Stack Exchange comments.
Good Reads
- 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