Database Reference
In-Depth Information
1
Getting Started with
SQL Server 2008 R2
In this chapter, we will cover:
F
Adding SQL Server R2 Service Pack features using Slipstream Technology
F
Designing a best practice approach in upgrading to SQL Server 2008 R2
F
Working with Data-Tier applications
F
Designing and adopting SQL Server 2008 R2 solutions
F
Designing applications to use federated servers
Introduction
Microsoft SQL Server 2008 has opened up a new dimension within data platforms and
SQL Server 2008 R2 has been developed on the areas of core Database Platform and rich
Business Intelligence. On the core database environment, SQL Server 2008 R2 advances the
new enhancements as a primary goal of scalability and availability for highly transactional
applications on enterprise-wide networks. On Business Intelligence platforms, the new
features that are elevated include Master Data Management (MDM), StreamInsight,
PowerPivot for Excel 2010, and Report Builder 3.0. The SQL Server 2008 R2 Installation
Center includes system configuration checker rules to ensure the deployment and installation
completes successfully. Further, the SQL Server setup support files will help to reduce the
software footprint for installation of multiple SQL instances.
