Change data capture (CDC) records insert, update, and delete activity that applies to tables in SQL Server, Azure SQL Managed Instance or Azure SQL Databases. In this Data Exposed episode with Mara-Florina Steiu, we will cover common use cases and scenarios for CDC, discuss key technical implementation details, and try out a CDC demo.
Whether it’s for reporting and offloading queries from production, there are things you need to keep in mind when using a Geo Replicated Azure SQL Database Readable Secondary.
Anna Hoffman speasked with MVP Monica Rathbun the challenges when it comes to performance tuning, what to keep in mind, and what to expect.
Azure SQL Database enables serverless and hyperscale scenarios, all backed by the enterprise-grade SQL Server engine. This video shows how to setup the database and update your website, in this case a map with real-time bus data, to use it.
In this episode of Data Exposed, Kate Smith will take you through the basics of why query processing matters, what it does, and how Intelligent Query Processing makes your workloads faster and more efficient.
Learn how storage impacts the performance of your database solution.
In this episode with MVP Argenis Fernandez, go over the basics of I/O, what the different access patterns are for the database engine and how to tell when there is an issue with underlying storage for your database.
In this episode of Data Exposed, Manoj Raheja shows us how to seamlessly integrate with Azure Data Explorer from Apache Spark for Azure Synapse Analytics.