When: Thursday, 12 February 2009, 18:00-20:30

Venue: IT Intellect, Shop 405b Level 3, Musgrave Centre, 115 Musgrave Road, Musgrave

Presenter: Gail Shaw, SQL MVP

Topic: The dirty dozen... 12 Ways to write badly performing T-SQL

RSVP: Please RSVP here.

SA Developer.Net KZN is proud to present Gail Shaw, SQL MVP who has kindly offered her time to present her talk from the PASS Summit last year.

Database performance is a hot topic and there are often questions asked pertaining to the best way to write T-SQL queries. In this presentation, the attendee will NOT be shown the best manner in which to write queries but rather numerous ways of how to write poorly performing queries, with the hope that the attendee will obtain an understanding of what NOT to do. The user will be guided through each query, be shown why it's not the optimal way of doing things and then shown a well-written query that achieves the same results.

Gail's Bio:
Gail is a database consultant from Johannesburg, specialising in performance tuning and database optimisation. Before moving to consulting she worked at a large South African investment bank and was responsible for the performance of the major systems there.
Gail was awarded MVP for SQL Server in July 2008 and spoke at both TechEd South Africa and the PASS Community Summit in Seattle last year.