Posted by: Colin Smith
DVD's, PASS, Sessions
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.