Data mining helps you make intelligent decisions about difficult business problems. Using the data mining tools in Analysis Services helps you identify patterns in your data, so that you can determine why things happen, and enables you to create rules and recommendations, so that you can predict what will happen in the future.
The Database Engine is the core service for storing, processing, and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise.
Use the data warehousing capabilities of Microsoft SQL Server 2008 Enterprise to build faster warehouses, manage growing data volumes, integrate with Microsoft business intelligence products, and with the recent acquisition of DATAllegro, scale a warehouse to perform across hundreds of terabytes of data.
SQL Server Integration Services provides a scalable enterprise data integration platform with exceptional Extract, Transform, Load (ETL) and integration capabilities, enabling organizations to more easily manage data from a wide array of data sources.
Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
SQL Server Reporting Services (SSRS) provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality.
SQL Server Service Broker provides the SQL Server Database Engine native support for messaging and queuing applications. This makes it easier for developers to create sophisticated applications that use the Database Engine components to communicate between disparate databases. Developers can use Service Broker to easily build distributed and reliable applications.
SQL Azure Database is a cloud database service from Microsoft. SQL Azure provides web-facing database functionality as a utility service. Cloud-based database solutions such as SQL Azure can provide many benefits, including rapid provisioning, cost-effective scalability, high availability, and reduced management overhead.
SQL Server Modeling Services provides a robust, enterprise-hardened role for models. It takes advantage of the best features of SQL Server 2008 to deliver on critical areas such as scalability, security, and performance.
Microsoft StreamInsight is a powerful platform for developing and deploying complex event processing (CEP) applications. Its high-throughput stream processing architecture and familiar .NET-based development platform enable developers to quickly implement robust and highly efficient event processing applications.