Enable SQLCMD mode in SSMS and use sqlcmd right inside SQL Server Management Studio, for example to switch between servers in one script.
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.
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.
SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD
Good DBAs automate the boring work. Here is a simple script to run Backup and Restore of a database from the command prompt with SQLCMD.
SQL SERVER – Generate Random Values – SQL in Sixty Seconds #042 – Video
There are many ways to generate random values in SQL Server. In this sixty second video I show a neat trick to get a random value between two numbers.