Tools and Utilities
- Azure Data Studio
- DB-Engines Ranking
- Diagnostic Information Queries (Glenn Berry)
- DiskSPD (Storage Performance test)
- Index Help and Find Duplicates (Kimberly Tripp)
- OStress (SQL Stress Utility)
- Powershell DBATools
- Set Statistics IO / Time Parser
- SQL Server Best Practices Check
- SQL Server Configuration Assessment
- SQL Diagnostic Utility
- SQL Log Scout
- SQL Server First Responder Kit (Brent Ozar)
- SQL Server Maintenance Solution (Ola Hallengren)
- SQL Server Management Studio (SSMS)
- SQL Server Vulnerability Assessment
- SQL Tiger Team Toolbox GitHub
- Synapse Team Toolbox Github
- Wait Types Library (SQLSkills.com)
- WhoisActive (Adam Machanic)
Recommended Reading
- Cardinality Estimations (Microsoft Docs)
- ColumnStore Indexing (Niko Neugebauer)
- Get your ColumnStore ColumnScore
- Constant Time Recovery in Azure SQL Database
- SQL Server Execution Plans (Grant Fritchey)
- Execution Plan Reference Guide (Hugo Kornelis)
- Loop/Merge/Hash Join Operators (Bert Wagner)
- In-Memory OLTP Internals (Kalen Delaney)
- Performance Tuning Using Wait Statistics (Stellato and Kehayias)
- Understanding Log Buffer Flushing (Itzik Ben-Gan)
- Convert Log Sequence Number from Hex (David Maxwell)
- Trace Flags That Are Now Default Behavior (Monica Rathbun)
Information & Guidance
- SQL Server Architecture Guides
- SQL Server Release Blog
- SQL Server Shortcuts (Official Microsoft Links)
- SQL Server Team Blog
- SQL Server Updates
- SQL Server Versions and Builds
- Trace Flags