Built by a DBA,
Designed for Data Professionals
Operational intelligence for SQL Server performance, availability, security, governance, and AI-powered insights.
Latest DBA Research
Power BI DirectQuery vs Import Mode: What Every SQL Server DBA Needs to Know – SQLYARD Leave a Comment / Articles, Power …
The Microsoft Data and AI Stack Explained: How SQL Server, Fabric, Power BI, Foundry, and MCP Fit Together – SQLYARD Leave a …
Microsoft Foundry for SQL Server Professionals: Hub, Projects, Connections, and the DBA’s Role – SQLYARD Leave a Comment / Articles, AI for …
Featured
Articles
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 …
This builds on Part 2. Instead of only emailing what happened in the last 24 hours, we will: Everything below is copy-paste …
Group counts, suppress noise, and email a clean daily report This follow-up builds on Part 1. Instead of reading the entire error …
The SQL Server Error Log is your first stop when something looks off. It records startup messages, configuration changes, critical errors, I/O …
Did you ever wonder if the plural of index in SQL Server should be indexes or indices? You’re not alone—this question comes …
This series walks through setting up a resilient SQL Server Always On Availability Group (AG) with two on-premises nodes, one Azure replica, …
If your seeing these in your SQL server error log they all tie together Error 17806, Severity 20, State 14 with text …
Example message AppDomain 3 (master.sys[runtime].2) created. What this message means (plain English) SQL Server hosts the .NET Common Language Runtime (CLR). When …
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.