1 / 13

Why Upgrade to SQL Server 2008 R2?

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.

khuong
Télécharger la présentation

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Why Upgrade to SQL Server 2008 R2? Name Title Group/Company

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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.

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

  8. 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.

  9. 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:

  10. 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.

  11. 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

  12. Q&A

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

More Related