DBA Unfiltered

  • ChatGPT Series Part 6: SQL Server Replication – Overview, Types, and Implementation

    The next installation of our ChatGPT series where ChatGPT gives me topics to blog about; everybody’s favorite topic – replication. In this post, we’ll cover the overview of replication, different types, and how to implement each type. Hopefully this can be your one-stop-shop for guidance on replication implementation. Overview of Replication Replication is a very…

    TheUnfilteredDBA

  • How to Set up Replication in an Always On Availability Group

    Replication can be a daunting technology to work with at times. Combine that with Always on Availability Groups (AAGs) and you may find yourself in a head scratcher of a situation. When deploying replication on a standalone server, it is not uncommon to see that same server act as a local distributor, meaning the distribution…

    TheUnfilteredDBA

  • How to Remove and Add a Single Article from Replication

    The Scenario You get a request from the business to remove a single table (article) from a publication because a large amount of development work has to be done against that object. Because of the large size of the publication, you need to figure out a way to remove, then add back the impacted article…

    TheUnfilteredDBA