Gail Shaw
Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully.
She is a Pluralsight author and has spoken at SQL Saturdays locally and internationally, SQL Bits and at the PASS Community Summit. She can often be found on the SQL Server community Slack.
Gail Shaw's Sessions
Introducing Synapse Analytics Data Explorer poolsSQLBits 2022
A look at the features and uses of Synapse Analytics Data Explorer Pools
Regressions, neurons and decisions. Oh My!SQLBits 2018
Linear regression, neural networks and neural networks are three of the foundational algorithms in machine learning. In this session, we'll look at how they work and how they generate the results that they do.
All about IndexesSQLBits 2017
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 the design considerations for clustered indexes and for nonclustered indexes.
All about IndexesSQLBits 2015
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
On Transactions and Atomic OperationsSQLBits 2015
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
Do's and don'ts of database corruptionSQLBits 2014
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.
Bad Plan! Sit!SQLBits 2014
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.
Regressions, neurons and decisions. Oh My!SQLBits 2018
Linear regression, neural networks and neural networks are three of the foundational algorithms in machine learning. In this session, we'll look at how they work and how they generate the results that they do.
All about IndexesSQLBits 2017
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 the design considerations for clustered indexes and for nonclustered indexes.
All about IndexesSQLBits 2015
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
Do's and don'ts of database corruptionSQLBits 2014
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.
Bad Plan! Sit!SQLBits 2014
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.