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

Index selectivity and index scans 06 Oct 2015
There was a question raised some time back ‘If an index is not selective, will the query operators that use it always be index scans’? It’s an interesting question and requires a look at what’s going on behind the scenes in order to answer properly.. Short answer: No, not always. Long answer… ...

Repairing a replication subscriber 22 Sep 2015
It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes corrupt, is running CheckDB with repair allow data loss safe? The theory is, since the subscriber is a copy of another database, allowing CheckDB to discard data in the process of ...

Unusual errors with Distributed Replay 08 Sep 2015
I’ve come to really like Distributed Replay in the last couple of years. I’ve used it to do a scale test, I’ve used it to test a workload for performance regressions before upgrading. It has a lot of possibilities. One problem with it is there’s no GUI, so configuring it requires a fair bit of ...

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 ...