Feed on
Posts
Comments

Category Archive for 'Databases'

In the past few months, I’ve been working more closely with Database because the departure of our DBA. I have been doing deployments that are involved in adding and altering schema changes. Whenever a new table is added to SQL replication you need to generate replication store procedures at the publisher and the take the […]

Read Full Post »

At my work, we have MSSQL with replication. The problem is we have 5 SQL subscribers. Our R&D department keep coming out with Store Procedures. In order to deploy these new store procedures to production, we need to run the script on every servers. This is not only time consuming, but bounded to human error.
In […]

Read Full Post »