SQLBits 2022

Automagic Tuning in SQL Server

Understand the automatic performance changes in Azure SQL and SQL Server

Identifying and fixing problematic query plans got a lot easier in SQL Server 2016, with the introduction of the Query Store. SQL Server 2017 takes that power a few steps further. Have you ever:

• Had a query suddenly slow down at 2 AM when you were on call?
• Seen a query that received a giant memory grant that brought the rest of the work on your server to a screeching halt?
• Had the optimizer choose the wrong type of join and send your query off to never finish?

Don’t worry, you will still have your job, but the features introduced in SQL Server 2017 will make narrow your focus to the absolute worst queries in your environment. You will also get a sneak preview of what’s coming into future releases of SQL Server in terms of performance.

feedback link: https://sqlb.it/?7050

Joey D'Antoni's previous sessions

You Can't Govern Data You Don't Understand

Data governance is an important driver to any IT organization, but it is not an IT responsibility. Learn about how to help your company build a data governance function, and how to make it business priority.

How Do I Reduce My Cloud Bill?

Learn some of the root causes of high cloud bills and what you can do to solve them.

Stop Doing Stupid $%^--How Not to Secure Your Environment

Lean about some of the worst security practices observed in the wild and have a good laugh.

Choosing the Right Data Store--An Overview of Azure Data Platform Choices

There are a lot of options in Azure for your data. In this session you will learn about the various options for how to store data fro your app, and a decision tree for how to make the best choices for your application.

Automagic Tuning in SQL Server

Understand the automatic performance changes in Azure SQL and SQL Server

Dealing with Bad Networks - The Availability Conundrum

Are you trying to increase uptime locally or for disaster recovery but your network is terrible? Join the club. This session will discuss different techniques, their pros and cons, as well as considerations for availability when your network is flaky at best.

Deep Inside Azure SQL High Availability

Want to have a deep dive into how SQL Server and Azure SQL service maintain high availablity? This is your session.

Understanding Azure Active Directory for Data Professionals

Authentication and security in Azure use a different model. In this session you will learn how that works, and how to make it work for you applications.

When Anti-Patterns Become Best Practices

SQL Server has long had a series of development anti-practices like using scalar functions and table valued functions that are vastly improved in modern versions of the database engine. Learn what's fixed.

Getting Started with Learning Azure

Join three Microsoft Data Platform MVPs to discuss the best approach with building your Azure skills. You will learn the best approaches to gaining the skills you need to function in a cloud world.

Azure Managed Instances—Your Bridge to the Cloud

Managed Instances can make your cloud migrations simpler, but have their own nuances. Learn about what you need to know to manage this new platform.

Building a Data Delivery Solution in the Cloud

Case study on using all of the Azure Data Platform and how to build out your optimal architecture.

Graphs Are Everywhere - Graph DB Support in SQL vNext

Learn about graph databases and how they are implemented in SQL Server vNext

Who Am I? Managing Identities in Azure

Learn about identity management in Azure. You will learn about how to manage identity across your cloud environments.