Distributed Database Workload in Hybrid Environment

Sasa Popovic

One SQL Server instance is often not enough. Designing, developing, and working with distributed database systems comes with a set of challenges. Need to run transactions across multiple instances to achieve global data consistency? Is there a need for data replication across instances? How to implement in-database asynchronous message processing to distribute data workloads across instances, without programming complex communication? Let’s see what technologies are available in Azure SQL Managed Instance (a premier platform-as-a-service SQL Server offering) that are frequently used in distributed systems: distributed transactions, transactional replication, linked servers, service broker. What are the main characteristics of these technologies? What are their typical usage patterns? Attend this session to find out!