I just finished the Exploring the TSQL Enhancements in SQL Server 2012 presentation at SQL Saturday 166 in Olympia Washington. Thanks everyone who attended, I hope that you learned something useful. Here is the slides and sample code to download: Whats New in TSQL 2012 If you have any questions, please get in touch with me on Twitter  @SqlEmt  Remember to follow me …

Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code Read more »

Thanks to everyone who attended my CTE presentation at SQL Saturday in Portland Oregon today.   Have a great rest of the day.  As promised I have posted the slides and sample TSQL queries here.  If you have any questions, please get in touch with me on Twitter  @SqlEmt  Remember to follow me on Twitter to stay informed of future presentations. …

Unleashing Common Table Expressions in SQL Server – Slides and Sample Code Read more »

This is a followup to my Whats more important than a backup plan article posted a couple of months ago. When you do a database restore, including log backups, it is very important to get the log chain in the right order, or it won’t work.  To restore a full backup, then log backups, the chain of logs could be …

Restoring A Log Chain Read more »