SQL PASS Summit 2012

Nov 6th -9th seemed like a whirlwind with the PASS Summit seeing a record number of registrations and probably a record number of first timers as well! The number of people thronging towards the Washington State Convention Center in the morning was a sight to see! The hotels around the convention center were over booked. If you were one of those individuals who booked late, then you either ended up paying steep prices or not getting your preferred rooms. The evenings of the event days saw most of the eating joints being thronged by the PASS attendees where the networking continue till late into the night!

Not only was this a fun event but I did manage to meet a number of folks (Tweeps) face-to-face that I interact with on Twitter or other technology forums. I did miss out on meeting a few folks that I wanted to but that would have to be now done at another time and place. I also got to meet other folks from the CSS (Bob Ward, Adam Saxton, Rohit Nayak and more) and SQL CAT teams with whom I interact with on a regular basis but hardly get to meet regularly due to the cross geographical locations.

The evening revelry also showed why Twitter is a powerful medium of communication. The venues were decided and broadcasted using the Twitter hashtag #sqlpass. Some of the post event parties had some highlights as well like the flash mob…. The karaoke sessions at the Hard Rock Café…. The Unicorn seemed to be having a ball!! (If you were there, you know what I am talking about).

I had recently co-authored a book, Professional SQL Server 2012: Internals and Troubleshooting, which was launched at the event. There was a book signing session with the authors where we gave 30 books through a lucky draw. Thank you SQL Sentry for sponsoring this! Smile


I was also part of the SQL Server Clinic on all three days. I met with various customers who brought their design and troubleshooting related questions which spanned all areas of the product. We were staffed at the clinic with the engineers from all areas of expertise. So it was just a matter of walking up to the SQL Server Clinic, locating the expert and asking your question. I even looked at memory dumps at the Clinic! Smile Below is picture of one of the peak times at the clinic. The green shirts are the folks that were answering the questions!


#SQLFamily truly rocks! And this year’s #SQLPASS summit was #Awesome! – That is my Twitter update summarizing the event!

SQL PASS and Book Launch

Day 1 done at the SQL PASS Summit 2012!! …. It was a packed day with some interesting events starting with the Keynote session. I spent most of my day at the SQL Server Clinic meeting customers and discussing their work with SQL Server and helping them with suggestions and answers to the questions they had regarding the product. Most of all, I enjoyed meeting all the friends that I made on Twitter in person. It is always good to connect a face to a virtual name that you interact with.

Day 2 will be much more interesting as I will be part of the official launch of the book, Professional SQL Server 2012 Internals and Troubleshooting, that I have co-authored with Christian Bolton, James Rowland Jones, Glenn Berry, Justin Langford and Gavin Payne.

You will still find me at the SQL Server Clinic or have me loitering about near Exhibition Hall 4. In case you still can’t locate me, send a tweet across my way (@banerjeeamit). In partnership with SQL Sentry at the exhibitors stand from 12:30 on Thursday 8th November the authors will be available for a book signing event which will give you the chance to meet and greet the authors and contributors. This book is truly a great example of collaboration and community power where the authors have interacted over email for months but have met each other only once. And for some, this summit is their first face-to-face meeting!

SQL Sentry also have lots and lots of copies to give away for free so be sure to drop by their stand and ask about it! The book is also available at the PASS bookstore for sale. So if you want one, head out there and grab a copy.

You can also order it from your favorite online retailer:

Amazon.com: http://amzn.to/U9IlPV

Barnesandnoble.com: http://bitly.com/Ux1gog


SQL Saturday 76: The WiFi gods were happy


I just concluded my presentation on “Debugging the Deadlock for the Scheduler” at SQL Saturday 76 over a Lync meeting. The WiFi and Lync gods decided to be benevolent today and let me present without an untoward incident! As always it was fun to demonstrate the use of a debugger…Winking smileThe attempt of the presentation was to demonstrate what can be done proactively and reactively when dealing with a deadlocked schedulers condition.

A special thank you is due to all the sponsors without whom the event today wouldn’t have been possible: Microsoft New Zealand, RedGate, SQL Pass, New Zealand MS Communities and SQL Services!

The slide deck used for presentation today is available on Slide Share and is embedded below:

The demo files used are available at SkyDrive in the file SQLSat76_Demo.zip The walkthrough for the debugging that I explained along with the use of the Powershell script to automatically collect DMV outputs based on messages in the Windows Application event log are available using the posts available under the walkthroughs link below as well as the zip file mentioned above.

And last but not the least, a big Thank You to Dave [Twitter | Blog] for helping arrange all the logistics so that I could present and also for giving me this opportunity!


Whitepaper: How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888



Microsoft Public Symbol Server

KB: New concurrency and scheduling diagnostics have been added to SQL Server


SQL Saturday #76: Gearing up for the fun remotely

imageI am quite excited about this Saturday (January 28th, 2012) which will witness SQL Saturday #76 being organized at Auckland. This time around I will not be physically present for the event but will be presenting via Live Meeting on “Debugging the deadlock for the scheduler”. It would have been awesome to be there in person but I shall make the most of the remote opportunity! As they say… If wishes were horses, even beggars would ride! I am going to show you some cool stuff that you can do when you encounter a Deadlocked Schedulers scenario in SQL Server including a demo on debugging a SQL dump!

There are a bunch of other interesting sessions on a whole gamut of topics for you to pick and choose from! Space is limited so if you want to attend and be part of the fun and learning, then get yourself registered here pronto. The list of sessions that for the day are available here.

Venue: Microsoft New Zealand, Level 5, 22 Viaduct Harbour Ave, Auckland CBD
Date: January 28th, 2012
Time: Registration opens at 8.30AM NZ time | Event will conclude around 5PM NZ time

Looking forward to another fun-filled Saturday! Winking smile