Grant Fritchey, SQL Server MVP, works for Redgate Software as Product Evangelist. In his time as a DBA and developer, he has worked at three failed dot–coms, a major consulting company, a global bank and an international insurance & engineering company. Grant currently serves on the Board of Directors for the PASS organization of data professionals. He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server Query Performance Tuning (Apress). Grant earned the nickname “The Scary DBA.” He even has an official name plate, and displays it proudly.
Grant Fritchey has submitted 3 sessions for SQLBits 2019, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Learn how to understand and read execution plans.
Learn to monitor your servers as part of a compliant DevOps process.
Drivers and methods behind adoption of DevOps for the DBA.

Sessions

Previous Sessions

Just because you're using an Azure SQL database does not mean you can avoid tuning queries. This session will introduce you to the tools you have available to identify poor performing queries, understand, and fix them. All in the cloud.
Learn where to start reading execution plans and how to interpret them in order to understand how to tune poorly performing queries.
Once you've decided to move to Azure with any of your databases, you're going to need to know how they're performing, this session shows you.
Learn how to use execution plans to understand how SQL Server works, not just tune your queries.
Learn how to write T-SQL more clearly so that it performs better.
Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practise your deployments using continuous integration before you ever get near production
SQL Server 2016 introduces the Query Store. The Query Store will change how you tune queries. Come to this session to learn everything you'll need.
Row counts are the primary factor for choices made by the query optimizer. This session explores how row counts affects query performance.
The Query Store will change how you tune queries and gather metrics about them in both SQL Server 2016 and Azure SQL Database.
Find out how the new SQL Clone enables self-service easy automation of database copies, near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline.
Learn about data management and DevOps for the modern business.
Learn the details behind how to read execution plans.
With GDPR fast approaching, learn now how to get your data into compliance in order to protect your client's sensitive information.
Grant_Fritchey.jpg