SQLpassion BLOG

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 them with their SQL Server …

SQL Server 2012 AlwaysOn Availability Groups – Part 2 + read more

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 isn’t really activated by Service …

Service Broker Adventures: Stucked Queue Monitors + read more

Killing me softly with Service Broker…

A few days ago, I found a very interesting behavior regarding Service Broker on a customer system. The main thing is that your activation stored procedure is not allowed to block for a very long time, otherwise you will impact the health of your whole SQL Server instance. In this blog posting I want to …

Killing me softly with Service Broker… + read more

My journey finally ends at the SQLPASS 2012 Summit

Yesterday SQLPASS revealed the sessions that were selected for the upcoming SQLPASS summit in Seattle from November 6 – 9. I’m very happy to announce that I’m presenting 2 regular sessions and a precon about SQL Server Performance Troubleshooting! I’m really happy to have a chance to present a precon, because this was one of …

My journey finally ends at the SQLPASS 2012 Summit + read more

Chance to win a free seat in my SQL Server 2012 Deep Dive Days workshop in London!

As you might know, I’m running my “SQL Server 2012 Deep Dive Days Workshop” from May 28 – 30 in Central London. You can find out further information about the detailed agenda here: http://www.SQLpassion.at/SQL2012_UK.pdf Next week you have the amazing possibility to win a free seat in that workshop! It’s very easy: Just register as …

Chance to win a free seat in my SQL Server 2012 Deep Dive Days workshop in London! + read more