Graeme ScottTechnology Solution ProfessionalMicrosoft UKgrscott@microsoft.com

SQL Server 7.0

SQL Server 2005

SQL Server 2000

• Lowest TCO• Automatic Tuning

• Reliability & Security• Integrated Business Intelligence

High availabilityHigh availability SecuritySecurity Developer Developer

productivityproductivity Native XMLNative XML First to include First to include

Enterprise ETL & Enterprise ETL & Deep Data MiningDeep Data Mining

Performance, Performance, scalability focusscalability focus

XML supportXML support First to include First to include

NotificationNotification First to include First to include

Data Mining & Data Mining & ReportingReporting

Re-architecture of Re-architecture of relational serverrelational server

Extensive auto Extensive auto resource resource managementmanagement

First to include First to include OLAP & ETLOLAP & ETL

Cross-release objectives

SQL Server 6.0/6.5

Differentiation Differentiation from Sybase SQL from Sybase SQL ServerServer

Windows Windows integration integration

First to include First to include ReplicationReplication

1st Generation 2nd Generation 3rd Generation

Performance updates: data compressionPerformance updates: data compressionEnhanced BI capabilitiesEnhanced BI capabilities

SSRS Integration with SharePoint SSRS Integration with SharePoint Server 2007Server 2007Data Mining Plug-ins for Office 2007Data Mining Plug-ins for Office 2007

Manageability enhancementsManageability enhancementsOptimized for Windows Vista & Office 2007Optimized for Windows Vista & Office 2007Common Criteria CertificationCommon Criteria Certification

Service Pack 2Service Pack 2Delivery of Database MirroringDelivery of Database MirroringSQL Server Express with Advanced SQL Server Express with Advanced FunctionsFunctions

Management ToolsManagement ToolsFull Text SearchFull Text SearchReporting ServicesReporting Services

Reporting Services support for Netweaver Reporting Services support for Netweaver BIBI

Service Pack 1Service Pack 1

Designed forDesigned forPortable enterprise applications Portable enterprise applications Occasionally-connected & offline use Occasionally-connected & offline use Embedded in applications & devices Embedded in applications & devices

Published on December 15th 2008.Published on December 15th 2008.

Cumulative Updates & performance Cumulative Updates & performance enhancements.enhancements.Some additional support features added Some additional support features added to SQL replication.to SQL replication.

Added data providers for Reporting Added data providers for Reporting Services (support for Teradata Report Services (support for Teradata Report Models).Models).Notification Services integration with Notification Services integration with SQL Server 2008.SQL Server 2008.

Service Pack 3Service Pack 3

GameGameChangersChangers

Transparent Data EncryptionTransparent Data EncryptionExtensible Key ManagementExtensible Key ManagementData AuditingData AuditingPluggable CPUPluggable CPUDatabase Mirroring Database Mirroring EnhancementsEnhancementsPolicy Based managementPolicy Based managementSingle Server AdministrationSingle Server AdministrationStreamlined InstallationStreamlined InstallationEnterprise System ManagementEnterprise System ManagementPerformance Data CollectionPerformance Data CollectionSystem AnalysisSystem AnalysisData CompressionData CompressionQuery Optimization ModesQuery Optimization ModesResource GovernorResource GovernorEntity Data ModelEntity Data ModelLINQLINQVisual Entity DesignerVisual Entity DesignerEntity Aware AdaptersEntity Aware AdaptersSQL Server Change TrackingSQL Server Change Tracking

Synchronized Programming ModelSynchronized Programming Model

Visual Studio SupportVisual Studio Support

SQL Server Conflict DetectionSQL Server Conflict Detection

FILESTREAM data typeFILESTREAM data type

Integrated Full Text SearchIntegrated Full Text Search

Sparse Columns & column setsSparse Columns & column sets

Large User Defined TypesLarge User Defined Types

Date/Time Data TypeDate/Time Data Type

SPATIAL data typeSPATIAL data type

Partitioned Table ParallelismPartitioned Table Parallelism

Warehouse Query OptimizationsWarehouse Query Optimizations

Persistent Lookups Persistent Lookups

Change Data Capture Change Data Capture

Backup CompressionBackup Compression

MERGE SQL StatementMERGE SQL Statement

Data ProfilingData Profiling

Star JoinStar Join

Enterprise Reporting Enterprise Reporting EngineEngine

Internet Report Internet Report DeploymentDeployment

Block ComputationsBlock Computations

Scale out AnalysisScale out Analysis

BI Platform BI Platform ManagementManagement

Export to Word and Export to Word and ExcelExcel

Author reports in Word Author reports in Word and Exceland Excel

Report Builder Report Builder EnhancementsEnhancements

TABLIXTABLIX

Rich Formatted DataRich Formatted Data

Personalized Personalized PerspectivesPerspectives

… … and many moreand many more

Dynamic Dynamic DevelopmentDevelopment

