191 reputation
6
bio website
location
age 30
visits member for 2 years, 4 months
seen May 2 at 14:41

Jul
2
awarded  Curious
May
2
accepted Generic script for stored procedure rollback
Apr
25
comment Generic script for stored procedure rollback
I agree that human has to do the merge an all. I was thinking of getting rid of the recreation of rollback scripts if somebody deployed something right before me.
Apr
25
comment Generic script for stored procedure rollback
Yes, we do have them source controled. I'm thinking on a scenario where 2 devs work on the same stored proc during a sprint. Neither on of them knows which will finish first and the version that they have to provide as rollback might be behind already if the other developer deployed his changes. Let's say 5 min before
Apr
25
asked Generic script for stored procedure rollback
Oct
2
accepted Transactional Replication: When to delete the initial snapshot
Oct
2
asked Transactional Replication: When to delete the initial snapshot
Jun
17
accepted how often to run Tablediff
Dec
15
awarded  Tumbleweed
Dec
10
comment how often to run Tablediff
I wonder if the performance in the server decreases a lot. I would like to keep the data replicated, and check for consistency often.
Dec
10
asked how often to run Tablediff
Dec
5
comment SQL Server Replication tools
We're targeting for 1 or 2 hours max. Data is about 100 GB more or less
Dec
5
comment SQL Server Replication tools
Yes. I also think it was a user error the one that arose. About the schema, indexes and such. It is a Microsoft Dynamics DB. I'm hoping replicating a DB designed by MS should be easier
Dec
5
asked SQL Server Replication tools
Nov
2
revised SQL Server 2005 replication for a data warehouse
added 72 characters in body
Nov
2
comment SQL Server 2005 replication for a data warehouse
Kimball's books looks like a very good reference. I used Data Warehouse in quotes because we mainly want to replicate the data stored in our different servers to a central one that we can access to create our reports and occasional queries. The main reason for that is that we can take some load off our production servers. That's why I believe is not a real Data Warehouse.
Nov
2
asked SQL Server 2005 replication for a data warehouse
Jun
26
comment How to set the language of a doc to a DB field
It also worked by getting the value in the application that calls the report, a web app in my case, and then passing the value as a parameter to the report.
Jun
26
accepted How to set the language of a doc to a DB field
Jun
26
asked How to set the language of a doc to a DB field