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: http://www.peoplewareindia.com/gallery.htm

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 www.PeoplewareIndia.com