SQLServerUpdates.com
  • Home – Most Recent Updates
    • SQL Server 2019 Updates
    • SQL Server 2017 Updates
    • SQL Server 2016 Updates
    • SQL Server 2014 Updates
    • SQL Server 2012 Updates
    • SQL Server 2008 R2 Updates
    • SQL Server 2008 Updates
  • Download SQL Server
  • Subscribe to Updates
  • Contact Us
    • Frequently Asked Questions

Announcing SQL Server 2019 CU13 and SSMS 18.10: Replication Improvements

2 years ago
Brent Ozar
SQL Server 2019, SSMS, Updates
No Comments

SQL Server 2019 Cumulative Update 13 and SQL Server Management Studio 18.10, both out today, combine to offer a neat improvement to peer-to-peer replication. Starting with CU13, there’s a new last-writer-wins option for conflict resolution. When the same data is updated on two different replication servers, whoever saved the data most recently, overwrites everybody else. If you’re a senior database administrator who’s been burned by replication conflicts before, that might sound a little terrifying, but it’s awesome for the right use case strategies.

This only works with peer to peer replication, and it requires a new hidden column that stores the update date in datetime2 format. For more details, check the conflict resolution documentation, which has already been updated to reflect the new option.

Both CU13 and SSMS 18.10 offer other improvements and bug fixes as well, and you can head to their respective pages to see more details.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
Announcing 2016 Service Pack 3 and 2017 CU26
Next Post
Announcing SQL Server 2019 CU15

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Subscribe

Want to get an email when Microsoft publishes a new SP or CU for SQL Server? Subscribe here.

Recent Updates

  • SQL Server 2022 CU3: How Stella Got Her Groove Back April 13, 2023
  • SQL Server 2022 Gets Its 2nd Update in 2 Days February 16, 2023
  • SQL Server 2022 Gets Its First Update! Plus 2019, 2017, 2016, 2014 Updates February 14, 2023
  • Announcing SQL Server 2019 CU15 January 27, 2022
  • Announcing SQL Server 2019 CU13 and SSMS 18.10: Replication Improvements October 5, 2021

© 2021 Brent Ozar Unlimited®. All Rights Reserved. Privacy Policy