Blog

    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

    SQL Server Monitor: HOBT_ID Associated ObjectID Explained

    Mar 14, 2025Simon Dang

    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.

    Read more
    SQL Server Monitor: Index Recommendations for Better Performance

    SQL Server Monitor: Index Recommendations for Better Performance

    Mar 14, 2025Simon Dang

    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.

    Read more
    SQL Server Monitor: Azure SQL Connection Failure Logs

    SQL Server Monitor: Azure SQL Connection Failure Logs

    Feb 05, 2025Simon Dang

    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.

    Read more
    SQL Server Monitor: Manage Azure Synapse Dedicated SQL Pool

    SQL Server Monitor: Manage Azure Synapse Dedicated SQL Pool

    Aug 30, 2024Simon Dang

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

    Read more
    SQL Server Monitor: List All Connections and Activities

    SQL Server Monitor: List All Connections and Activities

    Aug 30, 2024Simon Dang

    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.

    Read more
    SQL Server Monitor: Database Backup Status and Best Practices

    SQL Server Monitor: Database Backup Status and Best Practices

    Mar 02, 2024Simon Dang

    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.

    Read more
    SQL Server Monitor: Linked Server to MS Azure Fabric Database / Datawarehouse

    SQL Server Monitor: Linked Server to MS Azure Fabric Database / Datawarehouse

    Feb 28, 2026Simon Dang

    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.

    Read more
    SQL Server Monitor: Troubleshooting Windows Permissions with xp_logininfo

    SQL Server Monitor: Troubleshooting Windows Permissions with xp_logininfo

    May 22, 2026Simon Dang

    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.

    Read more
    Azure SQL DBA Tools: Deadlocks

    Azure SQL DBA Tools: Deadlocks

    February 27, 2024Simon Dang

    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.

    Read more
    SQL DBA Tools: Sudden Performance Drops via Parameter Sniffing

    SQL DBA Tools: Sudden Performance Drops via Parameter Sniffing

    August 6, 2026Simon Dang

    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.

    Read more

    © 2026 Crystal Enterprise, LLC. All rights reserved.