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

Running a custom SQL Server Docker Image in Amazon AWS

(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 shown you how I run SQL Server natively… Read more

0 comments, 1,650 reads

Posted in Klaus Aschenbrenner on 26 November 2018

SQLpassion Black Friday Deal 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.)

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

2 comments, 129 reads

Posted in Klaus Aschenbrenner on 22 November 2018

Running SQL Server with Docker on the Mac

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

Years ago when I switched from Windows to Mac, people have told me regularily that I’m crazy.… Read more

0 comments, 1,836 reads

Posted in Klaus Aschenbrenner on 19 November 2018

Filtered Indexes 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 kind of index in SQL Server: Filtered Indexes, which… Read more

2 comments, 2,180 reads

Posted in Klaus Aschenbrenner on 5 November 2018

I have a broken leg

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

Todays blog posting is a little bit more personal than technical. It seems that I don’t have… Read more

14 comments, 273 reads

Posted in Klaus Aschenbrenner on 25 October 2018

Query Memory Grants and Resource Semaphores 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 Query Memory in SQL Server, and want to… Read more

10 comments, 1,921 reads

Posted in Klaus Aschenbrenner on 16 October 2018

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

In today’s blog posting I want to give you a brief overview about my upcoming Speaking Schedule,… Read more

0 comments, 151 reads

Posted in Klaus Aschenbrenner on 24 September 2018

New Whitepaper: Architecting Microsoft SQL Server on VMware vSphere

(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 VMware has released a new whitepaper with the very promising title “Architecting Microsoft SQL… Read more

2 comments, 230 reads

Posted in Klaus Aschenbrenner on 18 September 2018

Service Broker Target for Extended Events

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

During one of my last Online Trainings about Extended Events, someone asked me about the Service… Read more

2 comments, 1,999 reads

Posted in Klaus Aschenbrenner on 10 September 2018

Moving a SQL Server Availability Group to a different Subnet

(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 days I have reworked my home network design, and introduced a new subnet… Read more

1 comments, 2,203 reads

Posted in Klaus Aschenbrenner on 3 September 2018

The unwanted Side Effects of enabling Read Committed Snapshot Isolation

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

A lot of developers are approaching me very often, and tell me that they are using the… Read more

1 comments, 384 reads

Posted in Klaus Aschenbrenner on 30 August 2018

Is a SELECT statement always executed?

(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 quite simple question in SQL Server: is… Read more

0 comments, 90 reads

Posted in Klaus Aschenbrenner on 22 August 2018

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, 1,790 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,590 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, 757 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

3 comments, 2,055 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, 272 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, 698 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

9 comments, 2,174 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, 323 reads

Posted in Klaus Aschenbrenner on 9 January 2018

Older posts