Gain a complete data management and business intelligence platform by using Microsoft SQL Server 2008 R2 Standard for predictable performance, reliability, and security, even for organizations with limited IT resources.
Single management console
Use SQL Server Management Studio to manage all SQL Server instances and services including relational databases, SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services, and SQL Server Compact databases.
Ensure compliance with system configuration policies and simplify administration tasks by using policy-based management.
Performance data collection
It features streamline performance-tuning and troubleshooting with a centralized data repository of performance data.
Business continuity improvement
Facilitate server upgrades with stable and more predictable query performance. Take advantage of synchronous database mirroring with automatic page repair and improved performance. Enjoy seamless failover, with support for two-node failover clusters. Use log shipping to provide redundancy with two or more SQL Server instances.
Backup time and effort reduction
Reduce data storage requirements and time spent performing backups by using backup compression.
Allow people to perform interactive modeling and analysis of massive amount of data by streamlining the integration of data from multiple sources, all within a familiar tool, Microsoft Excel 2010.
Delivery of relevant information
Streamline the development of SQL Server Analysis Services solutions with easy-to-use cube design tools. Integrate with Bing Maps for Enterprise to deliver comprehensive geospatial reports. Improve the quality of data with the SQL Server Integration Services data-profiling tool.
Enhanced support for driving actionable insights
Broaden the reach of SQL Server Reporting Services with Microsoft Word rendering and enhanced Excel rendering. Reach customers and suppliers with reports created with streamlined Internet deployment in Reporting Services.
Complex event processing with StreamInsight
Use standard StreamInsight support to build complex event-processing applications that can handle high-volume data streams with low latency.
Transact-SQL data model
Perform multiple operations efficiently by using the MERGE command. Benefit from full compatibility with Windows Server collation support.
Spatial data types
Build spatial capabilities into applications, with support for spatial data. Program against spatial data by using the built-in spatial library!
Integrated full-text search
Perform high-speed text searches on large text columns. Manage fewer files by taking advantage of integrated full-text search indexes.
Sparse columnsProduct Highlights
Set to any data type to prevent NULL data from consuming physical space in the database. Manage large sets of NULL data in a database more efficiently.
- Ensuring predictable performance on a secure, reliable, scalable platform with built-in tools
- Reducing storage requirements and time spent performing backups by using backup compression support
- Driving timely and informed business decisions by using built-in reporting and analytics
- Simplifying development and boosting productivity with existing skills and tools
- Building complex event-processing programs that can handle high-volume data streams with low latency