Why upgrade to sql server 2008 r2 l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 13

Why Upgrade to SQL Server 2008 R2? PowerPoint PPT Presentation


  • 165 Views
  • Uploaded on
  • Presentation posted in: General

Why Upgrade to SQL Server 2008 R2?. Name Title Group/Company. Agenda. Overview. 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.

Download Presentation

Why Upgrade to SQL Server 2008 R2?

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Why upgrade to sql server 2008 r2 l.jpg

Why Upgrade to SQL Server 2008 R2?

Name

Title

Group/Company


Agenda l.jpg

Agenda

  • Overview

  • 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


Slide3 l.jpg

TRUSTED, SCALABLE PLATFORM

IT and DEVELOPER EFFICIENCY

MANAGED SELF-SERVICE BI

Enterprise security and scalability

Data consistency across heterogeneous systems

High-scale, complex event processing

Multi-server management

Virtualization and Live Migration

Accelerated developmentand deployment

Self-service analytics

Self-service reporting

Streamlined collaborationand management


Customers building v alue with sql server 2008 r2 l.jpg

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 l.jpg

Why Upgrade from SQL Server 2008?

  • 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®

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

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

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

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

  • 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


Slide6 l.jpg

The Details: Top Benefits and Features

For the Developer

For the BI Practitioner

For the IT Pro

Self-service analytics to

analyze massive amount of

data using Excel

Enhanced developer tools to

standardize styles and templates creating a feature-rich and robust data application lifecycle

Multi-server management to improve virtual server and database application management and to identify

potential consolidation

opportunity

Self-service reporting to

enhance report generation

and collaboration

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

Data-tier application project template

Master Data Services for

central management of

critical assets across diverse

system to ensure the

integrity of information

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

StreamInsight allows you to

monitor, analyze, and act

on the high volume of data

in motion from variety of

sources

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


Why upgrade from sql server 2005 l.jpg

Why Upgrade from SQL Server 2005?

  • 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

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

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

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

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

  • 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


Slide8 l.jpg

The Details: Top Benefits and Features

For the Developer

For the BI Practitioner

For the IT Pro

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

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

  • Enhanced database engines work more efficiently with hardware, queries, large tables, and server resources; maximizing availability, and increasing storage capacity through compression

Visual Studio–based report development tools

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

  • Enhanced manageability lets database administrators (DBAs) efficiently manage multiple database instances, automate execution of daily administrative tasks, and monitor server performance

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

Enhanced security lets DBAs adhere to stronger compliance regulations by encrypting an entire database and improve audit capabilities

Use one query syntax to access wide range of data stores

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.


Why upgrade from sql server 2000 l.jpg

Why Upgrade from SQL Server 2000?

  • 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

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

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

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

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


Slide10 l.jpg

The Details: Top Benefits and Features

For the Developer

For the BI Practitioner

For the IT Pro

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

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

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

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

Enhanced SSRS to increase the report connectivity and manageability

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

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

  • Enhanced SSAS to increase flexibility and extensibility of OLAP applications

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

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.


Upgrading from sql server 2008 sql server 2005 and sql server 2000 your data any place any time l.jpg

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


Slide12 l.jpg

Q&A


Slide13 l.jpg

© 2010 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, expressed or implied, in this summary.


  • Login