Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Klaus Aschenbrenner

Klaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and the US. Klaus works with the .NET Framework and especially with the SQL Server 2005/2008 from the very beginnings. In the years 2004 - 2005 Klaus was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008. Further information about Klaus you can find on his homepage at http://www.SQLpassion.at. He also twitters at http://twitter.com/Aschenbrenner.

Why do we need UPDATE Locks in SQL Server?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I want to talk about a specific question that I almost get every time when I… Read more

6 comments, 8,936 reads

Posted in Klaus Aschenbrenner on 28 July 2014

SQLBits recap

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Wow, what an intensive last week! Last week I attended the SQLBits conference in Telford/UK – in… Read more

0 comments, 153 reads

Posted in Klaus Aschenbrenner on 22 July 2014

My upcoming speaking schedule

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Over the next weeks and months I have an incredible speaking schedule around the whole world. You… Read more

0 comments, 140 reads

Posted in Klaus Aschenbrenner on 14 July 2014

SQL Server Quickie #15 – Merge Join Operator

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 14th SQL Server Quickie to YouTube. This time I’m talking about the… Read more

0 comments, 193 reads

Posted in Klaus Aschenbrenner on 7 July 2014

Introduction to Spinlocks in SQL Server

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In last weeks blog posting I have talked about Latches in SQL Server. At the end I… Read more

0 comments, 418 reads

Posted in Klaus Aschenbrenner on 30 June 2014

Introduction to Latches in SQL Server

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In today’s blog posting I want to talk about a more advanced, low-level synchronization object used by… Read more

0 comments, 430 reads

Posted in Klaus Aschenbrenner on 23 June 2014

SQL Server Performance Tuning & Troubleshooting Workshop in Antwerpen/Belgium

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

I’m very happy to announce today that I also run my famous SQL Server Performance Tuning &… Read more

0 comments, 243 reads

Posted in Klaus Aschenbrenner on 19 June 2014

Configuring the In-Memory OLTP File Group for High Performance

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In todays’ blog posting I want to talk about the memory optimized file group used by In-Memory… Read more

4 comments, 831 reads

Posted in Klaus Aschenbrenner on 16 June 2014

Announcing the SQL Server Query Tuning Workshop

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I’m very happy and proud to announce my brand new SQL Server Query Tuning Workshop that… Read more

0 comments, 527 reads

Posted in Klaus Aschenbrenner on 9 June 2014

SQL Server Quickie #14 – The Tipping Point

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 14th SQL Server Quickie to YouTube. This time I’m talking about the… Read more

0 comments, 245 reads

Posted in Klaus Aschenbrenner on 2 June 2014

Speaking at SQLSaturday #310 in Dublin/Ireland

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

I’m very proud to announce that I will speak at the SQLSaturday #310 in Dublin. On September… Read more

0 comments, 188 reads

Posted in Klaus Aschenbrenner on 26 May 2014

Statistics with Ascending Key Column Values

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In today’s blog posting I want to talk about a very common problem within SQL Server: handling… Read more

0 comments, 238 reads

Posted in Klaus Aschenbrenner on 19 May 2014

Debugging a SQL Server query with WinDbg

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In my last blog posting I gave you a general introduction to WinDbg, and told you how… Read more

5 comments, 484 reads

Posted in Klaus Aschenbrenner on 13 May 2014

SQL Server Debugging with WinDbg – an Introduction

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In today’s blog posting I want to dig into a completely different area in SQL Server: how… Read more

7 comments, 1,782 reads

Posted in Klaus Aschenbrenner on 5 May 2014

SQL Server Quickie #13 – Hash Join Operator

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 13th SQL Server Quickie to YouTube. This time I’m talking about the… Read more

0 comments, 319 reads

Posted in Klaus Aschenbrenner on 29 April 2014

A ever-increasing Clustered Key value doesn’t scale!

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

You know all the best practices how to choose a Clustered Key value? A good Clustered Key… Read more

10 comments, 266 reads

Posted in Klaus Aschenbrenner on 15 April 2014

Improving Query Performance by using correct Search Arguments

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In today’s blog posting I want to talk about a very specific performance problem related to indexing… Read more

0 comments, 3,493 reads

Posted in Klaus Aschenbrenner on 8 April 2014

Goodbye SQL Server, Hello FileMaker…

The last weeks were very time consuming for me, because I had to make a very tough decision: staying independent and providing high quality SQL Server consulting and training services, or getting employed (again), and being part of a greater team to influence how the IT industry will be in… Read more

0 comments, 319 reads

Posted in Klaus Aschenbrenner on 1 April 2014

SQL Server Quickie #12 – Nested Loop Operator

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 12th SQL Server Quickie to YouTube. This time I’m talking about the… Read more

0 comments, 277 reads

Posted in Klaus Aschenbrenner on 31 March 2014

The Illusion of Updateable Clustered ColumnStore Indexes

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In todays blog posting I want to concentrate in more details on the Updateable Clustered ColumnStore Index… Read more

5 comments, 1,155 reads

Posted in Klaus Aschenbrenner on 25 March 2014

Older posts