Welcome to the Cincinnati Professional Association for SQL Server!

CincyPASS is a professional organization/user group dedicated to all aspects of SQL Server from database administration to application development and business intelligence.

Our meetings occur every month on the 3rd Tuesday, in the Microsoft office located at 4445 W Lake Forest Drive, Suite# 100, Blue Ash, OH 45242. Please ensure to register to help us plan for food. Unless noted otherwise the monthly meeting agenda will be

  • 5:30 - Networking and Food
  • 6:00 - PASS news and Announcements
  • 6:15 - Featured Presentation
  • 7:15 - Q&A Session / Door Prizes


Next Meeting: Tue, Mar 21 2017

SQL Server Transactional Replication: A Deeper Dive

Language: English
Event Type: In-Person
Online Meeting URL: None


UTC : Tue, Mar 21 2017 22:00 - 00:00
Event Time : Tue, Mar 21 2017 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Tue, Mar 21 2017 22:00 - 00:00


4445 W Lake Forest Drive
Blue Ash, Ohio

Direction: None

Featured Presentation

SQL Server Transactional Replication: A Deeper Dive

Speaker: Drew Furgiuele, Senior DBA IGS Energy

Summary: Ah, SQL Server Transactional Replication. The technology everyone loves to hate. But for all the notoriety, there's some interesting technology to be had in it that might you might want to leverage. In this session, we'll explore what happens when you create a new transactional publication: what happens during a snapshot, how data gets delivered to subscribers, and how you can monitor, tweak, and tune your publications. We'll also see some common trouble spots and how to identify them. There will be plenty of examples and demos and, yes, even some PowerShell!

About Drew: I am a senior DBA that is passionate about SQL Server, PowerShell, automation, source control, and release management, and mixing them all together in a funky blender. I've been in the game since SQL Server 2000, and I haven't stopped wanting to learn more and share my experiences since.






Back to Top