Thank you to everyone who attended my three sessions at this year's TechEd show in New Orleans. I had a great time presenting and answering the really great questions posed by attendees. My sessions were: DAT317 T-SQL Power! The OVER Clause: Your Key to No-Sweat Problem SolvingHave you ever stared at a convoluted requirement, unsure of where to ...

Thanks to everyone who attended my sessions this week at SQL Server Magazine Connections in Las Vegas. Attached to this post you will find the demos for the following sessions: SDV301: Best Practices for Exception Handling and Defensive Programming in SQL Server 2005 and 2008As developers, we sometimes become lax about dealing with error ...

On Tuesday night I was honored to present a new talk to the Cape Cod .NET Users Group that meets in Plymouth, MA. The talk is called ''T-SQL Power! Learning to Harness the Under-Used OVER Clause''. Following is the abstract for the talk:First introduced in SQL Server 2005, the OVER clause is an ANSI SQL enhancement that gives you tremendous ...