Beyond Beyond RelationalRelational

Pervasive InsightPervasive Insight

Enterprise Data Enterprise Data PlatformPlatform

Mobile andMobile andDesktopDesktop

OLAPFILE

XMLRDBMS

Services

QueryQuery

AnalysisAnalysis

ReportingReporting IntegrationIntegration

SynchSynch

SearchSearch

CloudCloud

Introducing:Introducing:

ServerServer

“Enabling customers of all sizes to derive value from ALL data, birth through archival”

• Accelerate your development with entities

• Synchronize your data from anywhere

• Store and consume any type of data

• Deliver Location Intelligence within your applications

• Integrate all your data in the Enterprise Data Warehouse

• Reach all your users with scalable BI platform

• Empower every user with actionable insights

• Secure, trusted platform for your data

• Optimized and predictable system performance

• Productive policy-based management of your infrastructure

Pervasive InsightPervasive Insight

Enterprise Data Enterprise Data PlatformPlatform

Dynamic Dynamic DevelopmentDevelopment

Beyond Beyond RelationalRelational

EnterpriseEnterpriseData Data PlatformPlatform

Protect your informationEncrypt your data without requiring an application re-write

Consolidate security keys within the data center

Integrated auditing support

Increase the reliability of your applications

Add system resources without affecting your users

Leverage database mirroring to increase reliability

SQL 2008 can support up to 16 cluster nodes on Windows Server 2008

Better PerformanceIncrease query and backup performanceReduce your storage costs

Optimize System Performance

Monitor your system by collecting and storing system eventsAnalyze and report on your system performance

Predictable PerformanceManage concurrent workloads on single systemPrevent runaway queriesEnsure consistent query performance

Enterprise Enterprise Data Data PlatformPlatform

Spend less time on ongoing operations

Manage via policies instead of scriptsDefine Enterprise wide data management policiesAutomated monitoring and enforcement of policiesSimplify your installation and configuration

Integrated with your enterprise system management

Define Policies that are compliant with System Definition ModelManage your data and system infrastructure with Microsoft System Center

EnterpriseEnterpriseData Data PlatformPlatform

• Accelerate your development with entities

• Synchronize your data from anywhere

• Store and consume any type of data

• Deliver Location Intelligence within your applications

• Integrate all your data in the Enterprise Data Warehouse

• Reach all your users with scalable BI platform

• Empower every user with actionable insights

• Secure, trusted platform for your data

• Optimized and predictable system performance

• Productive policy-based management of your infrastructure

Introducing:Introducing:

Develop with business entities

Define your business not tablesModel your complex business relationshipsRetrieve entities instead of rows and columnsConnect to SQL Server with entity aware adapters

Reliable application performance

Store entities locally on your clients

DynamicDynamicDevelopmeDevelopmentnt

Support for occasionally connected systems.ADO.NET Sync Services and the Sync Framework.Use the Sync Framework to synchronise SQL CE with SQL Server.

Support for occasionally connected systems.ADO.NET Sync Services and the Sync Framework.Use the Sync Framework to synchronise SQL CE with SQL Server.

Build data-centric applications with the Entity Framework and the EDM.

Leverage consistent query syntax with LINQ. Access diverse data stores including:

LINQ to Entities.LINQ to DataSets.LINQ to SQL.LINQ to XML.LINQ to SSDS.

// LINQ to SQL query example

Var OrdersQuery = from o in Context.Orderswhere o.Customer.Country == “UK” &&o.Employee.LastName == “Smith”orderby o.Customer.CompanyNameselect new{

o.OrderID,o.OrderDate,o.Customer.CompanyName.o.Order_Details

}Foreach (var o in OrdersQuery)...

// LINQ to SQL query example

Var OrdersQuery = from o in Context.Orderswhere o.Customer.Country == “UK” &&o.Employee.LastName == “Smith”orderby o.Customer.CompanyNameselect new{

o.OrderID,o.OrderDate,o.Customer.CompanyName.o.Order_Details

}Foreach (var o in OrdersQuery)...

// LINQ to SQL query example

Var OrdersQuery = from o in Context.Orderswhere o.Customer.Country == “UK” &&o.Employee.LastName == “Smith”orderby o.Customer.CompanyNameselect new{

o.OrderID,o.OrderDate,o.Customer.CompanyName.o.Order_Details

}Foreach (var o in OrdersQuery)...

// LINQ to SQL query example

Var OrdersQuery = from o in Context.Orderswhere o.Customer.Country == “UK” &&o.Employee.LastName == “Smith”orderby o.Customer.CompanyNameselect new{

o.OrderID,o.OrderDate,o.Customer.CompanyName.o.Order_Details

}Foreach (var o in OrdersQuery)...

// LINQ to SQL query example

