What is the GDPR? The General Data Protection Regulation, or also known by its acronym GDPR, is the Law on the protection of personal information which must be complied with throughout the European territory since May 25, 2018. Basically, this regulation seeks to protect…
SQL Server Backup “Mirror To” Local y Azure
Nos encontramos en unos tiempos en los que muchas empresas están migrando a Azure, ya sea total o parcialmente. Uno de los primeros elementos que se aventuran a probar es el almacenamiento y más en concreto el Backup a Azure, ya que sobretodo las empresas…
What I learned in the last year? Resources and websites that help you get started with SQL Server
Within days, June 20th, will be one year since I joined Avanade Spain, so I think that is a good moment to stop and think over all learned in the last 366 days. I can safely say that this was the…
How to create an SQL Server 2012 installer with integrated CU1 (Product Updates – Slipstream)
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…
Resurrect SQL Server Agent after repair an instance
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…
Script: Reduce Log File depending on DB Data Files size
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:
Scripts: Jobs Not Executed in the Last Year / Job Activity Details
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…
The merge process was unable to create a new generation at the ‘Publisher’
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,…
Rollback process for a failed SQL Server Cluster Instance migration
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…
Quick way to create a SQL Server 2008 R2 installer with integrated SP1 (Slipstream)
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…