Every Enterprise has always been on a continuous press to reduce the lag between data acquisition and data processing. When talking about moving data from a traditional desktop-based application to an Enterprise data warehouse application, the technology must support complex event processing and provide proactive results from monitoring.
SQL Server 2008 R2 has a new feature, StreamInsight. StreamInsight is a powerful platform that enables the processing of high-speed data streams from multiple data sources. The technology is useful for financial applications such as stock exchanges, banks for fraud detection, retail applications such as ISPs for surveillance of internet traffic, and manufacturing for real-time business intelligence. The StreamInsight Standard edition is available in SQL Server 2008 R2 Standard, or Enterprise, or Web editions, and StreamInsight Premium edition in SQL Server 2008 R2 Datacenter, or Developer, or Evaluation...