Microsoft is continuing to move some of its SQL Server capabilities to the cloud and turn them into services.
The latest to join the coming SQL Azure services line-up ? alongside the already announced (but still undelivered) SQL Azure Reporting Services ? is complex-event processing. The cloud version of this capability is known as codename ?Austin,? according to a couple of new Microsoft blog posts this week.
Austin will be the service version of the StreamInsight complex-event-processing capabilities that are in SQL Server today. Complex event processing ?enables real time insight into vast volumes of streaming data,? according to Microsoft?s explanation, which is distinct from, but related to, business intelligence, which ?enables analytics and insight into a set of existing data to inform future decision making.?
Austin is being released in private Community Technology Preview (CTP) form now, but will be available as a public CTP, available from the SQL Azure Labs Site, in the second half of the year. Microsoft isn?t sharing publicly a release target for the final version of Austin.
By hosting StreamInsight on the Windows Azure platform, Microsoft will allow customers and partners ?to build event-driven applications where the analysis of the events is performed in the cloud,? explained Zane Adam, a Microsoft General Manager of Azure and Middleware.
Among some of the potential scenarios where Austin could be used, as envisioned by Microsoft:
- Collecting data from manufacturing applications (e.g. real-time events from plant-floor devices and sensors)
- Financial trading applications (e.g. monitoring and capitalizing on current market conditions with very short windows of opportunity)
- Web analytics (e.g. immediate click-stream pattern detection and response with targeted advertising.)
- ?Smart grid? management (e.g. infrastructure for managing electric grids and other utilities, such as immediate response to variations in energy to minimize or avoid outages or other disruptions of service).
Austin can help customers from having to implement complex event processing on-premises themselves, ?but more importantly, be able to collect and process events from anywhere on the planet and derive trends from a vastly increased series of events since that data is sent to the cloud.?
Microsoft made a CTP for a database import/export capability available this week, as well. This capability is designed to allow SQL Azure database users to more simply archive SQL Azure and SQL Server databases, or to migrate on-premises SQL Server databases to SQL Azure, according to company officials.