SQLr2If you have or want to build an application that receives a lot of bits of data from multiple sources and turn it into meaningful information in near real time, then Microsoft SQL Server StreamInsight August CTP is for you. Use StreamInsight when traditional store and query techniques are impractical for timely and relevant processing of data.

The community preview has just been released on TechNet and MSDN or you can download it from SQL Streaminsight. The announcement was made at the Data Platform Insider. Release is scheduled for the first half of 2010.

With StreamInsight you take streaming data and present it to users in near real time. It adds a low-latency complex event processing platform to SQL Server. You write as many queries against the incoming data that are required to process the incoming data stream. You can run them against many incoming streams of data and can combine them with your historical data. Use the results to build key performance indicators (KPIs) or other values for immediate feedback to your customers.

You can do this using tools that are familiar including .NET, LINQ, and Visual Studio. There are several deployment options so you can set up the entire system to meet your customer needs.

ISVs can use this to create applications in manufacturing, oil and gas, utilities, financial services, health care, Web analytics and IT and data center monitoring.

Some of the key feature areas are:

  • Derive meaningful and relevant information from data/events streams through complex patterns. These patterns can be defined using a declarative query paradigm based on well-defined streaming semantics with LINQ as query language.
  • For the development of applications, adapters, and analytics, the user can rely on well-established and powerful development frameworks and tools such as .NET, LINQ, and Microsoft Visual Studio.
  • The platform integrates with various data sources and sinks through input and output adapters. The framework to build domain-specific adapters utilizes a .NET API to make adoption of the platform easy. Independence between adapters and queries facilitates seamless integration of real-time and historical analysis.
  • The platform architecture supports a variety of deployment options, from scenarios with a low-footprint embedded option to high-end server deployments.
  • A rich set of manageability features such as a management interface, a diagnostic interface and a debugging tool are provided as part of the platform.

For more information, see

Bruce D. Kyle
ISV Architect Evangelist | Microsoft Corporation

cid:image010.png@01C9DEED.1FDB2200 cid:image011.png@01C9DEED.1FDB2200 cid:image012.gif@01C9DEED.1FDB2200 channel9