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.

Myths and Misconceptions about Hekaton

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Over the last weeks and months, I invested a lot of my time to get a better understanding of Hekaton – the new In-Memory technology that will be part of SQL… Read more

0 comments, 2,173 reads

Posted in Klaus Aschenbrenner on 30 November 2013

How Hekaton will impact the RTO of your database

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Over the weekend I have encountered a very interesting side effect of Hekaton in SQL Server 2014, which unfortunately impacts your RTO (Recovery Time Objective) of your database in a negative… Read more

0 comments, 146 reads

Posted in Klaus Aschenbrenner on 25 November 2013

Choose your Hash Bucket Count very wisely in Hekaton!

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Today I have encountered a very simple blog posting where someone was inserting 1 millions of rows into a Hekaton Hash Index of 2048 buckets. Therefore I was running some tests… Read more

0 comments, 297 reads

Posted in Klaus Aschenbrenner on 23 November 2013

My SQLrally Session about how to measure Index Impact Changes

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

During the current week I have spoken at 2 SQLrally conferences, once in Stockholm/Sweden, and once in Amsterdam/Netherlands. At both conferences I have presented my brand-new session titled “How to measure… Read more

0 comments, 284 reads

Posted in Klaus Aschenbrenner on 8 November 2013

Announcing the SQLpassion Academy 2014 Course Schedule

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Time flies by, and the year 2013 is almost over for me. So it’s time to announce the course schedule of the SQLpassion Academy for the next year.

I’m running in… Read more

0 comments, 275 reads

Posted in Klaus Aschenbrenner on 2 November 2013

Fixing Cardinality Estimation Errors with Filtered Statistics

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Cardinality Estimation is one of the hidden gems in SQL Server. In general, Cardinality Estimation means that the Query Optimizer tries to find out during the query compilation, how many rows… Read more

0 comments, 1,579 reads

Posted in Klaus Aschenbrenner on 29 October 2013

My upcoming Speaking Schedule

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Over the next weeks and months I have a lot of various speaking engagements where I’m talking about various aspects of SQL Server Performance Tuning & Troubleshooting.

SQLSaturday #258, Istanbul/Turkey, October… Read more

0 comments, 326 reads

Posted in Klaus Aschenbrenner on 23 September 2013

Announcing the SQLpassion Online Academy

Over the last weeks it was a little bit silent on my Weblog for a very good reason: I’m very proud today to announce the SQLpassion Online Academy, where I’m providing in-deep SQL Server trainings directly to you!

Do you have enough from watching online Web Casts about SQL… Read more

0 comments, 353 reads

Posted in Klaus Aschenbrenner on 16 September 2013

How to become a better, well-rounded SQL Server DBA

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

People are sometimes asking me, how to become a better, well-rounded SQL Server DBA. Of course, the first reason with which I’m responding is “Experience, Experience, Experience”. Nothing helps you more… Read more

0 comments, 434 reads

Posted in Klaus Aschenbrenner on 4 September 2013

Extreme Transaction Processing (XTP, Hekaton) – the solution to everything?

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

My complete last week was dedicated to XTP (Extreme Transaction Processing), better known as Hekaton, that is introduced with SQL Server 2014. My main goal of the week was to get… Read more

8 comments, 619 reads

Posted in Klaus Aschenbrenner on 12 August 2013

Survey: Are you a SQL Server Professional and running on Mac?

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

I know a handful people who are SQL Server Professionals and using for their day-2-day job a Mac system. Since the summer of last year I have also joined that group… Read more

10 comments, 575 reads

Posted in Klaus Aschenbrenner on 8 August 2013

SQL Server Quickie #7 – TempDb Latch Contention

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Today I have uploaded the 7th SQL Server Quickie to YouTube. This time I’m talking about Latch Contention in TempDb. You can find the script used during the demonstration here as… Read more

0 comments, 624 reads

Posted in Klaus Aschenbrenner on 23 July 2013

SQL Server Quickie #6 – THREADPOOL Starvation

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Today I have uploaded the 6th SQL Server Quickie to YouTube. This time I’m talking about THREADPOOL Starvation in SQL Server. You can find the script used during the demonstration here Read more

0 comments, 797 reads

Posted in Klaus Aschenbrenner on 7 July 2013

Improved Temp Table Caching in SQL Server 2014

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Under some preconditions SQL Server is able to cache Temp Tables. Caching Temp Tables means that SQL Server doesn’t have to recreate them, when you are creating the same Temp Table… Read more

1 comments, 816 reads

Posted in Klaus Aschenbrenner on 27 June 2013

Non-Clustered Indexes on Table Variables in SQL Server 2014

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Earlier today I have seen a Tweet from Paul White, where he tweeted that SQL Server 2014 supports Non-Unique Clustered and Non-Clustered Indexes for Table Variables in SQL Server 2014. So… Read more

0 comments, 1,348 reads

Posted in Klaus Aschenbrenner on 26 June 2013

First steps with Extreme Transaction Processing – Hekaton

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

A few hours ago Microsoft released the first public CTP of SQL Server 2014. The download and the installation went very smooth, the only new restriction is that you are not… Read more

0 comments, 1,960 reads

Posted in Klaus Aschenbrenner on 25 June 2013

My upcoming SQL Server Trainings

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

The 1st half of 2013 is almost over, so it’s time to announce my upcoming SQL Server trainings for the rest of 2013. Besides my traditional SQL Server Performance Tuning &… Read more

0 comments, 727 reads

Posted in Klaus Aschenbrenner on 24 June 2013

SQL Server Tipping Games – Why Non-Clustered Indexes are just ignored!

Almost everytime when I’m doing SQL Server consulting engagements, DBAs are showing me queries and their Execution Plans, where SQL Server is just ignoring a good defined Non-Clustered Index. Imagine for example the following table and index definition:

CREATE TABLE Customers
(
   CustomerID INT NOT NULL,
   CustomerName CHAR(100) NOT NULL,…

Read more

0 comments, 640 reads

Posted in Klaus Aschenbrenner on 12 June 2013

My 2 cents on SQL Server 2014

Yesterday during the opening keynote of TechEd North America Microsoft released the first official details about the next version of SQL Server: SQL Server 2014. There are huge improvements in the area of High Availability, Performance, and Scalability, on which I want to concentrate in this weblog posting.

Disclamer:… Read more

5 comments, 1,420 reads

Posted in Klaus Aschenbrenner on 4 June 2013

Windows, RIP (1992 – 2013)

Today is a very sad day for me. My love, my dear Windows has passed away. We were together for over 20 years, her illness took control over her, and during the last days she passed away.

Before I give you further details about the disease she had over the… Read more

0 comments, 572 reads

Posted in Klaus Aschenbrenner on 17 May 2013

Newer posts

Older posts