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

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

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

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

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

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