4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Gail_Shaw.png

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 a session for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

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

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.

Blog posts RSS

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

SQL University: Advanced indexing – Sorting and Grouping 07 Nov 2011
Good day everyone and welcome to another week of SQL University. I know we’re getting close to the end of the year and everyone’s looking forward to a nice long vacation soaking up the sun at the beach, but a little bit of attention would be nice. Thank you. This week is Advanced Indexing, and ...

24 Hours of PASS Questions 27 Sep 2011
I finally found the time to work through the questions from the 24 Hours of PASS session that I did. Thanks to everyone that attended the event Q1: Can you filter execution plans for sort warnings? No. The sort and hash warnings don’t appear in the execution plan. You’d have to trace for the hash ...