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
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 LensConsultor Senior SQL Server & BI con 9 años de experiencia, MCSE Data Platform con conocimientos de toda la Read More
Usamos cookies propias y de terceros para que podamos mejorar su navegación. Si continua navegando consideramos que acepta el uso de cookies. AceptarMás información
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.