Toggle navigation
Home
SQLBits 2023
Sponsors
Sponsors
Sponsorship
FAQ
Videos on Demand
It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript,
click here for a page that doesn't require javascript
.
Klaus Aschenbrenner
Home
Sessions & Content
Klaus Aschenbrenner provides with his company SQLpassion SQL Server consulting & training services across Europe. Klaus works with SQL Server for more than 20 years. Klaus has also written the book Pro SQL Server 2008.
Sessions
Message in a bottle: Service Broker from 1 to 100 in 75 minutes!
Service Broker provides several new key features for building SOA applications directly with SQL Server 2005.
Scaleout scenarios with Service Broker
SQL Server 2008 provides a lot of scaleout technologies.
Service Broker: Message in a bottle
Service Broker: Message in a bottle
SQL Server 2008 Database Internals
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: Message in a bottle
Service Broker provides several new key features for building SOA applications directly with SQL Server 2008.
Understanding SQL Server Execution Plans
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.
Advanced SQL Server 2008 Troubleshooting
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?
Troubleshooting TempDb
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.
Troubleshooting the most difficult SQL Server problems
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!
Latches, Spinlocks, and Lock Free Data Structures
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
The dangerous beauty of Bookmark Lookups
Join me in this session to get a basic understanding of Bookmark Lookups, and why they can be dangerous in SQL Server.
SQL Server 2014 In-Memory OLTP Deep Dive
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.
Headache guaranteed: Deadlocking in SQL Server!
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!
Joins in SQL Server - as easy as ABC?
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!