Share this PostHere is a quick ReplTip on difference in SQL Management Studio and Replication Monitor for Push v. Pull Subscriptions. Push v. Pull with Management Studio For PULL subscribers you must connect via SSMS or Remote Desktop (RDP) connection to the Subscriber to performance administrative tasks like starting, stopping, or changing parameters. The icon
Read More »
Share this PostJared Poché, MCSE, MCDBASQL Server Sr. Support Escalation EngineerProduct Support Services (PSS) – Charlotte, NC — updated 2/24/2019 One of the advantages of replication is that subscribing servers can be used for reporting thereby offloading RO query activity from the Publisher. Recently I worked on a performance case on such a replication subscriber,
Read More »
Share this PostWhile troubleshooting SQL Server Replication we often want to capture detail step-by-step execution of Replication Agent. One technique is to configure the Agent to log its execution to a Text file. This posting walks through a couple of different ways to accomplish this. It is also covered in the KB article http://support.microsoft.com/?id=312292. I’ll
Read More »
Share this PostBack in 2010 I hosted a SQL DBA best practices discussion during the Charlotte SQL Server Users Group meeting. I’ve attached a couple of slides used during the discussion. If you ignore the “Will you upgrade to 64bit?”, its interesting to see much of the content still applies today. Welcome-to-Camp-GeekaLot-for-SQLDBA Enjoy. Share this
Read More »
Share this PostEvery write an update statement touching +50 million commands in a single transaction? Ever on a table being Published in Transaction Replication? How about to a subscriber half way around the world or on a satellite connected network? While nothing in Replication design prevents, there may be challenges that should be considered when
Read More »