if you have sql server 2005, you get all the features below plus the following: if you have sql...

Why Upgrade to SQL Server 2008 R2?

NameTitle

Group/Company

• Overview

Agenda

• Reasons to Upgrade from Microsoft® SQL Server® 2008• Reasons to Upgrade from Microsoft® SQL Server® 2005

• Reasons to Upgrade from Microsoft® SQL Server® 2000

• Summary

Enterprise security and scalability

Data consistency across heterogeneous systems

High-scale, complex event processing

TRUSTED, SCALABLE PLATFORM

IT and DEVELOPER EFFICIENCY

MANAGED SELF-SERVICE BI

Multi-server management

Virtualization and Live Migration

Accelerated development

and deployment

Self-service analytics

Self-service reporting

Streamlined collaboration

and management

Customers Building Value with SQL Server 2008 R2

“By using PowerPivot for Excel and SQL Server 2008 R2, it took us about one hour to produce a good report that in the past would have required multiple meetings and a day or more in staff

time.”

Bob Erikson, executive vice president of software development, Mediterranean

Shipping Company

“Our analysts can do anything with Excel, so integrating Excel as a front end

for our BI infrastructure is extremely popular. It makes it easier to explore the huge wealth of data we have in our 17-

terabyte data warehouse.”

Dan Zerfas, vice president of software development, Premier Bankcard

“Our mission-critical applications need to be running all hours of the day, every day. We were

already pleased with the availability and performance that we had using SQL Server 2005…but SQL Server 2008 R2 will help us

improve that even more …”,

Stephen Walker, enterprise database architect, Chevron Data Management Solutions

Why Upgrade from SQL Server 2008?

If you have SQL Server 2008, you get these new features:

If you have SQL Server 2005, you get all the features below plus the following:


• New editions: Microsoft SQL Server 2008 R2 Datacenter and Microsoft SQL Server 2008 R2 Parallel Warehouse

• New Master Data Hub• Complex event processing• Database engine enhancements • Self-service business intelligence (BI) enhancements on

interactive reports collaboration, and massive data analysis in Microsoft® Excel®

• Enhanced Reporting Services performance and scalability allowing you to run and deliver richly formatted reports to users through a variety of mechanisms

• SQL Server Analysis Services (SSAS) enhancement on productivity, performance, and extensibility

• SQL Server Reporting Services (SSRS) enhancement on self-service reporting with IT control, report design, and programmability

• SQL Server Integration Services (SSIS) enhancement on performance, scalability, and productivity

The Details: Top Benefits and Features

Upgrading from SQL Server 2008 to Microsoft® SQL Server® 2008 R2 gives you all of these benefits.

Enhanced database engines to increase hardware scale, storage compression, and high availability through virtualization

StreamInsight allows you tomonitor, analyze, and acton the high volume of datain motion from variety ofsources

Self-service analytics toanalyze massive amount ofdata using Excel

Self-service reporting toenhance report generationand collaboration

Master Data Services forcentral management ofcritical assets across diversesystem to ensure theintegrity of information

Enhanced developer tools tostandardize styles and templates creating a feature-rich and robust data application lifecycle

Data-tier application project template

Transact-SQL code snippets to insert commonly used syntax into an application

For the IT Pro For the BI Practitioner For the Developer

Multi-server management to improve virtual server and database application management and to identifypotential consolidationopportunity





• New editions: Datacenter and Parallel Warehouse• New Master Data Hub• Complex event processing• Database engine enhancements • Self-service BI enhancements on interactive reports

collaboration, massive data analysis in Excel

• Analysis Services (SSAS) enhancement on productivity, performance, and extensibility

• Reporting Services (SSRS) enhancement on self-service reporting with IT control, report design, and programmability

• Integration Services (SSIS) enhancement on performance, scalability, and productivity


Upgrading from SQL Server 2005 to SQL Server 2008 R2 gives you all of these benefits in addition to those listed for SQL Server 2008.

Enhanced manageability lets database administrators (DBAs) efficiently manage multiple database instances, automate execution of daily administrative tasks, and monitor server performanceEnhanced security lets DBAs adhere to stronger compliance regulations by encrypting an entire database and improve audit capabilities

Create productive, comprehensive, richly formatted reports using Microsoft® Visual Studio®–based tools from a variety of data sources

Visual Studio–based report development tools

Build reports from different data sources throughout your enterprise such as SQL Server, Oracle, DB2, SAP NetWeaver BI, and Hyperion Essbase

Enhanced storage for special data types such as FILESTREAM, hierarchical, and spatial data

Improved productivity of database development through new full-text architecture, Transact-SQL enhancements, and improved tools

Use one query syntax to access wide range of data stores

For the IT Pro For the BI Practitioner For the DeveloperEnhanced database engines work more efficiently with hardware, queries, large tables, and server resources; maximizing availability, and increasing storage capacity through compression



If you have SQL Server 2005, you will get these as well:

If you have SQL Server 2000, you’ll get all the below plus the following:

• New editions: Datacenter and Parallel Warehouse• New Master Data Hub• Complex event processing• Database engine enhancements • Self-service BI enhancements on interactive reports

collaboration, massive data analysis in Excel

• Analysis Services (SSAS) enhancement on productivity, performance, and extensibility

• Reporting Services (SSRS) enhancement on self-service reporting with IT control, report design, and programmability

• Integration Services (SSIS) enhancement on performance, scalability, and productivity


Upgrading from SQL Server 2000 to SQL Server 2008 R2 gives you all of these benefits in addition to those listed for SQL Server 2008 and SQL Server 2005.

Better control over access and manipulation of data with new management UI

Enhanced search performance for full-text data and other data types

Enhanced SSRS for end- user reporting (while preserving IT control), more flexible and productive reports

Enhanced SSAS for quicker online analytical processing (OLAP) cube creation and performance

Enhanced SSIS to increase scalability and productivity of extract, transform, and load (ETL) applications

Enhanced database engine programmability to increase performance, flexibility, and extensibility of database applications

Enhanced SSRS to increase the report connectivity and manageability

Enhanced SSAS to increase flexibility and extensibility of OLAP applications

For the IT Pro For the BI Practitioner For the Developer

Enhanced database engines to increase local and remote availability, performance through better concurrency, and email scaling

Upgrading from SQL Server 2008, SQL Server 2005, and SQL Server 2000Your Data, Any Place, Any Time

• Upgrading to Microsoft® SQL Server® 2008 R2 provides you with new features and capabilities that can help your organization:− Scale with confidence on a trusted platform− Improve IT and developer efficiency− Make self-service business intelligence (BI) possible

www.microsoft.com/sqlserver

http://www.microsoft.com/sqlserver

if you have sql server 2005, you get all the features below plus the following: if you have sql...

Documents

microsoft sql server

application slide

sql code snippets

text data

data types

microsoft corporation

enhanced search performance

used syntax