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.
(For those codename buffs keeping track at home, this isn't the first time Microsoft has used "Austin" as a codename. Version 2.0 of Microsoft's now-defunct ResponsePoint VOIP/telephony software for small businesses, also was codenamed "Austin.")
But back to the new Austin. 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, the Softies told attendees of the TechEd 2011 conference this week. 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, in a May 15 blog post.
Among some of the potential scenarios where Austin could be used, as envisioned by Microsoft:
Microsoft is pitching Austin as helping 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."
In other SQL Azure-related news this week, Microsoft officials said the company has released its May 2011 service update for SQL Azure, which includes four new updates:
Officials also told TechEd attendees this week that they are planning to add in some unspecified future SQL Azure release the integration of import and export features in the management portal; and enhancements to the Web-based database manager (a k a, “Project Houston”) for additional schema management, and a new service for managing SQL Azure databases through an Open Data Protocol endpoint.
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.