On 12/12/12, my wedding anniversary, I look back at 35 videos so far and invite your ideas for SQL in Sixty Seconds, the one minute learning series.
SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video
A sixty second video on how to concat strings in SQL Server, from the plus sign to the SQL Server 2012 CONCAT function that needs no casting.
SQL SERVER – Auto Recovery File Settings in SSMS – SQL in Sixty Seconds #034 – Video
SSMS crashed before you saved your query? This SQL in Sixty Seconds video shows the Auto Recovery settings that keep the loss down to a few minutes.
SQL SERVER – Display Datetime in Specific Format – SQL in Sixty Seconds #033 – Video
Date formats change from country to country. This SQL in Sixty Seconds video shows two ways to display datetime in a specific format in SQL Server 2012.
SQL SERVER – Rename Columnname or Tablename – SQL in Sixty Seconds #032 – Video
Picked the wrong name for a column or a table? This SQL in Sixty Seconds video shows how to rename a column and a table in SQL Server.
SQL SERVER – Copy Data from One Table to Another Table – SQL in Sixty Seconds #031 – Video
Many developers still use a cursor to copy data from one table to another. This SQL in Sixty Seconds video shows INSERT INTO SELECT and SELECT INTO instead.
SQL SERVER – Resolving SQL Server Connection Errors – SQL in Sixty Seconds #030 – Video
A sixty second video on resolving SQL Server connection errors, the kind first time IT pros often hit after a fresh install and cannot figure out.