I’m back in Austin from SQL Saturday 408 in Houston, TX and back at work. The event was a great success and I liked everything from top to bottom. You can get the slides from all the sessions, including mine at the event page.
Learn how to use AutoHotKey to resize your remote desktop sessions back to full screen after minimization in Windows. Never deal with scroll bars in RDP again!
Download my slides and source code from my SQL Saturday 97 presentation.
Incorrect Syntax near go. We’ve all gotten this error before, but why does this happen? Watch a video explaining why you cannot use GO inside of sp_executesql
Learn how to add a date printed and a page count in the footer of your SSRS report. Even if you have errors with Globals!OverallTotalPages.
DateDiff is a great tool in SQL Server. But you have to extend DateDiff a bit to get things in a nicer format, such as HH:MM:SS. See what Rudy found on SQLServerCentral.com which saved the afternoon!
Reset and verify IDENTITY values in SQL Server using DBCC.