SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

It Depends

Add to Technorati Favorites Add to Google
Browse by Tag : Replication (RSS)

Snapshots Part 1 Published on SSC

By Andy Warren in It Depends | 02-26-2008 8:29 AM | Categories: Filed under: ,
Rating: (not yet rated) Rate this |  Discuss | 3,362 Reads | 224 Reads in Last 30 Days |no comments

Snapshots Part 1 covers the basics of doing a snapshot regardless of what type of replication is being used. In Part 2 coming up in the next couple weeks I dig a little more into the underlying process -  not critical to know but helps dispel the black box syndrome.


Init from Backup Published on SSC

By Andy Warren in It Depends | 02-11-2008 7:13 AM | Categories: Filed under: ,
Rating: (not yet rated) Rate this |  Discuss | 1,869 Reads | 113 Reads in Last 30 Days |no comments

This article shows how to initialize a subscriber from a backup in SQL 2005. It's a niche technique, but it can be a very handy technique for all that. Strangely it's not supported via the UI, you have to add the subscription manually and then everything works normally from there. Heres the link: Init From Backup.


Replicate Stored Procedure Execution Published on SSC

By Andy Warren in It Depends | 11-05-2007 1:51 PM | Categories: Filed under: , ,
Rating: (not yet rated) Rate this |  Discuss | 1,943 Reads | 111 Reads in Last 30 Days |no comments

Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the publisher are applied one row at a time on the subscriber using the system generated procs created on the subscriber. I actually tend to agree with the concept, opting for a vanilla implementation whenever possible! Needing to update or delete a large number of rows is one place where vanilla plus a dab of butterscotch in the form of replicating stored procedure execution can make a big difference in overall time/resource usage.

Here's the link: http://www.sqlservercentral.com/articles/Replication/61332/


Replication Book Review/Intereview Posted on SSC

By Andy Warren in It Depends | 08-17-2007 1:59 PM | Categories: Filed under: ,
Rating: (not yet rated) Rate this |  Discuss | 2,125 Reads | 162 Reads in Last 30 Days |no comments
Book reviews aren't easy and it's always hard to tell if you're telling the reader anything they can't learn from Amazon. The comments on Amazon have to be taken with a grain of salt, as should my review of course. We're in the age of multi author books where multi-author used to be two, now it's five, or ten, or one per chapter (which is how the exam prep book that I worked on this year was done), so it was interesting to talk to someone who actually did the whole book themselves. It really is a decent book, just didn't quite have the bare metal down to the lowest level kind of power detail I would have really enjoyed, and probably don't know enough to write! Bren Newman has had a book on replication due out for over a year, not sure if it will make it to print or not, but I suspect it might be that kind of super detail book I'd enjoy. We'll see.

Here's the link to the article: Replication Book