Tired of writing one INSERT per row? This SQL in Sixty Seconds video shows three methods to insert multiple rows into a single table.
SQL SERVER – Color Coding SQL Server Management Studio Status Bar – SQL in Sixty Seconds #023 – Video
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.
Comparing Session SET Options Between SSMS and the Application
Fast in SSMS, slow in the app? The query may be fine and the connection settings different. Here is how to check, with nothing to set up.
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 – 2012 Functions – FORMAT() and CONCAT() – An Interesting Usage
An interesting way to use the SQL Server 2012 FORMAT() and CONCAT() functions together to show a string like Current Time is Sunday July 16, 2012.
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.