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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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: