What Is Big Data? It is the point where data outgrows one machine, and the fix is to scale out. This post explains the failures of one server and walks through 40 TB split across 8 nodes.
SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video
The first SQL in Sixty Seconds video shows how to convert subquery to CTE in about a minute. Short, easy tips from my co-authors and me.
Application Roles: Permissions That Follow the App, Not the User
Application roles sound like a lock only your app can open. This demo shows what the switch really does and why the password is the whole key.
Capturing Autogrowth Events With database_file_size_change
A data file grew over the weekend and nobody owns up. This small demo shows how one extended event tells autogrowth from a manual resize.
EXISTS vs COUNT: The Right Way to Check If Rows Exist
Need a yes or no? Ask EXISTS. Need a number? Ask COUNT. Here is a small demo that shows why mixing them up can quietly give the wrong answer.
Foreign Keys Across Databases: What to Use Instead
SQL Server will not create a foreign key to another database. Here is the real error, why a report is only detection, and a same-database option that enforces.
Error 3241 on Restore: Newer Version or Damaged Backup File
Error 3241 only says SQL Server could not read the file as a backup. Here are three broken files, three different messages, and the checks to run first.