SQL Saturday 408 – Event Wrap Up
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.
Remote Desktop won’t go back to Full Screen Part 2
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!
SQL Saturday 97 Slides and Code – EXCEPT, INTERSECT, APPLY
Download my slides and source code from my SQL Saturday 97 presentation.
Incorrect Syntax Near go revisited
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
Display a Page Count in SSRS
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.
Using datediff to display results as HH:MM:SS
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!
Determine Tables Sizes in SQL Server
Everyone is worried about their database size. Even though storage is relatively cheap, if your database is growing linearly or exponentially, you’re going to run into issues down the road. One quick way to check things out is to look at your table sizes. I looked all over the web and found Mitch Sellers’ blog...
Use SQL Server DMVs to find a table’s IDENTITY Column
Use SQL Server DMVs to find a table's IDENTITY Column. The SQL Server DMVs sys.objects and sys.columns contain valuable information that can identify IDENTITY Columns.
Incorrect syntax near ‘GO’ when creating Dynamic SQL
Learn about line breaks when creating dynamic SQL.
Remote Desktop won’t go back to Full Screen after Minimization in Windows 7
Learn how to get your remote desktop back to full screen after Minimization
Using Windows Media Center on a Dual Screen Setup with Windows 7 x64
If your PC came with Windows 7, chances are you already have Windows Media Center installed. Some PCs come with a built in TV tuner, or you can get an external TV tuner at a reasonable price at your favorite store. One of the neat things about having a TV tuner on your machine is...
