Completed-Advanced SQL Server 2008 & Performance Tuning workshop in Pune 2011

Hi Friends,

I like writing about my trainings – there is so much to learn in every training assignment. I get to meet new minds, new personalities, get to know their SQL stories, their issues, remedies, tips, tricks, techniques and bunch of little things!

This SQL Server training assignment in India was organized by Peopleware India

I blogged about my last training here that I completed in Bangalore:

Immediately after completing my assignment in Bangalore, I flew to Pune to deliver my next assignment with one of the world’s largest bank. They use SQL Server extensively.

This was a 5 day program on SQL Server 2008 R2 Performance Tuning & Optimization. Performance Tuning is such a vast topic and questions poured from all corners asking about indexing best practices, query tuning, Joins vs Sub-queries, troubleshooting I/O, CPU, TempDB, Memory, etc.

We spent good amount of time in tracing queries using Profiler and identifying rouge workloads. From running sp_trace, capturing data in a .trc file, importing it into a table, filtering, identifying the queries and then extracting the execution plan from the cache, tuning the workload by re-writing queries, re-designing indexing strategies – we did it all and it was fun 🙂

The audience was very patient, cooperative and active – they matched my speed of doing the labs and it was a real pleasure knowing & interacting with them. Thanks to all the folks. In fact, people inside the classroom make the training successful and all kudos to them! And I made a few friends 🙂


Here are is the pic from the class:


The gallery page on Peopleware India site is updated as well:

Next, I traveled to Hyderabad for a Microsoft class. I shall write about the next batch shortly.

If you are looking for SQL Server training / consulting for your company / people, you can write to enquiry<at>peoplewareindia<dot>com or visit




About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: He is on Twitter:

View all posts by Amit Bansal →

One Comment on “Completed-Advanced SQL Server 2008 & Performance Tuning workshop in Pune 2011”

  1. Amit, Yes it was really a nice experience. I learnt many things from this training.

    Thanks for the knowledge sharing…Many technical things got clear…Hope I get another chance to attend your trainings..

    All the best….!!! 🙂

Leave a Reply

Your email address will not be published.