Help me pick the next action items for my SQL in Sixty Seconds series. Leave your idea in the comments, and the three best ones win a gift card.
SQL SERVER – SQL in Sixty Seconds – Need Your Opinion
Though this may look very simple to you it is very crucial to me and I would like to know your opinion about it. I have included the latest video.
SQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052
I take my puzzle to the next level with SET ANSI_NULLS OFF. Why do two different queries now return almost the same results? Watch the 60 second video.
SQL SERVER – RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds #051
Episode 51 of SQL in Sixty Seconds shows how to RESEED identity column values to a number higher, or even lower, than the current one.
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.