At this job, we used transactional replication extensively with dozens of publications pointing at multiple subscribers. We wanted to migrate the publisher without having to re-snapshot all of the publications. This is how we did it.
At work, we make extensive use of views & synonyms. The reasons are complex (and fodder for another post), but here’s a simplified example: Pricing data is updated multiple times per day, and we want to keep multiple generations of the pricing table online. By … [Read More]