Color code the SQL Server Management Studio status bar so you always know which server you are on before you run a script. A quick video.
What Is a Primary Key, and What Happens Without One?
A primary key is the promise that every row can be told apart. Why NULL is refused, what a table without one actually costs you, how it differs from a unique constraint, and when to choose a natural key over a made up one.
What Distributed SQL Means and What It Costs
Understand distributed SQL through data placement, compute and storage roles, write coordination, and the latency and operating costs behind scale.
SQL SERVER – How do I Record Video and Webcast – Milestone – 2200th Blog Post – SQL in Sixty Seconds #022 – Video
My 2200th blog post and the 22nd SQL in Sixty Seconds episode: a short video on how I record video and webcast content, plus thanks to the people who help.
SQL SERVER – Generate Script for Schema and Data – SQL in Sixty Seconds #021 – Video
Need to move part of a database along with its data? SQL in Sixty Seconds #021 shows how SSMS can generate a script for Schema and data together.
SQL SERVER – Remove Debug Button in SSMS – SQL in Sixty Seconds #020 – Video
The SSMS debug button sits next to Execute and looks like a play button, so people click it by mistake. This short video shows how to remove it.
SQL SERVER – Tricks to Comment T-SQL in SSMS – SQL in Sixty Seconds #019 – Video
Three quick ways to comment T-SQL code and uncomment it in SSMS, starting with keyboard shortcuts. A SQL in Sixty Seconds video that saves time while debugging.