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.
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 tool SQL Clone enables self-service or easy automation of database copies and is near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline.