SQLServer

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

08/04/2014 / By / .NET German, AlwaysOn, SQLServer, SQLServerPedia

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 Group into production, you need …

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

SQL Server 2012 AlwaysOn Availability Groups – Part 2

08/17/2015 / By / .NET German, AlwaysOn, SQLServer, SQLServerPedia

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

08/04/2014 / By / .NET German, SQLMCM, SQLServer, SQLServerPedia

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…

08/04/2014 / By / .NET German, SQLServer, SQLServerPedia / 2 Comments

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

08/04/2014 / By / .NET German, Conferences, SQLServer, SQLServerPedia / 1 Comment

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

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.