SQLBits 2023

Banishing Slow Queries with Intelligent Query Processing

An overview of the performance enhancing Intelligent Query Processing features in SQL Server 2019 as well as including some new SQL Server 2022 items,

Slow queries can be the bane of any data professionals existence. Let's face facts, no one likes it when query performance is abysmal. We continuously strive to tweak things attempting to ensure query execution is as fast as possible. What if we could magically make things faster with the push of a button or two? Now we can.

Originally reborn from SQL Server 2017 Adaptive Query Processing (AQP) to Intelligent Query Processing (IQP) with SQL Server 2019, now SQL Server 2022 continues to bring forth even more enhancements making the query optimizer an efficient learning machine. With this newfound knowledge, SQL Server can now generate better optimized queries with minimal effort.

We will -
• See what's new with SQL Server 2022
• Examine how IQP works behind the scenes
• Look at real world demonstrations of IQP in action

Nobody likes slow queries. Nobody. Take advantage of intelligent query processing features and see how much of an improvement can be gained.

John Morehouse's previous sessions

Soaring to New Heights with Accelerated Database Recovery

In this deep technical session, we will uncover the mechanisms of accelerated database recovery that allow for a much smoother flight in the journey of database recovery.

Azure Infrastructure - What Not to Do

This session will high light things I've seen in Azure SQL implementations that have caused issues. Attendees will learn from the mistakes of others to ensure a smooth Azure flight of their own.

Banishing Slow Queries with Intelligent Query Processing

An overview of the performance enhancing Intelligent Query Processing features in SQL Server 2019 as well as including some new SQL Server 2022 items,

Tales from the Field - How to Avoid Burnout

In the fast paced "always plugged in world" we all live in today, getting burned out is something that you will most likely experience. That feeling of emotional and physical exhaustion that leaves you overwhelmed, trapped, defeated and stagnant can be unbearable. Taking the time to learn how to avoid burnout can be game-changer for your mental health, motivation, and productivity. In this 20 minute session, we will discuss ways to help prevent that burn out.

Switching Careers: From PT to IT

The biggest risk in life is not taking one. Would you switch careers in the middle of the pandemic to a field that you have no experience in? That is exactly what Yuki did: he was on the brink of starting his doctorate for physical therapy when he decided to make the last minute change to become a DBA. Yuki and his mentor, John Morehouse, both found themselves in unique positions on opposite ends of their careers with a long road ahead of them. Listen to Yuki's unique journey of becoming a DBA and hear John's advice on how to mentor someone from early days.

10 Productivity tools in 20 minutes

You are busy, we are busy, everyone is busy. These are the tools that two busy consultants use to improve their productivity. We want to tell you about the tools that we use; that maximise our time, simplify our life, reduce our key strokes and generally make us appear more amazing. So that you can use them too. We have 20 minutes, so we wont go into much detail but we have some good quick stories to tell.

There is a time and a place for everything

There is a time and a place for everything. John and Rob, being consultants, often say "Well, it depends" Lets talk about some of the times when the "rules" may not fit

Designing Azure Data Disaster Recovery Strategies

Unfortunately, disasters can affect cloud technologies and if you are't prepared for it, the results can be painful. Let's discuss ways to implement Azure SQL disaster recovery techniques to help protect your data!

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.