4th - 7th May 2016

Liverpool

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

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

Upcoming conferences 26 Apr 2016
It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing SQLBits, I’ll still be getting a chance to enjoy an English summer. InsideSQL The InsideSQL conference is a new conference... (Read more)

SQL 2016 features: Stretch Database 19 Apr 2016
Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows for parts (or all) of a table, presumably older, less used parts, to be stored in Azure instead of on... (Read more)

SQL Server 2016 features: Live query statistics 12 Apr 2016
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query to finish? Now you can. Enable that and run a query, and you get an execution plan immediately, one with... (Read more)

SQL Server 2016 features: Query Store 29 Mar 2016
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some thoughts on new features. The first one I want to look at is a feature that I’m so looking forward... (Read more)

Blocking operators and actual row counts 15 Mar 2016
Query plans can sometimes be hard to read, and other times can be downright mystifying. Take this plan for example. Not too hard in general. Two index seek/scan, a join, a sort and a filter. The peculiarity here is in... (Read more)