SQLpassion BLOG

Initialize a Transactional Replication from a Database Backup

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

During the last days I’m working on Replication – especially with Transactional Replication. The main idea of Transactional Replication is that you have a so-called Log Reader Agent on your Publisher SQL Server database running, that is analyzing the Transaction Log File and synchronize changes on so-called Articles through a Distribution database down to your …

Initialize a Transactional Replication from a Database Backup + read more

SQL Server Quickies – a new way to learn about SQL Server

08/05/2015 / By / .NET German, SQL Server Quickies, SQLServer, SQLServerPedia / 4 Comments

We are all living in a fast moving world, especially in the IT industry. We have to learn new technologies every few months and must keep our knowledge up-2-date to be competitive. A lot of us are learning through reading, and a lot of us are also learning through watching web casts and training videos. …

SQL Server Quickies – a new way to learn about SQL Server + read more

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

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.