The Multifunctioning DBA

Dec 30 2010   4:50PM GMT

PASS Summit DVD’s already helping me out

Colin Smith Colin Smith Profile: Colin Smith

So I just got my DVD’s on Tuesday after getting back to the office after vacation. I have watched a few and all that I have seen are very good. But I must point out the session called “Transactional Replication: Beyond the Basics” by Kendal Van Dyke (Blog | Twitter).  Maybe it is just me and perhaps only because I got pulled into an environment that is using a lot of transactional replication and is having some issues. The issues are not only with replication but we have many issues with replication. I am also fairly new to replication. I understand what it does and the basics of how it works.

Kendal’s session really helped me out though. I have a much better understanding of what is going on “under the hood” with replication and I have some ideas of how I think we need to change our topology to better fill the needs of the application. He showed a the options that you have with replicating tables, procs, etc.. I had no clue that I had so many options. Now I can really dig into the replication and find out if we really are replicating all the data and information that we need to. I know for sure that all the tables do not have Primary keys and that is a big problem since that is a requirment to be able to replicate a table.

Another thing he went over is setting up alerts and doing it the correct way. This has been a problem for us but will not be any more.

Kendal is also very active on twitter with the #sqlhelp hashtag and gives out some great information about many topics to all.

Any way I just wanted to Tell Kendal that I enjoyed the session and I am sure that I will watch it again. I wanted to thank him along with all the other presenters at PASS. I have not watched them all yet but this one helps me now and gives me a good idea of where to start and how to accomplish what I need to get done.

The only negative thing I could say about the session recording, and I doubt this is Kenal’s fault, is that the audio cuts out at about 64:45 into it and does not come back until about 75:15 minutes. So that is about 10 minutes worth of information that I am missing out on. But a great session for me. Thanks again.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: