SQL Server

Take a practical case in which have to migrate a production SQL Server instance from Windows Server 2003 Cluster to Windows Server 2008 Cluster. One of the first steps for a migration is shut down the SQL Cluster service and delete the name of the Read More

With the Slipstream funcionality we can integrate Service Pack or Cumulative Updates to the SQL Server installer, this save much time, specially when you need to do multiple installations. This guide is a modification of How to slipstream SQL Server 2008 R2 and a SQL Server 2008 Read More

In one of our environments, we have a cluster with two active-active nodes with one SQL Server instance in each one.During this week, a fail of the service occurred in one of the nodes, which caused a failover to the node that was available.The problem Read More

In one of our environments, we have two SQL Server 2008 R2 DB aligned together by Peer to Peer replication, and each of the databases have a Merge replication with multiple subscribers. When we try to make an update on a article/table that is published in Read More

Sometimes you need to know all the tables that are replicated in a DB, for that use this scripts, run it in the replicated DB: Fran LensWorking with data technologies since 2008, my main expertise is in SQL Server but I work well as a Read More

We found an error in Merge replication that im going to describe: When a Subscriber SQL Server 2005 Express replicates against a Publisher SQL Server 2008 R2 with a publication that has filtered articles, the option use_partition_groups set to true and contains an article with Read More