My Presentation at “24 Hours of PASS” event - “Tips and Tricks for writing SET based queries”

It was a pleasure presenting at ‘24 Hours PASS’ event this morning and I would like to thank all of you who attended the session. For those who missed the session, the recorded version will be available at PASS website soon.

What is “24 Hour PASS” event?

“24 Hour PASS” event (24HOP) is a 24 hour FREE SQL Server Training Webcast organized by the Professional Association for SQL Server (PASS), an independent, not-for-profit association dedicated to supporting, educating, and promoting the Microsoft SQL Server Community.

Twenty Four speakers from all over the world presented 24 sessions – one session every hour – starting from 00:00 hours GMT on 2nd September 2009. Eminent speakers like Allen White, Gail Shaw, Greg Low, Kalen Delaney, Kevin Kline, Louis Davidson, Paul Nielsen, Steve Jones etc made the 24HOP a must-attend session for every SQL Server professional.

Community Rocks!

What is so lovely about this event was the amount of effort volunteers from PASS HQ, PASS Chapter and SQL Server community have put into making it a big success. Each session was hosted and moderated by a PASS chapter. People at like Rick, Blythe, Chuck at PASS HQ have worked round the clock to make sure that everything is well organized. A large number of volunteers from PASS Chapters across the world showed their commitment to the SQL Server community by being the host and moderators of each session. These moderators assisted the attendees and presenter by managing the live meeting, helping people having trouble with using the live meeting interface, assisting them with Q&A etc.

You may be surprised when I say that each session was supported by a ‘backup-moderator’ and a number of ‘backup-bakup-moderators’. That shows the spirit :-)

My Session: Tips and Tricks for writing SET based queries

My session - “Tips and Tricks for writing SET based queries” - focused on exposing some of the tips and tricks for writing efficient TSQL queries that solves common business problems using a SET based approach. In most cases, a SET based query may be found to be a better choice over a piece of PROCEDURAL code.

My session included dozens of TSQL demos that presented a number of ways of writing TSQL queries to solve common business problems. We examined the different versions of the queries, starting with a simple version and incrementally presented better options resulting in the best practice solution to the problems

Download the demo scripts

I have uploaded all the demo scripts we examined during the presentation and you can download it from here.

Feedback and rating

I will be very happy to hear your feedback and please do send me emails with your comments. If you have attended the session, please rate my talk at http://speakerrate.com/talks/1434-tips-and-tricks-for-writing-set-based-queries

If you like this article,  Subscribe in a reader or Subscribe by Email. Show your support by sharing this article with your friends through the services given below.