Balmukund Lakhani shows another lesser known feature of SQL Server Management Studio 2012, hidden in the Connect to Server screen you see every day.
SQL SERVER – The Story of a Lesser Known Startup Parameter in SQL Server – Guest Post by Balmukund Lakhani
Balmukund Lakhani turns his popular SQL Bangalore UG session into a guest post: the story of the -m startup parameter and a lesser known way to use it.
Sharing Query Results From SSMS: Copy With Headers, Grids and CSV
Share SSMS results with copy with headers, text and file output, deliberate CSV quoting, and command-line exports for larger sets.
SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049
Old server names clutter the SSMS Connect dialog. This SQL in Sixty Seconds video shows how to remove cached login entries in SQL Server 2012 and earlier.
SQL SERVER – Enable SQLCMD Mode in SSMS – SQL in Sixty Seconds #048
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.