Error 3702 says you cannot drop the database because it is currently in use, and even speakers get stuck on it. Here are simple ways to get past it.
SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083
Statistics help the SQL Server engine pick an optimal plan. This Notes from the Field episode covers the basics of statistics maintenance every DBA should know.
SQL SERVER – Finding Out Identity Column Without Using Column Name
Did you know SELECT $identity finds the identity column without using column name? Here is how it works, and how to check if a table has one.
Interview Question of the Week #022: How to Get Started with Big Data?
When an interviewer asks how you would get started with big data, a list of tools is the weakest answer. This post gives a short model answer: start from SQL, learn the core ideas, run one engine on a laptop and build one small project end to end.
Deep Work Time: Book It Like a Server Maintenance Window
Deep work time disappears unless you book it. This post treats your own focus like a server maintenance window: a named block, a runbook, an emergency rule and a short review. Try two 90-minute windows this week.
Deleting From a Heap: Why Empty Pages Stay Behind
The rows are gone but the table is the same size and scans are just as slow. Here is why, and two ways to fix it.










