SQL Server DBA Tools & Tips
Practical queries, scripts, and techniques for SQL Server and Azure SQL database administration.

SQL Server Monitor: HOBT_ID Associated ObjectID Explained
Understanding the HOBT_ID field in SQL Server — what it represents, how it's used in system views, and practical applications for storage analysis and performance tuning with a SQL Server monitor.

SQL Server Monitor: Index Recommendations for Better Performance
A T-SQL query to get a list of all table index recommendations in SQL Server or Azure SQL, including improvement measures and usage statistics for SQL Server monitoring.

SQL Server Monitor: Azure SQL Connection Failure Logs
A simple query to run within the master database on any Azure SQL Server to view all failed connections. Essential for SQL Server monitoring and diagnosing connectivity issues.

SQL Server Monitor: Manage Azure Synapse Dedicated SQL Pool
Query tools for monitoring and managing your Azure Synapse, Dedicated SQL Pool, or Data Warehouse — including sessions, blocking analysis, and TempDB monitoring.

SQL Server Monitor: List All Connections and Activities
A straightforward query every DBA needs for SQL Server monitoring — lists all connections and blockings, similar to Activity Monitor in SSMS but more versatile and customizable.

SQL Server Monitor: Database Backup Status and Best Practices
Essential tips for SQL Server monitoring of database backups, including a comprehensive query to list the last backup date for every database in your server.

SQL Server Monitor: Linked Server to MS Azure Fabric Database / Datawarehouse
Step-by-step guide to creating a linked server from SQL Server to Microsoft Azure Fabric Database or Datawarehouse using an ODBC bridge and service principal authentication.
SQL Server Monitor: Troubleshooting Windows Permissions with xp_logininfo
Learn how to use xp_logininfo to troubleshoot SQL Server Windows authentication issues, audit AD group memberships, and diagnose permission problems — an essential tool for any SQL Server DBA.
Azure SQL DBA Tools: Deadlocks
Deadlocks can cause delays and disruptions in Azure SQL Database. Learn how to detect deadlocks using Extended Events, query deadlock graphs, and resolve them with query optimization and retry logic.
SQL DBA Tools: Sudden Performance Drops via Parameter Sniffing
Parameter sniffing can cause a stored procedure that usually runs instantly to suddenly take minutes — with no code changes. Learn how to diagnose and fix it using four proven SQL Server DBA techniques.