#22-Adding Columns to a Large Table with Transactional Replication and Database Mirror

Report Builder
Speaker: Thomas LeBlanc

Add To Outlook: Add To Calendar

Date and Time: 6/14/2010 11:30:00 AM CST

BIO: Thomas is a Senior SQL Server DBA at Turner Industries in Baton Rouge, LA. and has worked in the IT field since 1989 starting with COBOL dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and .Net(C#). Designing and developing Normalized & Dimensional databases has become his passion. Full-time DBA work started in 2002 at a paper mill. He has been blessed with speaking at SQLRally and SQLPass in 2011 as well as SQLSaturdays and the local Baton Rouge User Group since 2009. Thomas’ free time is spent helping other & improving his relationship with his family & God. He blogs at TheSmilingDBA.Blogspot.com and tweets under @TheSmilingDBA.

Topic: #22-Adding Columns to a Large Table with Transactional Replication and Database Mirror
SQL Server 2005 updated replication with the ability to have schema changes replicated to subscriptions. This seemed to be a great solution to custom software releases. You could ALTER a table and the changes would magically appear on the subscriber. Life was great. Also in 2005, database mirroring came along to help with High Availability to a Disaster Recovery site. Life got even better. The problem is with large tables and Tlog heavy changes. This is a step by step process we use to release software to these large tables.