A friend asked me about a dynamic script to reduce the DB Log File based on the total size of DB Data Files, here is the answer: Fran LensConsultor Senior SQL Server & BI con 9 años de experiencia, MCSE Data Platform con conocimientos de Read More

A few days ago i was looking for a script to let me know when was the last execution of a job, so I can review the jobs that were not executed in the last year and delete the ones not needed, but i couldn’t Read More

Yesterday we did an massive update of 1 million of registers in a table of the replication DB, after the update , we started the replication of one computer, and we saw a failure in the first publication after 2000 seconds, showing the next error: Read More

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