modernization
23 TopicsStream data changes from Azure SQL Database - a call for Private Preview of Change Event Streaming
In today's rapidly evolving digital landscape, modern, flexible and real-time data integration from various sources has become more important than ever. Organizations are increasingly relying on data-driven and real-time insights to make informed decisions, optimize operations, and drive innovation. In this context, we are excited to announce a private preview for Change Event Streaming, which enables you to stream your data changes from your SQL database directly into Azure Event Hubs. Starting from today, you can apply for the private preview program. Participants can test the functionality on Azure SQL Database and Azure Event Hubs, and support for more sources and destinations is planned. Participating in the private preview gives you an opportunity to work with the product team, test the functionality, provide your feedback and influence the final release. Note: CES can be tested on Azure SQL Database, and that includes its free offer. Typical use cases for Change Event Streaming are: Building event-driven systems on top of your relational databases, with minimal overhead and easy data integration. Data synchronization across systems, and more specifically, syncing data between microservices or keeping distributed systems in sync. Implementing real-time analytics on top of your relational data. Auditing and monitoring that requires tracking changes of sensitive data or logging specific events. Main advantages for using a message broker such as Azure Event Hubs, and Change Event Streaming are: Scalability, as message brokers are designed to handle high-throughput and can scale independently from a database. Decoupling, as systems downstream from a database and message broker are loosely coupled, enabling greater flexibility and easier maintenance. Multi-consumer support, as Azure Event Hubs allow multiple consumers to process the same data stream, enabling varied use cases from a single source. Real-Time integration, which enables seamless integration between OLTP systems and downstream systems for real-time data flow. If mentioned use cases and advantages resonate with requirements of your architectures, systems and solutions, then Change Event Streaming is the right choice for you. To apply for the private preview, please send email to sqlcesfeedback [at] microsoft [dot] com, and we’ll get back to you with more details! Useful resources Free Azure SQL Database. Free Azure SQL Managed Instance. Azure SQL – Year 2024 in review. Azure SQL YouTube channel.153Views1like0CommentsAzure SQL Managed Instance pools: General Availability
We are happy to announce new features and General Availability for instance pools. Instance pools are a deployment option in Azure SQL Managed instance service to provision small, cost-effective 2-vCore instances. This way, small instances can cost 50% less compared to non-pooled instances, making it an attractive PaaS target when migrating small on-premises servers or modernizing SQL VMs.874Views2likes0CommentsIntroducing Azure SQL Managed Instance Next-gen GP
The next generation of the general purpose service tier for Azure SQL Managed Instance is a major upgrade that will considerably improve the storage performance of your instances while keeping the same price as current general purpose tier. Key improvements in the next generation of general purpose storage include support for 32 TB of storage, support for 500 DBs, lower storage latency, improved storage performance, and the ability to configure the amount of IOPS (I/O operations per second).31KViews9likes7CommentsThe Right Tools for Optimizing Azure SQL Managed Instance Performance
Note: This blog is the second half of a series on maximizing performance in Azure SQL Managed Instance. If you missed the first half, check out Set Yourself Up for Performance Success on SQL Managed Instance.6.9KViews3likes4Comments