Microsoft SQL Server
Centralized management and deployment of instances and applications from a single control point within SQL Server Management Studio.
Support for Windows Server 2008 R2, including Hyper-V™ with Live Migration Data warehouse scalability from tens to hundreds of terabytes through massively parallel processing Enhanced data compression with support for Unicode UCS-2 managing master data across heterogeneous systems.
High-scale complex event processing
TRUSTED, SCALABLE PLATFORM
Scale your data warehouse from tens to hundreds of terabytes SQL Server 2008 R2 will offer customers scalability to meet the demands of growing data warehouses.
Microsoft SQL Server 2008 R2 Overview
Microsoft SQL Server 2008 R2 is a complete set of enterprise-ready technologies and tools that help people derive the most value from information at the lowest total-cost-of-ownership. Enjoy high levels of performance, availability, and security; employ more productive management and development tools; and deliver pervasive insight with self-service business intelligence (BI).
Highlights:
· Complete information platform for applications of all sizes.
· Managed, familiar self-service BI tools.
· Support for large-scale data centers and data warehouses.
· Opportunities to build and extend applications in the cloud.
· Integration with the Microsoft Application Platform.
Derive more value from information
Microsoft SQL Server 2008 R2 introduces a range of new capabilities to help businesses of all sizes derive more value from information. Built on improvements in previous versions, SQL Server 2008 R2 adds even greater capabilities in development, manageability, BI, and data warehousing.
Take advantage of two new editions for large-scale data centers and data warehouses: Microsoft SQL Server 2008 R2 Datacenter and SQL Server 2008 R2 Parallel Data Warehouse. These premium editions feature enterprise-scale enhancements, like greater support for the most demanding workloads and more efficient management of applications and servers in the data center.
Address business challenges with enhancements to core editions: SQL Server 2008 R2 Standard and SQL Server 2008 R2 Enterprise. New improvements include support for high-scale complex event processing and managed self-service BI through PowerPivot for Excel and PowerPivot for SharePoint.
With upcoming release of the latest version of Microsoft SQL Server, SQL Server 2008 R2, Microsoft continues to build on the Information Platform Vision by enabling businesses to deliver near real-time information through rich applications. Not only does SQL Server offers a complete approach to managing, accessing and delivering information across the organization; but now the power of SQL Server is extending to the Cloud through SQL Azure. SQL Azure provides a consistent program model and common tools while offering new business opportunities, high availability, and massive scale through distributed data services.
People are at the center of the Information Platform – IT and Database professionals who support the expanding needs of the business, Developers who build solutions quickly to capture business opportunities and End users who are looking to quickly mine volumes of data for business insights. SQL Server 2008 R2 delivers something unique and empowering to each of these contributors.
The combination of SQL Server, SQL Azure, and Microsoft’s worldwide partner ecosystem offers:
Trusted, Scalable Platform
Line-of-business applications (LOB) are the critical link between the IT department and the business. The ability to securely and reliably store, centralize, manage and distribute data out to users is key to these LOB applications. SQL Server 2008 provides businesses with a high performance database platform that’s reliable, scalable, and easy to manage. SQL Server 2008 R2 builds on the 2008 release and helps IT departments provide even more cost-effective scalability on today’s most advanced hardware platforms using familiar SQL Server administration tools.
IT & Developer Efficiency
There has never been greater demand for IT to provide more value with existing budgets and resources. To achieve this, they need tools and capabilities that help them maximize efficiency across the application lifecycle with streamlined management, rapid development, and predictable deployment. SQL Server 2008 R2 builds on a long history of enabling DBA and developer productivity with new tools and capabilities to help IT administrators and developers make the best possible use of time and resources.
Microsoft SQL Server 2008 R2 provides new tools for managing large multi-database environments along with improved capabilities to help maximize the value of consolidation efforts, and ensure the streamlined development and deployment of data-driven applications.
| 
