SQLServerPedia

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

SQL Server 2012 AlwaysOn Availability Groups – Part 1

In the last weeks and months I have prepared tons of SQL Server 2012 content for my own SQL Server 2012 Deep Dive Days workshop that I’m currently running across Europe. Because this content shows in a very good way how you can use all the various new features of SQL Server 2012, I have …

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