Angelia LeoAngelia LeoGroup Manager – Server & ToolsGroup Manager – Server & ToolsMicrosoft SingaporeMicrosoft Singapore

CONNECT, EMPOWER, OPTIMIZE CONNECT, EMPOWER, OPTIMIZE The Microsoft Application PlatformThe Microsoft Application Platform

Static-State Static-State ApplicationsApplications

GUI driven GUI driven ApplicationsApplications

Connected Connected ApplicationsApplications

Internet Internet Connected Connected ApplicationsApplications

Services Based Services Based ApplicationsApplications

SpreadsheetsSpreadsheetsWord ProcessorsWord ProcessorsStandalone AppsStandalone Apps

Enhanced GUIEnhanced GUIIntegrated Integrated toolsetstoolsetsLOB apps LOB apps connected within connected within companycompany

MonolithicMonolithicEarly - Mid 80sEarly - Mid 80s

Internet EnabledInternet EnabledMid 90sMid 90s

Client ServerClient ServerLate 80s-Mid 90sLate 80s-Mid 90s

Composite/Composite/Services BasedServices Based

Mid 00s - . . .Mid 00s - . . .

Mainframe AppsMainframe AppsDumb TerminalsDumb Terminals

Rich UIRich UIConnected to Connected to suppliers & suppliers & customerscustomersInternet enabledInternet enabled

Loosely coupled Loosely coupled Web Services Web Services architecturearchitectureSOAP/XML/ESB SOAP/XML/ESB Devices, form Devices, form factorsfactors

““Application server platforms are the foundation for emerging Application server platforms are the foundation for emerging composite applications”composite applications”

“Application platform suite (APS) products are integrated assemblies of three fundamental runtime technologies”

““A A SuperplatformSuperplatform is a tightly integrated suite of products that is a tightly integrated suite of products that provide organizations with a comprehensive platform for provide organizations with a comprehensive platform for enterprise computing”enterprise computing”

““The platform a customer uses to design, develop, deploy and The platform a customer uses to design, develop, deploy and manage applications to run their business."manage applications to run their business."

More easily connectHeterogeneous systems

Create adaptablesolutions built for

change

Cohesive technologiesthat span the IT Lifecycle

Increase productivityfor individuals, teams

& organizations

Improve resourceallocation, prioritization

& risk management

Speed time-to-marketwith higher predictability

Thousands of ISVsolutions & partners

supporting the platform

Enterprise scalabilityand industry-leading

TCO

Widely adopted tools& technologies

Higher Availability & Scalability Higher Availability & Scalability Stronger SecurityStronger Security Ease of Manageability Ease of Manageability

Trusted PlatformTrusted Platform Lower Costs Lower Costs

& Risk& Risk

DeliverDeliver

Results Results

FasterFasterBetter Better

DecisionsDecisions

Faster Application DevelopmentFaster Application Development Simplified Application lifecycle Simplified Application lifecycle

managementmanagement Enhanced InteroperabilityEnhanced Interoperability

DeliverDeliver New New

Tools FasterTools Faster

FasterFaster

ResultsResults

Better Insight & Deeper AnalyticsBetter Insight & Deeper Analytics Richer End User Analysis & Richer End User Analysis &

ReportingReporting Stronger MS Office integrationStronger MS Office integration

Simplifies Data Management & AnalysisSimplifies Data Management & Analysis

Optimize Your Application Optimize Your Application PlatformPlatform

Near Zero Near Zero DowntimeDowntime

Deep Business Deep Business

InsightInsight

Faster Time to Faster Time to ValueValue

Breakthrough Features in Breakthrough Features in SQL Server 2005SQL Server 2005

Major Enhancements Major Enhancements in SQL Server 2005in SQL Server 2005

New Features in SQL New Features in SQL Server 2005Server 2005

Best of Breed Best of Breed Business Business IntelligenceIntelligence

Enterprise ETLEnterprise ETL Unified Dimension Unified Dimension

Model (UDM)Model (UDM) Data MiningData Mining

Ad Hoc ReportingAd Hoc Reporting BI Dev StudioBI Dev Studio

Enterprise Enterprise Data Data ManagementManagement

SecuritySecurity RecoverabilityRecoverability StorageStorage Manageability Manageability

Database MirroringDatabase Mirroring Snapshot IsolationSnapshot Isolation Native Data EncryptionNative Data Encryption Dynamic Management Dynamic Management

Views (DMVs)Views (DMVs) Table PartitioningTable Partitioning

Unmatched Unmatched Developer Developer ProductivityProductivity

TSQLTSQL ADO.NETADO.NET Full Text SearchFull Text Search

