Tools and Utilities
- Azure Data Studio
- Best Practices Check
- Diagnostic Information Queries (Glenn Berry)
- DiskSpd
- OpenQueryStore
- OStress (RML Utilities)
- Performance Dashboard Reports
- PowerBI Desktop
- Powershell DBATools
- Redgate Free Tools
- SQL Down Under Tools (Greg Low)
- Sentry One FREE Plan Explorer
- Statistics Parser
- SQL Server Assessment API
- SQL Server Diagnostic Notebook Updated (Emanuele Meazo)
- SQL Server First Responder Kit (Brent Ozar)
- SQL Server Maintenance Solution (Ola Hallengren)
- SQL Server Management Studio (SSMS)
- SQLDiag and SQLNexus
- Tiger Team Toolbox GitHub
- Wait Types Library (SQLSkills.com)
- WhoisActive (Adam Machanic)
Recommended Reading
- Azure SQL for Beginners (61 videos)
- Cardinality Estimations (Microsoft Docs)
- ColumnStore Indexing (Niko Neugebauer)
- Get your ColumnStore ColumnScore
- Constant Time Recovery in Azure SQL Database
- Database Migration Path to 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)
- Parameter Sniffing in SQL Server (Jes Borland)
- Performance Tuning Using Wait Statistics (SQL Skills)
- SQL Virtual Log Files in Transaction Logs (Ahmad Yaseen)
- Understanding Log Buffer Flushing (Itzik Ben-Gan)
- Convert Log Sequence Number from Hex (David Maxwell)
- SQL Server 2019 MAXDOP and Max Memory (Aaron Bertrand)
- SQL Server 2019 TempDB Improvements (Pam Lahoud)
- Trace Flags That Are Now Default Behavior (Monica Rathbun)
Information & Guidance
- Azure Blog
- DB-Engines Ranking
- SQL Server Architecture Guides
- SQL Server Feedback
- SQL Server Release Blog
- SQL Server Standards Support
- SQL Server Shortcuts (Official Microsoft Links)
- SQL Server Support Lifecycle
- SQL Server Team Blog
- SQL Server Updates
- SQL Server Versions and Builds
- Trace Flags
Community Websites
- Personal Book Recommendations
- Azure Data Community
- Community Circle (Redgate)
- Data Grillen
- DBA Fundamentals Virtual User Group
- EightKB – SQL Server Internals
- GroupBy Conference
- Guy in a Cube (Power BI)
- Microsoft SQL Tips
- PASS TV
- Simple Talk (RedGate)
- SQL Authority (Pinal Dave)
- SQL Performance
- SQL Server Central
- SQL Server Pro
- SQL Shack
- SQL Skills Blogs
- Team Senty One