SQL Server has no TRIM function, and calling it gives error Msg 195. This SQL in Sixty Seconds video shows how to remove leading and trailing spaces without it.
SQL SERVER – Send Email From SQL Server – Configure Database Mail – SQL in Sixty Seconds #039 – Video
SQL Server is not mass mailing software, but it does need to send job alerts. This video shows how to configure Database Mail and send email quickly.
SQL SERVER – Wrap SQL Code in SSMS – SQL in Sixty Seconds #038 – Video
Horizontal scrolling makes code hard to read. In this SQL in Sixty Seconds video I show how to wrap SQL code in SSMS without changing anyone’s formatting.
SQL SERVER – Select and Delete Duplicate Records – SQL in Sixty Seconds #036 – Video
Look before you delete. This SQL in Sixty Seconds video shows one script to select duplicate records and another to delete them while keeping the latest row.
SQL SERVER – Inviting Ideas for SQL in Sixty Seconds – 12/12/12
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 – 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.