SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Digging into Replication

It's fun to read good work, and my friend Kendal Van Dyke recently posted How CommitBatchSize And CommitBatchThreshold Affect Replication. He was looking for the answer to how/when to alter the values of those two settings and BOL just didn't make it clear, so after the standard bit of asking and searching, did the testing to figure it out for himself and identified a minor bug in the process of doing so.

Kendal might disagree, but I think it's perhaps his best blog post because he shows he can identify a point that might be useful and dig in to understand it, and when blocked, go deeper to research it himself. It's what I expect from a good Senior DBA but don't always find. The other part is taking the time and having a place to document his efforts, so that he leverages his investment.

So, read the link to learn about something interesting in replication, or read it to see a good example of research, or read it to see how it makes sense to have a blog to post a lesson learned.


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.


No comments.

Leave a Comment

Please register or log in to leave a comment.