Native XML/SQL CLRNative XML/SQL CLR Query NotificationQuery Notification Integrated Integrated

Development Development EnvironmentEnvironment

Mission Critical Data PlatformMission Critical Data PlatformOptimizing IT for GrowthOptimizing IT for Growth

Upgrading to Upgrading to SS2005SS2005

NeedsNeedsChallengesChallenges

Always On, Always Always On, Always AvailableAvailable

I Cannot Access I Cannot Access Data When I Need ItData When I Need It

Right Time Right Time InformationInformation

Reduced Risk Reduced Risk My Data and IP Can My Data and IP Can be Lost or Stolenbe Lost or Stolen

Faster and More Faster and More Flexible AppsFlexible Apps

My Apps are Hard to My Apps are Hard to Develop and RunDevelop and Run

Unmatched Unmatched ProgrammabilityProgrammability

Faster, Better Faster, Better Decisions SupportDecisions Support

I Cannot Turn Data I Cannot Turn Data into Actionable Insight into Actionable Insight When I Need ItWhen I Need It

Deliver Better Deliver Better Results FasterResults Faster

Secure By Secure By DefaultDefault

Deliver Results Faster with Mission Deliver Results Faster with Mission Critical AbilitiesCritical Abilities

Higher Availability & SecurityHigher Availability & Security35% faster transaction processing35% faster transaction processing

5x faster failover enabling 5x faster failover enabling 99.999% availability99.999% availability

Native data encryptionNative data encryption

Greater Visibility & Deeper AnalysisGreater Visibility & Deeper AnalysisUp to 2x performance increase Up to 2x performance increase with large OLAP dimensionswith large OLAP dimensions

Rich End User Analysis & Rich End User Analysis & ReportingReporting

Enhanced Developer ProductivityEnhanced Developer ProductivityUp to 40% faster development Up to 40% faster development time with VS and .NET integrationtime with VS and .NET integration

New Cachesync simplifies web New Cachesync simplifies web developmentdevelopment

Unmatched Performance and Low TCOUnmatched Performance and Low TCO

“…already seeing 70 percent faster responses with XML data types, and has found it up to 90 percent faster to create XML-based applications.”

“Integrated Microsoft technology helps accelerate our solutions so we can provide more immediate, innovative service to our clients.”

“Moving to Integration Services for our enterprise ETL needs was the right decision—we were able to immediately capitalize on the team development features and rapid learning curve…”

SQL 7.0SQL 7.0 SQL 2000SQL 2000 SQL 2005SQL 2005

Enterprise Enterprise Data Data ManagemeManagementnt

32-bit, 2 GB max32-bit, 2 GB maxDistributed Distributed

QueriesQueriesDynamic locking Dynamic locking Full-Text SearchFull-Text Search

64-bit, 64GB max 64-bit, 64GB max Multiple instanceMultiple instanceDifferential Differential

BackupsBackupsParallel Operation Parallel Operation

Creating IndexesCreating IndexesIndexed ViewsIndexed Views

64-bit Std./Ent., Unlimited CPU supportPartitioning; Snapshot IsolationOnline OperationsDatabase SnapshotsIndexed ViewsOracle ReplicationDatabase Mirroring

Business Business IntelligenceIntelligence

OLAP integrationOLAP integrationOLEDB interface OLEDB interface in DTSin DTSDTS jobs in SQL DTS jobs in SQL AgentAgent

Real Time OLAPReal Time OLAPPartitioned CubesPartitioned CubesDTS Custom DTS Custom TasksTasksData MiningData MiningReporting Reporting ServicesServicesNotification Notification ServicesServices

Integration ServicesIntegration ServicesUnified Dimensional Model (UDM)Unified Dimensional Model (UDM)Report Builder / OLAP ReportsReport Builder / OLAP ReportsXMLA command languageXMLA command languageProactive CachingProactive CachingKPI FrameworkKPI Framework7 new Data Mining Algorithms7 new Data Mining Algorithms

Developer Developer ProductivitProductivityy

ODBC, ADO, ODBC, ADO, OLEDB OLEDB Extended Stored Extended Stored

ProceduresProceduresDMO, SQL-NSDMO, SQL-NS

XML Integration XML Integration of Relational Dataof Relational DataBIGINT, BIGINT,

SQL_VARIANT and SQL_VARIANT and TABLE data typesTABLE data typesT-SQL User -T-SQL User -

defined Functionsdefined Functions

