Next Meeting: Thu, Jan 16 2014
16 JAN 2014 NTSSUG Meeting
6:00 - 6:20 - Welcome, Announcements & Food
6:20 - 7:20 - Transactional Replication Internals and Process Flow by Fany Vargas
7:30 - 8:30 - T-SQL Throwdow by Hakim Ali
8:30 - 8:45 - Raffle and closing.
Event Time : Thu, Jan 16 2014 18:00 - 21:00 (GMT-06:00) Central Time (US & Canada)
Your Local Time: Fri, Jan 17 2014 00:00 - 03:00
Microsoft Building LC-1
7000 North Highway 161
Transactional Replication Internals and Process Flow
Fany Vargas, Sr. Premier Field Engineer (Dedicated Support) Microsoft
Throughout this mostly-demo session we will step through the replication metadata details at each step of the change process. You will learn what the principal components of transactional replication are, how replication tracks changes internally (from the transaction log to various system tables), and what tools to use to gain insight into this replication metadata. This knowledge is essential when troubleshooting or when deciding between various replication architectures.
- Objectives for the session:
a) Understand the principal components of Transactional Replication
b) Understand how Transactional Replication tracks changes
c) Understand what tools to use to gain insight into replication metadata
Fany Vargas is a Sr. Premier Field Engineer (Dedicated Support) at Microsoft. She has worked in various roles within the Microsoft SQL services and support teams throughout the past 11+ years - ranging from Support Engineer, Technical Lead, Support Escalation Engineer, and Premier Field Engineer. She graduated with a bachelor’s degree in Computer Science from Florida International University in 2002 and currently holds the MCSE: Data Platform (SQL 2012) certification.
Join us for a game of SQL that combines fun, learning SQL, networking, and friendly competition with your peers. Create your team for a SQL-off against other teams. If you can write a SQL query, you have the skills required to play. Each team must bring a laptop with SQL Server 2012 Express and AdventureWorks 2012 pre-installed. Please read full rules here: http://www.sqlzen.com/t-sql-throwdown.html
Database designer, developer, and now DBA with over ten years of experience with SQL Server. Passionate about database performance.