Almost time to hit the road… and I’m heading to SQL Saturday 31 in Chicago. Rumor has it that this weekend will provide an awesome experience. From the presentations being provided to the karaoke after party – I’m expecting a great time.
If you will be at SQL Saturday 31, please stop by and introduce yourself. And if it suits your fancy, sit down and listen in on my topics. I am scheduled for the following topics:
Using XML to Query Execution Plans
SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of information. From the whether or not the execution plan will rely on parallelism to what columns are requiring a key lookup after a non-clustered index seek. Through a the use of XML this information can be available at your finger tips to help determine the value and impact of an index and guide you in improving the performance of your SQL Server databases.
- Discuss information available in an execution plan
- Demonstrate use of XQuery to query execution cache
- Demonstrate methods to performance tune
Extended Events – Work Smarter, Not Harder
There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.
- Define the architecture for Extended Events
- Identify scenarios where Extended Event can be used to troubleshoot performance
- Demonstrate solutions to real-world performance scenarios
I’ll be staying an extra day in Chicago after the conference, so if anyone has ideas on what I should do please leave a comment. I haven’t been in Chicago since I was 10 or 11 years old so it’s probably changed a bit. So far I have been told to get a hot dog from a street vendor and check out the piers. Any other ideas are very welcome.
PASSMN Meeting Next Tuesday
The Minnesota SQL Server User Group (twitter | website) is meeting next week on Tuesday (4/20/2010). The meeting should be smoking and I’m not meaning the 4-20 kind. The meeting will start with a Visual Studio 2010 for the SQL Developers. Next, Fusion IO (twitter | website) will be on of the presenters on SSD and they have an awesome giveaway – A DRIVE VALUED AT $7,000. If you plan to attend, please, please, please RSVP so that we can order enough food. We were a little too close last month and too little is always awkward.