Reputation
201
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 8
Newest
 Caucus
Impact
~4k people reached

  • 0 posts edited
  • 0 helpful flags
  • 10 votes cast
Aug
5
awarded  Caucus
Jun
16
awarded  Yearling
Nov
17
awarded  Popular Question
Oct
23
asked Copy related records from 3 tables to another 3 tables and maintain the relationship between them
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.