SQL Server StreamInsight and SQL Azure Database CTP August 24th, 2009

Vinod Kumar

With this announcement close to a week, I am yet to log this into our blog J. There are tons of interesting blogs that point to SQL Server StreamInsight and SQL Azure Database CTP.

You can read the official announcement at the Data Platform Blog. SQL Server StreamInsight is officially shipping as a component of SQL Server 2008 R2, which is scheduled to be available in first-half-2010. StreamInsight will bring a low-latency complex event processing platform to SQL Server, and will enable organizations to derive insights from streaming data in near real-time for scenarios such as web analytics, algorithmic trading and industrial process control. If my memories serve right, CEP (complex event processing) is more directed for continuous data – in telecom/retail/finance world. CEP is the continuous and incremental processing of event streams from multiple sources based on declarative query and pattern specifications with near-zero latency. Some of the possible scenarios include:

  • Algorithmic trading and fraud detection for financial services
  • Industrial process control (chemicals, oil and gas) for manufacturing
  • Electric grid monitoring and advanced metering for utilities
  • Click stream web analytics
  • Network and data center system monitoring.

SQL Azure Database CTP

The first CTP of SQL Azure Database, a cloud-based relational database service built on Microsoft SQL Server technologies also was announced.  With SQL Azure Database, customers can easily provision and deploy relational database solutions to the cloud, and take advantage of a globally distributed data center that provides enterprise-class availability, scalability, and security with the benefits of built-in data protection, self-healing and disaster recovery. Customers can register for the free trial at http://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx. Due to high demand for the SQL Azure Database CTP, there are some delays in receiving invitation codes for new participants.

SQL Server Driver for PHP 1.1 Community Technology Preview – August 2009

This download provides new capabilities for building PHP applications and support for SQL Azure, enabling developers to build PHP apps with relational database capabilities using SQL Server or SQL Azure Database.  With the explosion of data-driven Web 2.0 applications, along with the need to extend existing applications and build innovative data solutions in the cloud – these are exciting milestones.  With SQL Azure, developers building Web 2.0, ASP.NET and PHP applications can use familiar tools and data models to develop on a pay-as-you-grow, secure, scalable and highly available database service at minimal infrastructure cost.

Links –

Download the Microsoft SQL Server StreamInsight August Community Technology Preview and Microsoft® SQL Server® 2008 R2 August Community Technology Preview

Trial: Try SQL Azure August CTP

Learn more about Microsoft® SQL Server® 2008 R2, Microsoft SQL Server StreamInsight, SQL Azure and Project “Madison”

 

Tags: , , , , , , ,

This entry was posted on Monday, August 24th, 2009 at 14:32 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.


One Response to “SQL Server StreamInsight and SQL Azure Database CTP”

  1. dilip says:

    pls send a questions sql server2005

Leave a Reply