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

What is a SARGable predicate? 13 Sep 2016
‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek on indexes. The term’s an abbreviation, ‘SARG’ stands for Search ARGument, and it means that the predicate can be executed... (Read more)

I’m a Pluralsight author! 30 Aug 2016
My first course, Identifying & Fixing Performance Issues Caused by Parameter Sniffing, was published two weeks ago. It won’t be the last. Recording the course was a voyage of discovery. Until then, I’d only ever done live presentations, blog posts... (Read more)

Pass Summit 2016 abstract reviews 12 Jul 2016
Following on Steve’s blog post on summit abstracts, I decided to publish mine. My comments are not intended as an attack on the program committee, it’s an incredibly hard job that you couldn’t pay me to do (I’ve done similar... (Read more)

SQL Server 2016 features: R services 24 May 2016
One of the more interesting features in SQL 2016 is the integration of the R language. For those who haven’t seen it before, R is a statistical and data analysis language. It’s been around for ages, and has become popular... (Read more)

SQL Server 2016 features: Temporal Tables 10 May 2016
Another new feature in SQL 2016 is the Temporal Table (or System Versioning, as its referred to in the documentation). It allows a table to be versioned, in terms of data, and for queries to access rows of the table... (Read more)