Please join PassWIT at these upcoming webinars hosted by our fellow Virtual Chapters
Tue, Aug 04 2015 11:00 Central Daylight Time
DBA Fundamentals - Gail Shaw
You have badly performing queries. Doesn’t everyone? You’ve done the investigation, you’ve identified a handful of slow queries that need tuning, you’ve got the execution plan and… Now what?
In this demo-heavy session, we’ll look at what the execution plan can tell you about your query performance. We’ll look at several common operators in query plans and their properties and what they mean. We’ll point out a number of red-flags that can be found within the execution plan and we’ll show how to use the information from the plan to tune the query. All queries shown in this session will be based on ones seen in real-world production systems in the last few years.
Gail Shaw is a database specialist from Johannesburg, South Africa, specializing in performance tuning and database optimization.
Gail works for Entelect, a medium-sized custom software development house based in Johannesburg.
Gail is a frequent poster on the SQLServerCentral.com forums and writes for Simple-Talk. She is an MVP for SQL Server and holds the Microsoft Certified Master certification for SQL Server.
Is your SQL Saturday organizing a PASS WIT panel session? If so, let us know! Has your SQL Saturday team recently hosted a PASS WIT Panel session? Share your pictures, thoughts and experience with us! Email us at WITinfo@sqlpass.org
Many upcoming SQLSaturday events will feature Women in Technology panels or discussions. Check out our calendar for details.
Do you have something to say about the situation of women working in technology? Do you know of an interesting technical woman to interview? We want to hear from you! Contact WITinfo@sqlpass.org with your articles and ideas.