How to develop a SQL Server Workload Mindset?

2022

TL; DR

Learn an easy-to-follow mindset to help you find easier and faster root causes of performance problems, even in a meeting, phone call, or job interview without access to the specific system.

Session Details

Being responsible for the administration of SQL servers can be very confusing, especially for career changers or even beginners. Database servers seem to follow their laws and often behave counterintuitively. The vast amount of information available via DMVs etc. can easily overwhelm one and quickly lead one to guess causes. This session sums up decades of experience with database systems to a few key points explaining the critical moving parts behind the curtain. The goal of this session is to present an easy-to-follow mindset that will make it easier and faster to find the root causes of performance problems in your database in future situations. Even without direct access to complex monitoring systems or magic DMVs, you will be able to recognize common patterns directly in a phone call, meeting, or job interview.

3 things you'll get out of this session

Sascha Lorenz's previous sessions

First Dates: AI & DBAs. Any Chance to be a perfect match?

In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.

The Developer Side of SQL Server Monitoring and Diagnostics

The Microsoft SQL Server comes with many features to take a look behind the scenes of the powerful engines. This session will explain how to use the power of these tools to write your own monitoring and diagnostics environment in Powershell and C#.

The Developer Side of Master Data Services

The Master Data Services offers an easy to use toolset to work with Master Data. In this session we will explore the hidden power of MDS to integrate this service in our solutions. Take your MDS Project on a higher level.

28 Weeks later - How to scale-out your MS Business Intelligence environment

The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.

The Developer Side of the Microsoft Business Intelligence stack

The Microsoft SQL Server provides a complete library of programmatically accessed objects for all Business Intelligence relevant services. With this set of functions almost any customer challenge can be solved without the need to purchase additional products. This possibility is often underestimated in projects. The session will explain the hidden power of using the Microsoft APIs to build BI middleware solutions for enterprise customers.