The first video in our professional development series, led by Nupur Dave, is about how to avoid procrastination and stop putting things off.
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.
SQL SERVER – TRIM Function to Remove Leading and Trailing Spaces of String – SQL in Sixty Seconds #040 – Video
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.