Share this PostIn the recent past, we have seen questions on the strategy/steps on upgrading a replication topology especially from customers using SQL Server 2008/2008 R2 or running SQL Server on Windows Server 2008 and 2008 R2. We have outlined the most common topologies for replication and the possible upgrade paths for all releases from
Read More »
Share this PostChris SkorlinskiMicrosoft SQL Server Escalation Services If you’re familiar with Microsoft SQL Server Replication technology you already know each Replication Agent has various parameters or knobs you can set via Agent Profile or SQL Agent job parameter. This series of posts provide insight into tuning Replication performance using these knobs. Following the 80-20
Read More »
Share this PostChris SkorlinskiMicrosoft SQL Server Escalation Services I wanted to cover in this blog challenges you’ll encounter running Merge Agent on continuous schedule. These are Merge Agents whose SQL Server Agent jobs schedule are set for “Start automatically when SQL Server Agent starts”. Each time a Merge Agent starts it logs start
Read More »
Share this PostChris Skorlinski, Microsoft SQL Server Escalation Services Customer planning for migration to SQL Server 2016 asked for clarification on running mixed version of SQL Servers in their Replication Topology. I searched for “mixed version”, but was unable to find our posted topic. My colleague George Mason tracked it down under “upgrade”. I’m posting
Read More »
Share this Postby Holger Linke, Microsoft SQL Escalation Engineer GUIDs and Clustered Indexes Uniqueness is a key factor when synchronizing data between SQL Server/Azure and multiple endpoints like Slates and Smartphones. With data simultaneously created and updated on servers and clients, ensuring rows are unique to avoid key collisions is critical. As you know, each
Read More »