Do you find you need to keep SQL Server tables in sync across multiple systems? After several projects involving syncing data, we return to the topic of Azure SQL Data Sync with some real world examples of why we choose this option and how it worked for us. While there are some limitations, the feature is very stable, and we have had minimal, minor issues with it. Ideal for environments where latency is flexible, Azure SQL Data Sync could be a very helpful feature to get your data moved.
The show notes and video can be found at https://sqldatapartners.com/2022/01/20/episode-241-replicating-data-with-azure-sql-data-sync. Have fun on the SQL Trail!
Azure Synapse Link is a feature coming to SQL Server in the next release. While there are few details on what the new feature will look like, we discuss how this same service is implemented in other Azure services.
The show notes and video for this episode can found at https://sqldatapartners.com/2022/01/05/episode-240-azure-synapse-link. Have fun on the SQL Trail!