Var OrdersQuery = from o in Context.Orderswhere o.Customer.Country == “UK” &&o.Employee.LastName == “Smith”orderby o.Customer.CompanyNameselect new{

o.OrderID,o.OrderDate,o.Customer.CompanyName.o.Order_Details

}Foreach (var o in OrdersQuery)...

// LINQ to SQL query example

Var OrdersQuery = from o in Context.Orderswhere o.Customer.Country == “UK” &&o.Employee.LastName == “Smith”orderby o.Customer.CompanyNameselect new{

o.OrderID,o.OrderDate,o.Customer.CompanyName.o.Order_Details

}Foreach (var o in OrdersQuery)...

Included in Visual Studio 2008 / .NET 3.5Benefits:

Rapid application development scenarios.Query processing performed at the server.Mapping designer makes mapping classes to tables simple.

Limitations:Only supports SQL Server family of databases.Some limitations on mapping scenarios.

DynamicDynamicDevelopmenDevelopmentt

Access your data from Access your data from anywhereanywhere Store your data locally while Store your data locally while

disconnected from serverdisconnected from server Synchronize Incremental Synchronize Incremental

changes between client and changes between client and serverserver

Detect conflicts during Detect conflicts during synchronization including synchronization including deletesdeletes

Add disconnected scenarios Add disconnected scenarios without re-writing existing without re-writing existing applicationsapplications

• Accelerate your development with entities

• Synchronize your data from anywhere

• Store and consume any type of data

• Deliver Location Intelligence within your applications

• Integrate all your data in the Enterprise Data Warehouse

• Reach all your users with scalable BI platform

• Empower every user with actionable insights

• Secure, trusted platform for your data

• Optimized and predictable system performance

• Productive policy-based management of your infrastructure

Introducing:Introducing:

Seamless transition between relational and non-relational

Store your documents in cost effective storage platformAccess documents as dataEncode your complex hierarchies within XMLExtend the database to meet your unique needs

Find your dataQuery across relational and text data

Build global applicationsCapture precise time from clients across the globe

BeyondBeyondRelationalRelational

Storage Attribute on VARBINARY(MAX)Works with integrated FTS

Unstructured data stored directly in the file system (requires NTFS)Dual Programming Model

TSQL (Same as SQL BLOB)Win32 Streaming APIs with T-SQL transactional semantics

Data ConsistencyIntegrated Manageability

Back Up / RestoreAdministration

Size limit is the file system volume sizeSQL Server Security Stack

Store BLOBs in DB + File System

Store BLOBs in DB + File SystemApplicationApplication

BLOBBLOB

DBDB

Build location-aware applications

Capture location data from across your organization Integrate location intelligence to your existing applicationsVisualize your location information

Standard Spatial applications

Integrate with industry standard spatial applicationsSupported by 3rd parties

BeyondBeyondRelationalRelational

• Accelerate your development with entities

• Synchronize your data from anywhere

• Store and consume any type of data

• Deliver Location Intelligence within your applications

• Integrate all your data in the Enterprise Data Warehouse

• Reach all your users with scalable BI platform

• Empower every user with actionable insights

• Secure, trusted platform for your data

• Optimized and predictable system performance

• Productive policy-based management of your infrastructure

Introducing:Introducing:

Scale and Manage large number of users and data

Improve Query performance on large tables Optimize Queries for data warehousing scenarios Increase I/O performance with efficient and cost effective data storageManage concurrent workloads of ad-hoc queries, reporting and analysis

Integrate growing volumes of dataOptimize ETL performance by identifying data in your largest tables Reduce the data load volumes by capturing operational changes in data Simplify the insert and update data processingProfile your information to identify dirty data

PervasivePervasiveInsightInsight

PervasivePervasiveInsightInsight

PervasivePervasiveInsightInsight

What is Tablix? The best of Table merged with the best of Matrix Allows for fixed and dynamic columns and rowsEnables Arbitrary nesting on each axisEnables multiple parallel row/column members at each levelIntroduces optional omission of row/column headers

2001 2002 Total

1,115 1,331 2,446

152 642 794

11,156 13,312 24,468

1,523 6,421 7,944

13,946 21,706 35,653

Retail Acme

Nadir, Inc.

Wholesale ABC Corp.

XYZ, Ltd.

Grand Total

Customer

Retail

Acme

Nadir, Inc.

Wholesale

ABC Corp.

XYZ, Ltd.

Grand Total

Growth

19%

322%

19%

322%

56%

Tabl ixe + Matr

Enriched Visualizations - ChartEnriched Visualizations - Chart

Richer end user experience with new visualization engineChart Examples

Download the evaluation version of SQL Server 2008:http://www.microsoft.com/downloads

SQL Server 2008 Overview:http://www.microsoft.com/sqlserver/2008/en/us/overview.aspx

Get prepared and allow Microsoft to help (available workshops):

SQL Server 2008 Features & Capabilities.Upgrading to SQL Server 2008.SQL Server for the Oracle DBA.

© 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.

The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after

the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.