TechEd India is around the corner and I have two sessions in TechEd India. I am excited and nervous as well. TechEd is a special event and I am going to present 4th time in this event. This time the event is in two location – Bangalore and Pune. Performance Tuning is my favorite subject and I love to talk about it endlessly. If you know me personally, you might be familior with how I present any session.
I promise that when you walk out of the session you will have gained learning which you can implement right away at the in your daily job. Here is one more interesting details if you attend my session I will have special goodies for you. You may win my brand New SQL Server 2012 book combo set (worth RS 4000). I will have two sets of the combo sets to give away during the sessions. Additionally, I will have a few of my SQL Server Interview Questions and Answers books as well.
Here are details of my two of the sessions.
SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions
Date: March 18, 2013 – Bangalore
Date: March 25, 2013 – Pune
Time: 2:45 – 3:45 PM
Many believe Performance Tuning and Troubleshooting is an art which has been lost in time. The truth is that art has evolved with the time and there are more tools and techniques to overcome ancient troublesome scenarios. There three major resource when bottlenecked creates performance problem: CPU, IO, and Memory. In this session we will focus on High CPU scenarios detection and their resolutions. If time permits we will cover other performance related tips and tricks. At the end of the session attendee will have clear ideas and action items regarding what to do in when facing any of the above resource intensive scenarios.
Indexes – The Unsung Hero
Date: March 19, 2013 – Bangalore
Date: March 26, 2013 – Pune
Time: 2:45 – 3:45 PM
Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
Reference: Pinal Dave (https://blog.sqlauthority.com)