SQL Server 2025 Fundamentals: A Practical Guide from Basics to Advanced – SQLYARD Leave a Comment / Articles, DBA Checklist / By SQLYARD SQL Server 2025 Fundamentals: A Practical Guide from Basics to Advanced By David Yard · SQLYARD.com · April 2026 · Estimated read: 22–28 min Table of Contents What SQL Server 2025 Fundamentals […]
SQL Server 2025 Fundamentals: A Practical Guide from Basics to Advanced Read More »
SQL Server 2025 Security Modernization: What DBAs Need to Know – SQLYARD Leave a Comment / Articles, DBA Checklist, Scripts / By SQLYARD SQL Server 2025 Security Modernization: What DBAs Need to Know By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Table of Contents Security Changes at a Glance TDS
SQL Server 2025 Security Modernization: What DBAs Need to Know Read More »
Understanding Long Sync IO in SQL Server: Scheduler in Nonpreemptive Mode Longer Than 1000 ms – SQLYARD Leave a Comment / Articles, DBA Checklist, Scripts / By SQLYARD Understanding Long Sync IO in SQL Server: Scheduler in Nonpreemptive Mode Longer Than 1000 ms By David Yard · SQLYARD.com · April 2026 · Estimated read: 18–22
Introduction SQL Server 2025 marks one of the biggest shifts in the SQL Server ecosystem since the 2016 release. We finally get native JSON storage, full RegEx support, BASE64 functions, PRODUCT aggregates, JSON indexes, and the long-awaited external REST endpoint invocation. The goal of this series is to walk through every major new engine feature
SQL Server Security Model 2026: Least Privilege, Roles, and Authentication Best Practices – SQLYARD Leave a Comment / Articles / By SQLYARD SQL Server Security Model 2026: Building a Least-Privilege Architecture That Scales By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Table of Contents Core Security Principles What Changed in
A Complete Playbook for Modern DBAs SQL Server health checks are one of the few things that never go away in a DBA’s career. It does not matter if you inherit a system, support a system that has been running for years, or walk into a new environment where the last DBA left suddenly. Someone
The Ultimate SQL Server 2019 and 2022 Health Check Guide Read More »
SQL Server 2025 (17.x) is the first release in a long time that feels like more than “2022 with patches.” It is aimed at AI-heavy, hybrid, and event driven workloads while still giving DBAs and developers practical wins around JSON, performance, security, and HA. At the time of writing, SQL Server 2025 is still in
SQL Server 2025: New Features You Actually Need To Care About Read More »
Understanding and Cleaning Up Overlapping Indexes in SQL Server – SQLYARD Leave a Comment / Articles, DBA Checklist, Scripts / By SQLYARD Understanding and Cleaning Up Overlapping Indexes in SQL Server By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Compatibility: All scripts work on SQL Server 2017 and later. Script
Understanding and Cleaning Up Overlapping Indexes in SQL Server Read More »
Introduction For years, performance tuning in SQL Server has meant digging through execution plans, adding indexes, or rewriting queries to coax the optimizer into better behavior. With SQL Server Management Studio (SSMS) v22 Preview 3, Microsoft is introducing something new: the Query Hint Recommendation Tool. This feature lets you quickly experiment with optimizer hints, compare
SSMS v22 Query Hint Recommendation Tool: A New Era of Query Optimization Read More »
Introduction DBCC CHECKDB is one of the most critical commands in a SQL Server DBA’s toolkit. It verifies the logical and physical integrity of all the objects in a database, helping you catch corruption early—before it turns into a recovery nightmare. In modern versions like SQL Server 2022, data purity checks are built in by
DBCC CHECKDB: Practical Integrity Checking for Large SQL Server Databases Read More »