SQL-CLR & .NET IntegrationSQL-CLR & .NET IntegrationNative Data EncryptionNative Data EncryptionXML Data Type & XQueryXML Data Type & XQueryService BrokerService BrokerUser-defined Types and User-defined Types and AggregatesAggregatesSMO, AMO, RMO, NMOSMO, AMO, RMO, NMOSQL Client .NET Data ProviderSQL Client .NET Data ProviderVS Shell Integration VS Shell Integration

SQL Server Feature Comparison – SQL Server Feature Comparison – By Key Focus AreasBy Key Focus Areas

Improving organizations Improving organizations by providing business by providing business insights to insights to allall employees employees leading to better, faster, leading to better, faster, more relevant decisionsmore relevant decisions

Advanced AnalyticsAdvanced Analytics

Self Service ReportingSelf Service Reporting

End-User AnalysisEnd-User Analysis

Business Performance Business Performance ManagementManagement

Operational Applications Operational Applications Embedded AnalyticsEmbedded Analytics

PortalPortal(Office Server)(Office Server)

OfficeOffice

SQLSQL

Data WarehouseData Warehouse(SQL RDBMS)(SQL RDBMS)

IntegrateIntegrate(SSIS)(SSIS)

AnalyzeAnalyze(SSAS)(SSAS)

ReportReport(SSRS)(SSRS)

Business ScorecardingBusiness Scorecarding(BSM)(BSM)

End-user AnalysisEnd-user Analysis(Excel)(Excel)

BIBIPlatformPlatform

AnalyticAnalyticApplicationsApplications

End-userEnd-userToolsTools

BIBIPlatformPlatform

Data WarehouseData Warehouse(SQL RDBMS)(SQL RDBMS)

IntegrateIntegrate(SSIS)(SSIS)

AnalyzeAnalyze(SSAS)(SSAS)

ReportReport(SSRS)(SSRS)

PortalPortal(Office Server)(Office Server)

Business ScorecardingBusiness Scorecarding(BSM)(BSM)

End-user AnalysisEnd-user Analysis(Excel)(Excel)

AnalyticAnalyticApplicationsApplications

End-userEnd-userToolsTools

Integrate (ETL)Integrate (ETL)Analyze (OLAP Analyze (OLAP and Data Mining)and Data Mining)Report (Reports Report (Reports and and Notifications)Notifications)

Analyze (Excel)Analyze (Excel)Collaborate (BI Collaborate (BI Portal)Portal)Manage (KPIs, Manage (KPIs, Scorecard)Scorecard)

Selected SQL 2005 Upgrade Customers Selected SQL 2005 Upgrade Customers

Re-architected business critical Sports Database application using .NET and VS 2005, deployed SS2005 IS and RS

2.5 TB retail BI/DW, end-to-end BI: OLAP, RS, IS running on SQL Server 2005

Market Data Dissemination System with 5000 Tx/sec and over 100K queries / day

200GB DB for German paper manufacturer, upgrading 10 servers to SS2005, 400 total users 260+ concurrent

SQL Server 2005 BI platform for financial: AS, UDM, RS, IS and DM in ETL. SharePoint Portal Server to host

SQL Server 2005 TB+ CustomersSQL Server 2005 TB+ CustomersData WarehousingData Warehousing

5.3 TB Credit Card DW, 5 Mil card holders5.3 TB Credit Card DW, 5 Mil card holders 300 power users, complex query, OLAP, SSIS, SSRS, 300 power users, complex query, OLAP, SSIS, SSRS,

Office BSMOffice BSM

4 TB Consumer Packaged Goods (CPG) DW4 TB Consumer Packaged Goods (CPG) DW 350 users, complex relational query, SSIS & SSRS350 users, complex relational query, SSIS & SSRS

4.5 TB Retail Data Warehouse on HP Superdome4.5 TB Retail Data Warehouse on HP Superdome Uses SQL Server OLAP, SSIS, SSRSUses SQL Server OLAP, SSIS, SSRS

2 TB DW, originally migrated from Informix2 TB DW, originally migrated from Informix 300 users, complex query, OLAP & Data Mining300 users, complex query, OLAP & Data Mining

2 TB of Clinical Data & growing, 50 TB storage2 TB of Clinical Data & growing, 50 TB storage US Dept of Veterans Affairs, 1200+ facilities, 40+ US Dept of Veterans Affairs, 1200+ facilities, 40+

OLAP MartsOLAP Marts

SQL Server 2005 Customers In SQL Server 2005 Customers In SingaporeSingapore

SQL Server 2005 Customers In SQL Server 2005 Customers In SingaporeSingapore

And Many More Singapore Customers from:• Government, Telecom, Manufacturing, Logistics, Retail and Financial Verticals

7744

1313

2121

3737

2020

Database Security VulnerabilitiesDatabase Security Vulnerabilities

