Next Meeting: Wed, Dec 07 2016
FoxPASS December 2016 Meeting
Event Type: In-Person & Online
Online Meeting URL: https://meet.lync.com/sqlpass365-sqlpass/fox/Q53Y0PVE
Kendal Van Dyke will be joining us remotely to talk about troubleshooting replication in SQL Server.
Event Time : Wed, Dec 07 2016 17:30 - 19:30 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Wed, Dec 07 2016 23:30 - 01:30
4351 W College Ave
Transactional Replication: Architecture, Setup, and Monitoring
Kendal Van Dyke, Senior Consultant Microsoft
At some point in every DBA's career they'll be probably be asked to work with transactional SQL Server replication. While it may seem scary at first, it's not that complicated once you understand how all the parts and pieces work together. In this session we'll cover the fundamentals of how transactional replication in SQL Server works, walk through setting up a working replication topology, and learn how to keep an eye on things to make sure everything is working properly.
- Understand core concepts of transactional replication including: replication topologies, publishers, distributors, agents, & agent profiles.
- Learn how to configure a working replication topology
- Learn how to how to monitor transactional replication performance
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, & debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.