Change Data Capture if enabled on Database & Tables stores pre and post modification data in separate set of tables. In our project we were using this data regenerate Insert, Update and Delete Sta... [More]

In Data Replication Project, there was a need to simulate recovery in event of server crash. To recover as much data as possible, we needed to restore transaction log files. Challenges: N... [More]

If you have been reading my earlier posts a big Thanks . If not and if you want to follow from here again Thanks , atleast read SQL Server Data Replication Project - 4 (Summarizing)as it sets context.... [More]

A very nice Yahoo!Core home page.. Wonderfully done. http://visualize.yahoo.com/core/   -Guru

Summarizing requirements: All of previous posts, could be summarized as done in this post. Read all of previous posts here Embarking on New Project–SQL Server Replication SQL Server Replicati... [More]

Server Size: With network requirements behind us, for data replication, data from distributed systems needs to be moved to central server. Central server holds duplicate data (subscriber in transacti... [More]

Network: Network is most important for successful implementation of data replication solution. Network requirements and constraints define appropriate data replication solution to be used. Network req... [More]

<If article is long and time is short which is always the case, read text highlighted in blue italics> For Data Replication between central server and distributed servers, 2 options are being c... [More]

Have you ever had encountered SQL Server Management Studio crash. Recently encountered one such crash, not that it never crashed prior to that, but never bothered to look at it, would just launch mana... [More]

Admittedly been quite lazy and busy at same time.. Busy with client projects but enough time to blog but lazy not to blog. So, breaking shackles of laziness here is first post of 2012. Started working... [More]