Source: Company web sites, http://www.osvdb.org, http://www.secunia.com (Includes both SQL Server and MDAC)

20022002 20032003 20042004 20052005

SQL SQL ServerServer

Oracle DBOracle DB

1111

22 11

Oracle: Unbreakable?Oracle: Unbreakable?

20062006

SQL Server Express provides simple free DBSQL Server Express provides simple free DB SQL Server WG provides robust database for SQL Server WG provides robust database for

growing businesses and smaller departmentsgrowing businesses and smaller departments

Deliver Lowest Cost & Deliver Lowest Cost & Easiest to Use Easiest to Use DatabaseDatabase

Enable customer to take full advantage of multi-Enable customer to take full advantage of multi-corecore

Fully support 64-bit in SQL Fully support 64-bit in SQL ServerServer STD & EE STD & EE Includes Advanced HA Solution Includes Advanced HA Solution Includes new DB Partitioning FeatureIncludes new DB Partitioning Feature

Make Enterprise Make Enterprise Functionality & Scale Functionality & Scale MainstreamMainstream

Includes new Report Builder ApplicationIncludes new Report Builder Application Includes new SQL Server Integration ServicesIncludes new SQL Server Integration Services Reporting, OLAP, & Data Mining Services Reporting, OLAP, & Data Mining Services

provided at no extra costprovided at no extra cost

Provide Advanced BI at Provide Advanced BI at commodity pricescommodity prices

Free license for passive servers including Free license for passive servers including backup servers and disaster recovery serversbackup servers and disaster recovery servers

Low cost options for ISVs to embed SQL Low cost options for ISVs to embed SQL Server technology in applicationsServer technology in applications

Provide Fair & Flexible Provide Fair & Flexible Licensing OptionsLicensing Options

Delivering Value & Flexibility With Delivering Value & Flexibility With SQL Server 2005SQL Server 2005

Introducing SQL Server 2005 Introducing SQL Server 2005 Packaging & PricingPackaging & Pricing New for SQL Server 2005New for SQL Server 2005

Note: All Higher Editions include same Note: All Higher Editions include same functionality as the edition below it.functionality as the edition below it.Does not include Developer Edition and Does not include Developer Edition and SQL Server Mobile EditionSQL Server Mobile Edition

ExpressExpress WorkgroupWorkgroup StandardStandard EnterpriseEnterpriseFastest way for Fastest way for developers to learn, build developers to learn, build & deploy simple data & deploy simple data driven applicationsdriven applications

Easiest to use & most Easiest to use & most affordable database affordable database solution for smaller solution for smaller departments & growing departments & growing businessesbusinesses

Complete data Complete data management & analysis management & analysis platform for medium platform for medium businesses and large businesses and large departmentsdepartments

Fully integrated data Fully integrated data management and management and analysis platform for analysis platform for business critical business critical enterprise applications enterprise applications

FreeFree$3.9K $3.9K per procper proc or or$739 $739 (Server + 5 users)(Server + 5 users)*CAL for Workgroup does not work with *CAL for Workgroup does not work with other editionsother editions

$6K $6K per procper proc or or $2,799 $2,799 (Server + 10 users)(Server + 10 users)

$25K $25K per procper proc or or $13.5K $13.5K (Server + 25 users)(Server + 25 users)

2 CPU2 CPU

3 GB RAM3 GB RAM

Management Management StudioStudio

Import/ExportImport/Export

Limited Replication Limited Replication PublishingPublishing

Back-up Log-Back-up Log-shippingshipping

ReportingReportingServer & ReportServer & ReportBuilderBuilder

4 CPU4 CPU

Unlimited RAMUnlimited RAM(64-bit)(64-bit)

Database MirroringDatabase Mirroring

OLAP ServerOLAP Server

Reporting ServerReporting Server

New Integration New Integration ServicesServices

Data MiningData Mining

Full Replication & Full Replication & SSB PublishingSSB Publishing

Unlimited Scale Unlimited Scale + Partitioning+ Partitioning

Adv. DB mirroring, Adv. DB mirroring, Complete online & Complete online & parallel operations, parallel operations,

DB snapshotDB snapshot

Advanced Analysis Advanced Analysis Tools including full Tools including full OLAP & Data OLAP & Data MiningMining

Customized & High Customized & High Scale ReportingScale Reporting

Adv SSISAdv SSIS

1 CPU1 CPU1 GB RAM1 GB RAM4GB DB Size4GB DB Size

Simple Simple Management ToolManagement Tool

ReportingReportingServerServer

Native EncryptionNative Encryption

Replication & Replication & SSB ClientSSB Client

24