The same Seminar was offered in Pune on December 4,-5, 2010. We had another successful seminar with lots of performance talk. This seminar was attended by 30 attendees.

The best part of the seminar was that along with the our agenda, we have talked about following very interesting concepts.

Deadlocks Detection and Removal

Dynamic SQL and Inline Code SQL Optimizations

Multiple OR conditions and performance tuning

Dynamic Search Condition Building and Improvement

Memory Cache and Improvement

Bottleneck Detections – Memory, CPU and IO

Beginning Performance Tuning on Production

Parametrization

Improving already Super Fast Queries

Convenience vs. Performance

Proper way to create Indexes

Hints and Disadvantages

I had great time doing the seminar and sharing my performance tricks with all. The highlight of this seminar was I have explained the attendees, how I begin doing performance tuning when I go for Performance Tuning Consultations.

Pinal Dave at SQL Performance Tuning Seminar

SQL Server Performance Tuning Seminar

Pinal Dave at SQL Performance Tuning Seminar

Pinal Dave at SQL Performance Tuning Seminar

SQL Server Performance Tuning Seminar

SQL Server Performance Tuning Seminar

This seminar series are 100% demo oriented and no usual PowerPoint talk. They are created from my experiences of various organizations for performance tuning.

I am not planning any more seminar this year as it was great but I am booked currently for next 60 days at various performance tuning engagements.

Pinal Dave is a technology enthusiast and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and have written over 3800 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 14+ years of hands on experience he holds a Masters of Science degree and a number of database certifications. For any SQL Server Performance Tuning Issue send email at pinal @ sqlauthority.com .

Nupur Dave is a social media enthusiast and and an independent consultant.