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.

Performance improvements in SQL Server 2014

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

SQL Server 2014 will be an amazing release regarding all the various performance enhancements that are part… Read more

2 comments, 356 reads

Posted in Klaus Aschenbrenner on 18 March 2014

Buffer Pool Extensions in SQL Server 2014

(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 Buffer Pool Extensions that are introduced with SQL… Read more

0 comments, 506 reads

Posted in Klaus Aschenbrenner on 11 March 2014

SQL Server Quickie #11 – Non Clustered 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.)

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

0 comments, 153 reads

Posted in Klaus Aschenbrenner on 3 March 2014

Lock Escalations

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

In todays blog posting I want to talk about Lock Escalations in SQL Server. Lock… Read more

0 comments, 2,125 reads

Posted in Klaus Aschenbrenner on 25 February 2014

Improving SQL Server Performance by using Instant File Initialization

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I want to talk about a very specific topic in SQL Server – Instant… Read more

0 comments, 2,221 reads

Posted in Klaus Aschenbrenner on 18 February 2014

DELETE operations on tables

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

In todays blog posting I want to show you quickly about what happens in SQL… Read more

0 comments, 341 reads

Posted in Klaus Aschenbrenner on 11 February 2014

Announcing the SQLpassion Performance Tuning Training Plan

You are a developer and/or DBA and want to learn in a very compact way the essential things about performance tuning & troubleshooting SQL Server installations? In our new free 6 month long SQLpassion Performance Tuning Training Plan we give you week by week via email all the essential knowledge… Read more

0 comments, 341 reads

Posted in Klaus Aschenbrenner on 3 February 2014

SQL Server Quickie #10 – Forwarding Records

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

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

0 comments, 340 reads

Posted in Klaus Aschenbrenner on 29 January 2014

Inside the Statistics Histogram & Density Vector

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

You know the problem: the “Estimated Number of Rows” in an operator in the Execution… Read more

0 comments, 1,430 reads

Posted in Klaus Aschenbrenner on 28 January 2014

Myths and Misconceptions about Transaction Isolation Levels

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

In todays blog posting I want to talk about myths & misconceptions about the various… Read more

0 comments, 2,293 reads

Posted in Klaus Aschenbrenner on 21 January 2014

How to throttle your Storage with Resource Governor in SQL Server 2014

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

In todays blog posting I want to talk about a very cool enhancement in SQL… Read more

0 comments, 418 reads

Posted in Klaus Aschenbrenner on 14 January 2014

Why Transaction Log Auto Growths are degrading your performance

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

In this blog posting I want to talk a little bit in more detail why… Read more

0 comments, 1,144 reads

Posted in Klaus Aschenbrenner on 7 January 2014

SQL Server Quickie #9 – Clustered Indexes

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

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

0 comments, 289 reads

Posted in Klaus Aschenbrenner on 6 January 2014

How SQL Server 2014 improves Online Operations that aren’t Online Operations

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

In todays blog posting I want to talk a little bit about Online Index Rebuild… Read more

0 comments, 431 reads

Posted in Klaus Aschenbrenner on 2 January 2014

SQL Server Quickie #8 – Hash Indexes

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

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

0 comments, 299 reads

Posted in Klaus Aschenbrenner on 5 December 2013

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,426 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, 222 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, 430 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, 346 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, 329 reads

Posted in Klaus Aschenbrenner on 2 November 2013

Newer posts

Older posts