Find configuration drift between SQL Server instances, establish a baseline, and separate approved exceptions from settings that need repair.
Finding Unused Indexes
Finding unused indexes requires a measured window, SQL Server usage counters, and a safe removal test before an index earns a drop decision.
SQLAuthority News – First Birthday of Blog – 365 Post in One Year
Today is the first birthday of this blog: 365 posts in one year, one a day. Thank you to my readers, my family and SQL Server Magazine.
Consolidating Small Instances Onto One Server
Consolidating small instances can reduce hardware sprawl when configuration conflicts, peak workloads, licensing, and migration order are checked.
What RESTORE VERIFYONLY Checks and What It Misses
RESTORE VERIFYONLY checks backup readability and checksums, but it cannot prove a full restore or healthy data; pair it with restore tests.
SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards
Pre-code review tips for DBAs: why I check stored procedures on our development server every day for coding standards, with a link to my full article.
SQL SERVER – Difference Between EXEC and EXECUTE vs EXEC() – Use EXEC/EXECUTE for SP always
What is the difference between EXEC and EXECUTE? None. The real difference is EXEC vs EXEC(), and I show why EXEC belongs before every stored procedure call.