Hi Friends,

Today, while I write this blog, I am preparing for my travel to Bangalore next week for a very tough assignment with one of my clients in engineering & IT space.

Here is something about my AdvancedT-SQL workshop that I delivered for a leading insurance company in USA. As usual, there is so much that I learnt in this assignment. I met new minds, new personalities, got to know their SQL stories, their issues, remedies, tips, tricks, techniques and bunch of little things! Every assignment makes me a better SQL guy and a better person too :)

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

Previous to this T-SQL assignment, I had delivered 2 batches for MS IDC in the same week. I blogged about that here:

http://www.sqlservergeeks.com/sql-server-completed-bi-workshop-in-hyderabad-september-2011/

http://www.sqlservergeeks.com/sql-server-completed-t-sql-workshop-in-hyderabad-september-2011/

This was a 3 day workshop on Advanced T-SQLand I covered everything starting from query processing architecture, Join algorithms,

Sub-queries, Ranking functions, aggregates, indexes, data modification internals, etc. Yes, indexes is always a favorite topic of mine. I love talking about the order of columns in your indexes, the INCLUDE option and how can it better over composite indexes, filtered indexes, etc. We also spent considerable amount of time on query tuning; tips and tricks etc. I included a few learnings that I got from Itzik’s session at TechED North America.

The audiencewas so focused, and I was bombarded with questions – and I think I answered them all 😉

I loved interacting with the folks; they made an excellent class.

Here is the Pic from the class:

1_Completed_Advance_TSQL_workshop_Gurgaon_September2011

The gallery page on Peopleware India site is updated as well: http://www.peoplewareindia.com/gallery.htm

Next batch was again, performance tuning for a large financial investment company.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