Enable SQLCMD mode in SSMS and use sqlcmd right inside SQL Server Management Studio, for example to switch between servers in one script.
What Is a Deadlock in SQL Server?
A deadlock in SQL Server is two sessions each holding what the other needs. I caused one on purpose and read error 1205. Why it is not the same as blocking, who gets killed, and the boring fix that works.
SQL SERVER – Resolve Cannot Resolve Collation Conflict Error – SQL in Sixty Seconds #047
A collation conflict error is common when databases use different collations. This SQL in Sixty Seconds video shows how to resolve it and why collation matters.
SQL SERVER – Shortcut to SELECT Single Row from Table – SQL in Sixty Seconds #046 – Video
Many readers struggled with my blog post on this, so here it is as a video: a SQL Server Management Studio shortcut to select single row from any table.
What Is a Star Schema?
A star schema is one fact table surrounded by dimension tables. What facts and dimensions hold, why grain is the decision you cannot undo, why the data repeats on purpose, and a worked example in AdventureWorksDW.
SQL SERVER – Cycle Clipboard Ring in SSMS – SQL in Sixty Seconds #045 – Video
Copy and paste only gives you the last item you copied. This SQL in Sixty Seconds video shows how the Cycle Clipboard Ring in SSMS pastes earlier items too.
SQL SERVER – Get SQL Server Version and Edition Information – SQL in Sixty Seconds #043 – Video
Here is a quick way to find the SQL Server version and edition in sixty seconds, plus how to read version numbers and map them to each release.