-->
SQL Clone
SQLServerCentral is supported by Redgate
 
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.

SQLpassion Online Training about Availability Groups

(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.)

Because of the huge success and additional requests I’m offering my webinar about SQL Server Availability Groups Read more

0 comments, 870 reads

Posted in Klaus Aschenbrenner on 9 October 2017

Setting a Processor Affinity in SQL Server – the (unwanted) Side-Effects

(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 very important topic in SQL Server – setting a Processor… Read more

6 comments, 1,262 reads

Posted in Klaus Aschenbrenner on 2 October 2017

Adding a Replica back into a SQL Server Availability Group

(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 one of my last blog postings I have already described a common pitfall when you try… Read more

0 comments, 995 reads

Posted in Klaus Aschenbrenner on 25 September 2017

SQLpassion Online Training in October 2017

(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’ve announced my SQLpassion Online Training for October 2017.

  • On October 5 I’m running a one-day…

Read more

0 comments, 207 reads

Posted in Klaus Aschenbrenner on 21 September 2017

Adding Replicas into existing Availability Groups

(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.)

Last week I have blogged about how you can run the Availability Group traffic through a different… Read more

0 comments, 56 reads

Posted in Klaus Aschenbrenner on 18 September 2017

How to run the Availability Group Traffic on a different NIC

(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.)

When you deploy a new SQL Server Availability Group, the synchronization traffic between all replicas is routed… Read more

0 comments, 51 reads

Posted in Klaus Aschenbrenner on 11 September 2017

Automatic Seeding & Compression

(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.)

Last week I have talked about the basic concepts behind Automatic Seeding in SQL Server 2016 Availability… Read more

0 comments, 61 reads

Posted in Klaus Aschenbrenner on 31 August 2017

SQLpassion Online Trainings in September 2017

(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’ve announced my SQLpassion Online Trainings for September 2017.

  • On September 12 I’m doing a free…

Read more

0 comments, 32 reads

Posted in Klaus Aschenbrenner on 22 August 2017

Automatic Seeding in Always On Availability Groups in SQL Server 2016

(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 last few weeks I have done a lot of work in the area of Always… Read more

2 comments, 53 reads

Posted in Klaus Aschenbrenner on 21 August 2017

Self-Paced Online Trainings

(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 don’t have the time to set a whole day or even a whole week in a… Read more

0 comments, 33 reads

Posted in Klaus Aschenbrenner on 10 July 2017

SQLpassion Workshops for Fall 2017

(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.)

Time goes by, and today I’m very proud to announce all upcoming SQLpassion workshops for the second… Read more

0 comments, 38 reads

Posted in Klaus Aschenbrenner on 26 June 2017

SQLpassion Online Trainings in July 2017

(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’ve announced my SQLpassion Online Trainings for July 2017.

  • On July 4 I’m doing again a…

Read more

0 comments, 37 reads

Posted in Klaus Aschenbrenner on 20 June 2017

Tracking Lookup Operations 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.)

Last week during my SQL Server Performance Tuning Workshop I got quite an interesting question regarding Bookmark… Read more

0 comments, 39 reads

Posted in Klaus Aschenbrenner on 22 May 2017

Introduction to Wait Statistics in SQL Server

In today’s blog posting I want to talk more about the Wait Statistics in SQL Server and how they can help you understand why your SQL Server is currently slow. For me the Wait Statistics are the most important concept in SQL Server when it comes to performance troubleshooting.

Why…

Read more

0 comments, 683 reads

Posted in Klaus Aschenbrenner on 13 April 2015

Learn about SQL Server 2014 Performance Improvements

On May 11th I will deliver a precon about SQL Server 2014 Performance Improvements at the SQLDay Poland conference in Wroclaw/Poland. I have already done intensive work on SQL Server 2014 and helped various customers around Europe to move their workload to SQL Server 2014. In this precon I will… Read more

0 comments, 781 reads

Posted in Klaus Aschenbrenner on 9 April 2015

SQL Server Quickie #23 – Plan Cache Pollution

Today I have uploaded the 23th SQL Server Quickie to YouTube. This time I’m talking about Plan Cache Pollution in SQL Server.

[viral-lock message=”Like or share to get the source code.” tweet=”SQL Server Quickie #23 – Plan Cache Pollution by @Aschenbrenner:” url=”http://www.SQLpassion.at/archive/2015/04/07/sql-server-quickie-23-plan-cache-pollution”]You can find the script used during the demonstration… Read more

0 comments, 713 reads

Posted in Klaus Aschenbrenner on 7 April 2015

Latches, Spinlocks & Lock-Free Data Structures Recording

A few weeks ago I have spoken at the SQLRally Nordic conference in Copenhagen about Latches, Spinlocks, and Lock-Free Data Structures in SQL Server. Fortunately my 2.5 hour long non-stop session was recorded, and is now finally available at Youtube for watching.

Enjoy!

-Klaus

Read more

4 comments, 943 reads

Posted in Klaus Aschenbrenner on 30 March 2015

Statistics on UNIQUEIDENTIFIER columns

During the SQLRally conference in Copenhagen/Denmark, Brent Ozar (Blog, Twitter) and I had a very interesting conversation regarding Statistics on UNIQUEIDENTIFER columns. It seems that SQL Server shows some very nasty behavior here. Let’s have a look.

The repro

To show you the behavior we have complained… Read more

6 comments, 738 reads

Posted in Klaus Aschenbrenner on 16 March 2015

Why I don’t (yet) recommend In-Memory OLTP to my customers

Ok, some of you will hate me after this blog posting, but it has to be said. Over the last months I have done a lot of work in the area of In-Memory OLTP, and I also had a lot of customer requests regarding this amazing new technology. Unfortunately none… Read more

10 comments, 633 reads

Posted in Klaus Aschenbrenner on 11 March 2015

Transaction Logging in In-Memory OLTP (Hekaton)

In today’s blog posting I want to talk in more detail about how In-Memory OLTP logs transaction log records into the transaction log. As you might know, In-Memory OLTP offers you 2 durability options for your Memory Optimized Tables:

  • SCHEMA_ONLY
  • SCHEMA_AND_DATA

I don’t want to talk more about SCHEMA_ONLY Read more

0 comments, 802 reads

Posted in Klaus Aschenbrenner on 9 March 2015

Older posts