Dmitri Korotkevitch (aboutsqlserver.com) - SQL Server scripts and books companion materials
Folders:
-
Troubleshooting Scripts - collection of SQL Server Troubleshooting and Diagnostics scripts. Use Azure Data Studio (https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio) to open the files.
-
sp_IndexAnalysis - stored procedure that analyzes index properties along with their usage and operational metrics
-
Blocking Monitoring Framework - Blocking and Deadlock monitoring using Event Notification. See https://aboutsqlserver.com/bmframework for more details
-
Companion Materials - Books' companion materials
-
Presentations - Slides and demo code from presentations. More at: https://aboutsqlserver.com/presentations