SQLpassion BLOG

Moving from Windows to Mac – a true love story

Since yesterday it is official: I own my first Mac computer – the new MacBook Air that was released a few weeks ago by Apple. I’m already owning the Lenovo W510 notebook for my “serious” SQL Server work (and a few other servers in my rack in the basement of our house), but I wanted …

Moving from Windows to Mac – a true love story + read more

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