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: July 2012

Perform a Rolling Upgrade to SQL Server 2008 R2 SP2 in a Database Mirroring Scenario

Yesterday evening (European Time zone) Microsoft has released the SP2 for SQL Server 2008 R2. You can download the Service Pack here: http://www.microsoft.com/en-us/download/details.aspx?id=30437

Because I'm currently working on a Database Mirroring Test Lab that is based on SQL Server 2008, I thought it would be a good exercise to perform… Read more

0 comments, 2,527 reads

Posted in Klaus Aschenbrenner on 27 July 2012

SQL Server 2012 AlwaysOn Availability Groups – Part 4: Adding new Replicas

In the last 2 blog postings you have learned how to setup your first Availability Group with SQL Server 2012. Today I want to show you how you can join an additional Replica to an existing Availability Group. When you have followed the last 3 blog postings, you should have… Read more

0 comments, 4,718 reads

Posted in Klaus Aschenbrenner on 26 July 2012

SQL Server Performance Tuning & Troubleshooting Workshop

Der Sommer 2012 ist schon ein interessantes Phänomen – gestern Sonnenschein mit 34°, und heute wieder Regen mit 20°. Gestern war Freibad angesagt, heute wird mit dem Kachelofen für Wärme gesorgt. Jeder Tag ist ein neues Abenteuer mit neuen Herausforderungen. Genau das Gleiche kann Ihnen auch mit dem SQL Server… Read more

0 comments, 1,273 reads

Posted in Klaus Aschenbrenner on 25 July 2012

SQL Server 2012 AlwaysOn Availability Groups – Part 3: Setting up AlwaysOn through T-SQL

In the last blog posting about AlwaysOn you have seen how you can deploy your first Availability Group through the AlwaysOn wizard provided by SQL Server Management Studio 2012. As usual this approach is very handy during development or testing, but as soon as you want to move your Availability… Read more

0 comments, 7,070 reads

Posted in Klaus Aschenbrenner on 23 July 2012

SQL Server 2012 AlwaysOn Availability Groups – Part 2

It's already a long time since I have blogged how to configure your Windows- and SQL Servers for SQL Server 2012 AlwaysOn. In the last 3 months I was almost every week on the road (or better in the air) visiting a lot of different clients across Europe, and helped… Read more

0 comments, 5,288 reads

Posted in Klaus Aschenbrenner on 19 July 2012

Service Broker Adventures: Stucked Queue Monitors

This week I'm in London helping a client with its large scale Service Broker deployment, mainly troubleshooting some strange problems with Service Broker and helping to improve the overall scalability and messaging throughput. Today I want to share a strange scenario with you, how a badly written Activated Stored Procedure… Read more

0 comments, 3,914 reads

Posted in Klaus Aschenbrenner on 3 July 2012