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.

Archives: August 2011

SQLMCM Training – Day 18

Today we covered the topics Full Text Search, Change Data Capture, Change Tracking, and Service Broker. I have taken no notes on Service Broker, because I have well documented that topic a few years ago here J.

Full Text Search

  • Fulltext Index is changed automatically in the background (by…

Read more

0 comments, 959 reads

Posted in Klaus Aschenbrenner on 26 August 2011

SQLMCM Training – Day 17

Today Bob spoke about Auditing, SQLCLR, XML, and Spatial Data. Because I already know these concepts very well, my study notes for today are very sparse.


  • SQL Trace has too much drawbacks from Auditing
    • Separate program
  • Column Level GRANT overrides a DENY
  • Auditing audits changes to Auditing
  • Auditing Targets…

Read more

0 comments, 655 reads

Posted in Klaus Aschenbrenner on 25 August 2011

SQLMCM Training – Day 16

Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting data. It was really hard content, and sometimes it was really hard to follow, because of too much PowerPoint slides. I already miss Paul's whiteboard drawings… ;-) Here are my study notes.

SQL Server Setup

  • SQL…

Read more

0 comments, 616 reads

Posted in Klaus Aschenbrenner on 24 August 2011

SQLMCM Training – Day 15

The whole last 3 days I've spent almost every minute with reviewing the material from the last 2 weeks (around 38 hours in total…). Today Bob Beauchemin joined us, and talks the whole week about SQL Server Development, Security, PowerShell, and some esoteric technologies like SQLCLR, Service Broker, and CDC/Change… Read more

0 comments, 608 reads

Posted in Klaus Aschenbrenner on 23 August 2011

Chance to win a free seat in my Performance Troubleshooting Workshop in London!

As you might know, I'm running my "Advanced SQL Server Performance Troubleshooting Workshop" from September 12 – 14 in Central London. You can find out further information about the detailed agenda here: http://csharp.at/Registration_UK.aspx

Next week you have the amazing possibility to win a free seat in that workshop!… Read more

0 comments, 951 reads

Posted in Klaus Aschenbrenner on 21 August 2011

SQLMCM Training – Day 11

Today Jonathan presented on Replication and Paul about Database Snapshots, and his baby called "CHECKDB" – he has been married with CHECKDB for almost 5 years at Microsoft.

Module 8: Replication

  • Distributes data to different locations
  • Offloading reporting to another database
  • Transactional Replication
    • Used in server-to-server scenarios that require high…

Read more

0 comments, 905 reads

Posted in Klaus Aschenbrenner on 19 August 2011

SQLMCM Training – Day 10

Today Paul was speaking about Database Mirroring and Jonathan was talking about Failover Clustering – all in all a very intensive day J

Module 6: Database Mirroring

  • Split Brain is possible
  • When you loose the witness, Database Mirroring goes into the asynchronous mode
    • No automatic failover possible
  • Witness should be…

Read more

0 comments, 589 reads

Posted in Klaus Aschenbrenner on 18 August 2011

SQL MCM Training – Day 9

Today Jonathan was talking the whole day about Consolidation and Virtualization. There were again a lot of new concepts, and new things to learn.

Module 4: Consolidation

  • Event Notifications for Monitoring
    • Deadlocks, Locking/Blocking Scenarios
  • Multiple Instances for TempDb bottleneck
  • Soft-NUMA should be used to bound multiple instances to dedicated CPUs

Read more

0 comments, 943 reads

Posted in Klaus Aschenbrenner on 17 August 2011

SQL MCM Training – Day 8

Today Paul talked the whole day about HA DR Strategies and Backup/Restore operations. I've already known a lot about Backup/Restores, but Paul showed some cool things that were even new to me J. Here are my study notes for the 3 modules of today:

Module 1: HA DR Strategies… Read more

0 comments, 722 reads

Posted in Klaus Aschenbrenner on 16 August 2011

MCM Training – Day 6 & 7

My whole weekend was dedicated to MCM studying, and I've reviewed a lot of stuff that we have learned through the last week, and I was also able to read a lot of additional whitepapers and blog posts, that Paul, Kimberly, and Jonathan have referred to us.

Today morning week… Read more

0 comments, 531 reads

Posted in Klaus Aschenbrenner on 15 August 2011

SQL MCM Training – Day 5

Today I've not taken too much notes, because the whole afternoon was about the Management Data Warehouse and Multi-Instance Management. But before that Paul and Jonathan have spoken a lot about troubleshooting with DMVs.

Module 12: DMVs – Part 2

  • sys.dm_io_virtual_file_stats
    • Spikes can't be seen from this DMV, only through…

Read more

0 comments, 1,355 reads

Posted in Klaus Aschenbrenner on 13 August 2011

Service Broker sample application from SQLskills Immersion Event

You can find my Service Broker sample application which I presented during the SQLskills Immersion Event in Bellevue here for download: http://www.csharp.at/Downloads/SQLskills_ServiceBroker.zip



Read more

0 comments, 1,254 reads

Posted in Klaus Aschenbrenner on 12 August 2011

SQL MCM Training – Day 4

Today Jonathan has presented on analyzing trace data, and Kimberly has spoken on troubleshooting Plan Cache Issues and Index Consolidation. It's really awesome when you listen to Kimberly, because she is speaking so fast, and delivers such a great quality of content – really awesome!!!

Module 10: Analyzing Trace Data… Read more

0 comments, 519 reads

Posted in Klaus Aschenbrenner on 12 August 2011

SQL MCM Training – Day 3

Nothing to say about today, Jonathan did really a great job describing Extended Events and Baselining/Benchmarking to us, and his boss – Paul – did a quick really great overview of Resource Governor. I've done a lot in these areas in the past, so that was a more easy one… Read more

0 comments, 1,039 reads

Posted in Klaus Aschenbrenner on 11 August 2011

SQL MCM Training – Day 2

Today's day was Jonathan Kehayias days, and it was pretty impressive. Jonathan covered the following 3 modules, and he can speak really continuously and forever J

  • IO – Storage Area Networks
  • IO – Installation and Testing

I've already read few whitepapers in the past about SANs and also watched… Read more

0 comments, 1,018 reads

Posted in Klaus Aschenbrenner on 10 August 2011

SQL MCM Training – Day 1

Today was my first day of SQL MCM training here in Bellevue. We started at 08:30am and now (05:30pm) Kimberly is currently talking about how to use the provided VPC J. The main theme for today's day was about learning the fundamental about performance tuning. We have covered the… Read more

2 comments, 1,665 reads

Posted in Klaus Aschenbrenner on 9 August 2011

SQL MCM Training – Day 0

For the next 3 weeks I'm in Bellevue/WA for the SQL MCM training provided by Paul Randal, Kimberly Tripp, and Bob Beauchemin of SQLskills.com. So don't expect any technical weblog posting from me within that time. I'm sitting in the following 3 training classes:

  • Performance Tuning (5 days)
  • High Availability…

Read more

1 comments, 629 reads

Posted in Klaus Aschenbrenner on 8 August 2011

My SQLbits sessions

Since today its official, I'm presenting 2 sessions at the SQLbits conference in Liverpool (http://www.sqlbits.com) from September 30 – October 1. Here are both of my session abstracts:

Advanced SQL Server 2008 Troubleshooting

It's Friday, 05:00pm. You are just receiving an email that informs you that your SQL… Read more

2 comments, 848 reads

Posted in Klaus Aschenbrenner on 3 August 2011