{"id":993,"date":"2014-02-03T16:11:16","date_gmt":"2014-02-03T16:11:16","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=993"},"modified":"2024-01-06T16:46:07","modified_gmt":"2024-01-06T16:46:07","slug":"feb-12-2014-advanced-transactional-replication-john-flannery","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=993","title":{"rendered":"Feb-2014 ~ Advanced Transactional Replication ~ John Flannery"},"content":{"rendered":"<p><a href=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2014\/02\/john_flannery.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-992\" alt=\"john_flannery\" src=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2014\/02\/john_flannery.jpg\" width=\"150\" height=\"150\" srcset=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2014\/02\/john_flannery.jpg 200w, https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2014\/02\/john_flannery-150x150.jpg 150w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a><\/p>\n<p><span style=\"color: #800000;\">Presenter:<\/span> John Flannery<br \/>\n<span style=\"color: #800000;\">Topic:<\/span> Advanced Transactional Replication<\/p>\n<p>We will cover several advanced topics in Transactional Replication including how to make a ddl change to one table in the publication without reinitializing the publication; how to make a ddl change to a table without having to snapshot; creating replicated tables on file systems other than Primary \u2013 including partitioned file systems; and bidirectional replication. And hint \u2013 we will be leaving the wizard in Redmond!! Bring a copy of SQL 2012 Developers Edition with AdventureWorks2012 if you want to play along.<\/p>\n<p><span style=\"color: #800000;\">Biography:<\/span><\/p>\n<p>John is the Data Architect at Evolution 1 in Avon Connecticut \u2013 and Adjunct Professor at Quinnipiac University in Hamden, Connecticut. He has 33 years industry experience; working with SQL server since version 4.2 on OS\/2, Oracle since 7.3.4. John holds a Master of Science \u2013 Computer Science degree from Rensselaer (1995). Publication List: A Strategy for Implementing SSIS in Clusters; SQL Server Magazine; March 2010, page 15.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Presenter: John Flannery Topic: Advanced Transactional Replication We will cover several advanced topics in Transactional Replication including how to make a ddl change to one table in the publication without reinitializing the publication; how to make a ddl change to a table without having to snapshot; creating replicated tables on file systems other than Primary [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[184],"tags":[164,163,69],"class_list":["post-993","post","type-post","status-publish","format-standard","hentry","category-2014-events","tag-advance-scriptingi","tag-transactional-replication","tag-tsql"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=993"}],"version-history":[{"count":6,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/993\/revisions"}],"predecessor-version":[{"id":1125,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/993\/revisions\/1125"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}