As a novice DBA, I like the simplified explanation with illustrations.I encourage you to do more tutorials. Excellent! I will check on the other videos.
saw a comment " best replication tutorial online". damn true :) completed tutorials form lynda, safari online etc but this is the best and simplest, easiest replication tutorial ever for beginners. ( For best experience play this at 1.75X speed)
Good video. Nice explanation. But, when explaining about merge replication, you asked a question, when source sends data to target, and target sends data to source, at the same time, who is going to win?" But I do not see a clear answer in this video for your question. All I get is, 'conflict resolution is superior". How is it resolved?
Hello sir, thanks for your awesome tutorial. Please I have a challenge with transactional replication. I noticed I can't make schema changes to the replicated tables (I can't add nor drop columns). Please how do I go about this? Please how do I make changes to a replicated table?
Is it best practice to only have one instance per SQL Server ? In our environments I ofter see two instances per SQL server but I don't know if this is common
mancusomjm mancusomjm Generally, in lower level environment you will see multiple instances for testing/developement/qa etc., Server will be busy if we put multiple instances. Generally it is ok for lower level env but in prod servers you dont want multiple instances. Basically SQL Server is a memory hog.