Schedule restore tests that select current backups, move files to an isolated server, run CHECKDB, record failures, and rotate databases.
Consultant’s Life – 30 Minutes Pre Call With Customer for SQL Server Performance Tuning
A Pre Call gives a performance-tuning engagement a clear starting point. I want to understand the symptom and what the customer needs.
SQL SERVER – Understanding How to Play With Row Constructor
A code review surprised me with an unusual use of the Row Constructor. Here is what the code did and how you can play with row constructors yourself.
How to Find Recent Executed Queries in SQL Server? – Interview Question of the Week #087
An interview question that stumped candidates: how do you find recent executed queries in SQL Server? A DMV script using sys.dm_exec_query_stats answers it.
SQL SERVER – SSMS Enhancement – Databases Node Filter Capability
A client with 86 databases struggled to find one in Object Explorer. A newer SSMS Enhancement lets you filter the Databases node. Here is how it works.
SQL SERVER – Find Week of the Year Using DatePart Function
The DATEPART function returns a week number according to its week definition. I choose that convention before using calendar logic.
Finding Orphaned Child Rows Before Adding a Foreign Key
Find orphaned child rows before adding a foreign key, review their business meaning, validate relationships, and confirm constraint trust.