It’s time to switch to a new development tool for SQL Server and Azure SQL. Here’s how to get started with the MSSQL extension for Visual Studio Code. Microsoft recently ended support for Azure Data ...

You're a DBA, sysadmin, or developer who manages Microsoft SQL Servers. It's your fault if they're down or slow. These tools help you understand what's going on in ...

Ever have a performance problem, but don't know what performance counters to collect or how to analyze them? The PAL (Performance Analysis of Logs) tool is a powerful tool that reads in a performance ...

Enterprises with on-premises SQL Server infrastructure face a choice by January 2027: migrate database monitoring to Azure’s consumption-based billing, or lose support for critical SCOM Management ...

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even though we probably won't. For all its popularity and success, SQL is a ...

Database administrator with 14+ years of hands-on experience in database management and database design. This DMV tracks how often indexes — including heap tables (which have index_id = 0) — are used ...