Tales from the Field - How to Avoid Burnout

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,

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.

Mastering TempDB

Have you experienced performance problems caused by contention in TempDB? Have you ever wondered why your TempDB is suddenly 3 TB? In this session, you will learn about all the various components of SQL Server that use TempDB. Whether it be AlwaysOn Availability Groups, Read Committed Snapshot version stores, spills, or simply temporary tables, learn about how to identify what SQL Server or your applications are doing in TempDB. Once you understand all the ways SQL Server uses this critical resource, and how to proper configure it, you'll be better prepared for your workloads whether it be an Azure VM, a physical server, or a container.

Your Performance Tuning Check List

Everyone needs a list of what to double check in your environment to ensure your servers and databases are optimized in order to make SQL Server run faster, better and more efficiently. In this session you will learn about what you need to review and implement to get a performance and configuration improvements. You will learn about best practice configuration, SQL Server surface area, memory optimizations, isolation levels, Tempdb and transaction log configuration.

Performance Tuning Azure SQL Database

Have you moved to a cloud database like Azure SQL Database and are having performance issues? While the Azure SQL services running in Azure are similar to SQL Server, they are key differences in performance tuning methodologies. In this session, you will learn about monitoring options, changes in cloud DMVs, and additional cloud tuning tools like Azure SQL Analytics and Performance Insights that can allow you quickly get to performance data across a number of instances. You will learn about what you need to keep in mind when choosing between scaling-out to readable secondaries and scaling-up to higher tier solutions. Discuss with Microsoft MVP Monica Rathbun the challenges and benefits of tuning, what to keep in mind, and what to expect in the cloud.

Your Performance Tuning Check List

Everyone needs a list of what to double check in your environment to ensure your servers and databases are optimized in order to make SQL Server run faster, better and more efficiently. In this session you will learn about what you need to review and implement to get a performance and configuration improvements.

Erin & Monica’s Favorite SQL Stuff

Two consultants, two different companies, two data professionals passionate about performance tuning. Do we like the same things? Do we have the same approach to problems? Topics will include: Trace Flags, DMVs, DBCC commands, Community Scripts and Intelligent Query Processing Features. We will talk about the features and solutions we agree on, and discuss where we disagree.

Always Encrypted for Beginners

Let's learn about what Always Encrypted is, how it works, and the implications for your environment. By the end you will know how to now easily encrypt columns of data and just as importantly how to unencrypt.

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.