Klaus Aschenbrenner provides SQL Server Consulting services across Europe and the US. He helps people around the world to understand, use, and run SQL Server installations in their environments. In the years 2004 - 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. Klaus is also the author of the book Pro SQL Server 2008 Service Broker (ISBN 1590599993) published by Apress in August 2008.
Klaus Aschenbrenner has submitted 6 sessions for SQLBits 2019, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

You know locking and blocking very well in SQL Server? You know how the isolation level influences locking? Perfect! Join me in this session to make a deep dive into how SQL Server implements physical locking.
Have you ever looked at an execution plan that performs a join between 2 tables, and wondered what a "Left Anti Semi Join" is? Joining 2 tables in SQL Server isn't the easiest part!
UNIQUEIDENTIFIERs as Primary Keys in SQL Server - a good or bad best practice? They have a lot of pros for DEVs, but DBAs just cry when they see them enforced by default as unique Clustered Indexes.
SQL Server needs its locking mechanism to provide the isolation aspect of transactions. As a side-affect your workload can run into deadlock situations - headache for you as a DBA is guaranteed!
There are so many different concepts that you have to know when you have to configure memory settings for SQL Server correctly. In this session you get an overview about the memory architecture of SQL Server and how SQL Server is using memory.
One of the newest buzzwords of the last few months and years is definitely Kubernetes - or K8S. Microsoft has made with SQL Server 2019 a huge investment into Kubernetes and provides a Docker Container Image that can run on top of Kubernetes.

Sessions

Previous Sessions

Service Broker provides several new key features for building SOA applications directly with SQL Server 2005.
SQL Server 2008 provides a lot of scaleout technologies.
Service Broker: Message in a bottle
Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file.
Service Broker provides several new key features for building SOA applications directly with SQL Server 2008.
Do you know SQL Server Execution Plans? Yes! - and can you read/analyze them? No... For the beginner it is not very easy to understand and explain execution plans generated by SQL Server for your queries.
It's Friday, 05:00pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast?
For the most DBAs and DEVs the TempDb is a crystal ball. But the TempDb is the most critical component in a SQL Server installation and is used by your applications and also internally by SQL Server.
Do you have enough from "normal" performance tuning sessions? You can't hear anything about Indexing and Execution Plans anymore? Then you are right in this session!
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
Join me in this session to get a basic understanding of Bookmark Lookups, and why they can be dangerous in SQL Server.
Hekaton is the Greek word for 100 - the goal of In-Memory OLTP in SQL Server 2014 is to improve query performance up to 100 times. In this session we will look under the cover of Hekaton and the Multi Version Concurrency Control (MVCC) principles.
SQL Server needs its locking mechanism to provide the isolation aspect of transactions. As a side-affect your workload can run into deadlock situations - headache for you as a DBA is guaranteed!
Have you ever looked at an execution plan that performs a join between 2 tables, and wondered what a "Left Anti Semi Join" is? Joining 2 tables in SQL Server isn't the easiest part!
klaus_aschenbrenner.jpg