Built by a DBA,
Designed for Data Professionals
Operational intelligence for SQL Server performance, availability, security, governance, and AI-powered insights.
Latest DBA Research
SQL Server Index Fragmentation and Statistics: Detection, Alerting, and Maintenance Without Assumptions – SQLYARD Leave a Comment / Articles, Performance Tuning, Scripts …
Connecting Django to SQL Server: The Official mssql-django Backend Explained – SQLYARD Leave a Comment / Articles, Cloud and Azure / By …
DP-800 SQL AI Developer Associate: The Complete Study Guide for SQL Server Professionals – SQLYARD Leave a Comment / Articles, Certification / …
Featured
Articles
In the last part of this series, we explored Azure Database for MySQL. Now let’s look at its close cousin: Azure Database …
SQL Server Blocking Detection Without SQL Agent: A Service Broker Timer Solution – SQLYARD Leave a Comment / Articles, Operations, Scripts and …
So far in this series, we’ve looked at Cosmos DB (Part 1) for globally distributed NoSQL workloads and Azure Data Lake (Part …
Replication is great until it gets quiet and drifts out of sync. The fix is simple: collect errors and backlog on a …
What’s New for Columnstore Indexes in SQL Server 2025 – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD What’s …
In Part 1 of this series, we explored Azure Cosmos DB and why you might reach for it when building low-latency, globally …
How to plan, convert, move, and validate—without surprises Migrating between PostgreSQL and SQL Server (including AWS RDS/Aurora) can feel daunting, but with …
When people first look at data services in Azure, they usually know SQL Database or maybe Azure Data Lake. But Azure has …
If you’re new to Azure SQL, it can feel like a lot: Single databases, elastic pools, serverless, Hyperscale, Managed Instance, and full …
A Detailed Comparison for DBAs and Developers When you’re responsible for keeping databases fast and reliable, two tools come up often: SolarWinds …
When running schema changes or creating indexes in SQL Server, you may encounter an error like this: This is not a tool-specific …
A Beginner-to-Advanced Guide to Query Store in SQL Server – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD A …
Summary SQL Trace and SQL Server Profiler are deprecated. They still open, but Microsoft invests in Extended Events. Extended Events gives lower …
This article continues from Part 1, where we looked at CPU, NUMA, and vSphere configuration best practices for SQL Server in a …
Environment: Always On availability groups Summary You may see these entries in the SQL Server error log: Short version: a few lines …
Understanding Virtual Log Files (VLFs) in SQL Server – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD Understanding Virtual …
If you’re new to SQL Server and you want query speed without guesswork, learn indexes. This guide walks you from first principles …
Amazon EC2 offers flexibility to run enterprise-grade Windows workloads with full control over the OS, networking, storage, and high availability options. Getting …
Running Microsoft SQL Server on VMware vSphere offers flexibility, high availability, and scalability, but only when the environment is configured correctly. Misconfigurations …
Short answer: yes. Moving your databases to SSDs/NVMe arrays (even the fancy enterprise ones) doesn’t remove the need for DBCC CHECKDB. Fast …
All technical content on SQLYARD is verified against Microsoft documentation at the time of publication. SQL Server features, cloud service capabilities, licensing terms, and configuration requirements can change between versions and cumulative updates. Always validate against current Microsoft Learn documentation before deploying to production.