Time ago, I created an automated batch procedure to create an SQL Server 2008 R2 Installer with Integrated SP1, known as Slipstream, now in SQL Server 2012 this was replaced with a new funcionality called Product Updates.  With the Product Updates funcionality we can integrate Read More

After a failed update from SQL Server 2005 to SQL Server 2008 R2 SP1, I decided to use the Repair option of the installer, the SQL Server resource was repaired correctly, but the SQL Server Agent couldn’t start.    The Agent service didn’t appear in the Read More

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 LensWorking with data technologies since 2008, my main expertise is in SQL Server but I work well 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