4th - 7th May 2016



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 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
http://sqlinthewild.co.za http://feeds2.feedburner.com/SqlInTheWild
Gail Shaw has submitted 4 sessions for SQLBits XV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Erratically performing queries can be problematic both to identify and to fix. In this session we'll look at query patterns that cause erratic performance, how to identify such queries and options for fixing them
This introductory session will look at backups, more backups and even more backups. We'll cover full backups, differential backups and why log backups are so essential to a good recovery plan.
One of the hardest things to do in SQL is to identify the cause of a sudden degradation in performance. We'll take a look at the new feature in SQL Server 2016, the QueryStore, which makes solving problems like this trivial.
Distributed replay is one of those features that it seems almost no one’s heard about, and yet it’s incredibly useful. We'll look at how Distributed Replay can be used to do a before and after database performance comparison.

Previous Sessions

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

and other pointless query rewrites 09 Feb 2016
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to a Column > 2 or Column < 2 combination, it can use indexes better.” Sounds like something that clearly... (Read more)

On the addition of useless where clauses 02 Feb 2016
I remember a forum thread from a while back. The question was on how to get rid of the index scan that was in the query plan. Now that’s a poor question in the first place, as the scan might... (Read more)

Does an index scan always read the entire index? 26 Jan 2016
No. That’s a bit short for a blog post, so let me explain. First, the difference between a seek and a scan. A seek is an operation which navigates down the index’s b-tree looking for a row or for the... (Read more)

Stop using Task Manager to check SQL’s memory usage! 19 Jan 2016
There’s two fairly common questions I see on the forums around SQL Server’s memory usage. Either the question asks why SQL’s using too much memory, or why it’s using too little. Too much memory isn’t usually a real problem, it’s... (Read more)

Natively compiled user-defined functions 12 Jan 2016
One new thing that SQL Server 2016 has added is the ability to natively compile user-defined functions. Previously, native compilation, part of the hekaton feature, was limited to stored procedures. When I saw that, the first question that came to... (Read more)