Gail Shaw

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 Johannedburg. Gail is a frequent poster on the forums and writes for Simple-Talk. She is an MVP for SQL Server and holds the Microsoft Certified Master certification for SQL Server

In this session we'll look at the things you should and shouldn't be doing now, to protect yourself and your data against the risk of corruption and thing you should and shouldn't do should the database ever become corrupt.
In this session we'll look at the common causes of bad execution plans and examine options for resolving the problem, short term and long term.
Indexes are essential to good database performance, but it can be hard to decide what indexes to create. In this session we'll look at guidelines for index creation
Transactions are critical when multiple changes need to be made entirely or not at all, but it’s rare to see transactions used at all in most production code. In this introductory session, we'll look at what transactions are and how they're used

Blog posts RSS

Q&A from the DBA Fundamentals Virtual Chapter 25 Aug 2015
A couple of weeks ago I did a presentation to the DBA Fundamentals virtual chapter. The presentation title was “What execution plans can tell you about query performance” The slides and recording are available at the Virtual Chapter’s home page I didn’t manage to get all of the questions ...

How not to do a Masters degree 11 Aug 2015
There are many, many guides to successfully completing a post grad degree, so I am not going to add to them. Instead, this is a list of things, based on personal experience, that you can do to make it somewhere between very difficult and impossible to complete that Masters or Doctorate degree. To ...

2011 Book review 01 Jan 2012
Another year over and much as I did last year, I’m going to briefly go over the books I read this last year. I will freely admit, very few of these could be considered ‘classic literature’, most is a mix of sci-fi, fantasy or adventure fiction. That’s just what I like to ...

SQL University: Advanced Indexing – Indexing Strategies 11 Nov 2011
Right, I know it’s Friday and everyone’s tired and looking forward to the weekend, but I do need to finish off this indexing section and I’ll try to keep this short and interesting and hopefully keep everyone awake. There’s no shortage of information available on how to ...

SQL University: Advanced Indexing – Filtered Indexes 09 Nov 2011
Welcome back to day 2 of Advanced Indexing. Today we’re going to look at a feature that was added in SQL Server 2008 – filtered indexes. In versions previous, indexes were always on the entire table. An index would always have the same number of rows as the table it was built on did ...