SQLServerPedia

Perform a Rolling Upgrade to SQL Server 2008 R2 SP2 in a Database Mirroring Scenario

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

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 a Rolling Upgrade to SP2 …

Perform a Rolling Upgrade to SQL Server 2008 R2 SP2 in a Database Mirroring Scenario + read more

SQL Server 2012 AlwaysOn Availability Groups – Part 4: Adding new Replicas

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

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 now an Availability Group called …

SQL Server 2012 AlwaysOn Availability Groups – Part 4: Adding new Replicas + read more

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

Moving from Windows to Mac – a true love story

08/04/2014 / By / .NET German, Apple, SQLServerPedia / 3 Comments

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

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

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.