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 CPU Pressure on VMware: When Low CPU Ready Means the Problem Is Yours – SQLYARD Leave a Comment / Articles, …
SQL Server 2022 Hidden Gem: Instant File Initialization Now Works with TDE on Transaction Logs – SQLYARD Leave a Comment / Articles, …
SQL Server From the Ground Up: The Complete Beginner’s Guide – SQLYARD Leave a Comment / Articles, Operations / By SQLYARD SQL …
Featured
Articles
Introduction Continuing SQL Server 2025’s expansion of native regular expression support, today we cover two functions that focus on location and frequency: …
SQL Server 2025 Security Modernization: What DBAs Need to Know – SQLYARD Leave a Comment / Articles, DBA Checklist, Scripts / By …
Introduction SQL Server 2025 continues expanding its native regular expression capabilities with two highly practical functions: • REGEXP_SUBSTR() – extract a substring …
Understanding Long Sync IO in SQL Server: Scheduler in Nonpreemptive Mode Longer Than 1000 ms – SQLYARD Leave a Comment / Articles, …
SQL Server 2025: REGEXP_LIKE() – Native Regular Expressions Arrive** Introduction SQL Server has never had true regular expression support built into the …
SQL Server 2025: BASE64_ENCODE() and BASE64_DECODE()** Introduction SQL Server has always required custom functions, CLR code, or external tools to handle Base64 …
SQL Server 2025: The New PRODUCT() Aggregate Function** Introduction SQL Server 2025 introduces a small but surprisingly powerful new aggregate function: PRODUCT(). …
Introduction If you have spent time tuning SQL Server queries, you have probably seen advice like “avoid implicit conversions” or “make sure …
SQL Server 2025: JSON Index Deep Dive** Introduction One of the most important features in SQL Server 2025 is the new JSON …
SQL Server 2025: Native JSON Data Type and New JSON Functions** Introduction For years, SQL Server developers and DBAs have been storing …
SQL Server Security Model 2026: Least Privilege, Roles, and Authentication Best Practices – SQLYARD Leave a Comment / Articles / By SQLYARD …
Summary for Parts 0 through 11 Modern analytics platforms are no longer simple data warehouses with nightly ETL jobs. Enterprises today operate …
Part 11 — Data Quality, Testing, Validation, and Observability – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts / By SQLYARD …
Part 10 — Orchestration and Automation – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts / By SQLYARD Deep Technical Series …
Part 9 — Designing the Semantic Layer and Metrics Layer – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts / By …
Part 8 — Implementing the Lakehouse: Fabric, Databricks, and AWS – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts / By …
Part 7 — Implementing the Warehouse: Snowflake, Fabric, BigQuery, Synapse, and Redshift – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts …
Part 6 — Transformations Part 2: SCD Types, Fact Loading, Spark, and Merge Optimization – SQLYARD Leave a Comment / Articles, Data …
In-Memory OLTP (Memory-Optimized Tables) in SQL Server: A Complete Guide – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD …
Part 5 — Transformations Part 1: ELT Strategy, dbt Modeling, and SQL Pipelines – SQLYARD Leave a Comment / Articles, Data Engineering, …
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.