-->
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 Trainings for Fall 2018

(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 quite happy to announce my SQLpassion Online Trainings for the remaining year. Currently I have… Read more

0 comments, 118 reads

Posted in Klaus Aschenbrenner on 14 August 2018

What is an Event-Less Extended Event Session?

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

Do you have ever heard about an “Event-Less” Extended Event Session? What is the idea about it?… Read more

0 comments, 1,454 reads

Posted in Klaus Aschenbrenner on 11 June 2018

Does a Query always wait in the SUSPENDED State?

(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 interesting topic: in which execution state… Read more

0 comments, 634 reads

Posted in Klaus Aschenbrenner on 5 June 2018

Actual Number of Rows are not always accurate

(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’s blog posting is a quite interesting one, because I want to show you a concrete example… Read more

2 comments, 1,884 reads

Posted in Klaus Aschenbrenner on 28 May 2018

SQLpassion Online Trainings in June 2018

(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 announce my SQLpassion Online Training for June 2018.

On June 21, 2018 I’m… Read more

0 comments, 173 reads

Posted in Klaus Aschenbrenner on 21 May 2018

What is VMware vSAN?

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

If you follow me on Twitter, or if you have read my last blog posting about… Read more

3 comments, 440 reads

Posted in Klaus Aschenbrenner on 22 January 2018

How I designed my VMware vSAN based Home Lab

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

As you might know, I have already a quite powerful mobile Home Data Center that I have… Read more

4 comments, 1,844 reads

Posted in Klaus Aschenbrenner on 15 January 2018

SQLpassion Online Training in January 2018

(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 announce my SQLpassion Online Training for January 2018. On January 25 I’m running… Read more

0 comments, 226 reads

Posted in Klaus Aschenbrenner on 9 January 2018

Design, Deploy, and Optimize SQL Server on VMware

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

The year 2017 is almost over, and therefore I want to announce today some important announcements about… Read more

0 comments, 453 reads

Posted in Klaus Aschenbrenner on 5 December 2017

SQLpassion Black Friday Deal

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

As we all know the Black Friday approaches quite fast, and therefore I also want to offer… Read more

0 comments, 402 reads

Posted in Klaus Aschenbrenner on 21 November 2017

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, 1,133 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,636 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, 1,401 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, 366 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, 225 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, 209 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

2 comments, 303 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, 162 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

3 comments, 357 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, 180 reads

Posted in Klaus Aschenbrenner on 10 July 2017

Older posts