Klaus Aschenbrenner - November 2013 - Blogs - SQLServerCentral

Click here to monitor SSC

<a href="//g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

Write for us

<a href="//g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

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.

Archives: November 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,326 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, 189 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, 380 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, 321 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, 307 reads

Posted in Klaus Aschenbrenner on 2 November 2013