Transcript Microsoft Data Platform

Name
Title
Group
SQL Server 2005 Momentum
Data Platform Vision
Delivering on Vision
Enterprise Data Platform
Dynamic Development
Beyond Relational
Pervasive Insight
Predictable Customer Value
Enterprise Ready!
“Microsoft’s ambition
has been to grow SQL
Server into the
upper echelons of
major enterprises, and
with SQL Server 2005,
this seems to
be happening.”
Ongoing Enhancements
Service Pack 1
Service Pack 2
Delivery of Database Mirroring
SQL Server Express with Advanced Functions
Management Tools
Full Text Search
Reporting Services
Reporting Services support for Netweaver BI
Performance updates: data compression
Enhanced BI capabilities
SSRS Integration with SharePoint Server
2007
Data Mining Plug-ins for Office 2007
Manageability enhancements
Optimized for Windows Vista & Office 2007
Common Criteria Certification
Designed for
Portable enterprise applications
Occasionally-connected & offline use
Embedded in applications & devices
Game
Changers
Enterprise Data Platform
Services
Reporting
Integration
Analysis
Beyond Relational
Query
FILE
RDBMS
OLAP
XML
Synch
Search
Dynamic Development
Mobile and
Desktop
Pervasive Insight
Server
Cloud
Transparent Data Encryption
External Key Management
Data Auditing
Pluggable CPU
Transparent Failover for
Database Mirroring
Declarative Management
Framework
Server Group Management
Streamlined Installation
Enterprise System Management
Performance Data Collection
System Analysis
Data Compression
Query Optimization Modes
Resource Governor
Entity Data Model
LINQ
Visual Entity Designer
Entity Aware Adapters
SQL Server Change Tracking
Synchronized Programming Model
Visual Studio Support
SQL Server Conflict Detection
FILESTREAM data type
Integrated Full Text Search
Sparse Columns
Large User Defined Types
Date/Time Data Type
LOCATION data type
SPATIAL data type
Virtual Earth Integration
Partitioned Table Parallelism
Query Optimizations
Enterprise Reporting
Engine
Internet Report
Deployment
Block Computations
Scale out Analysis
BI Platform Management
Export to Word and
Excel
Author reports in Word
and Excel
Report Builder
Enhancements
TABLIX
Rich Formatted Data
Persistent Lookups
Personalized
Perspectives
Change Data Capture
… and many more
Backup Compression
MERGE SQL Statement
Data Profiling
Star Join
Enterprise Data Platform
• Secure, trusted platform for your data
• Optimized and predictable system performance
• Productive policy-based management of your infrastructure
Enterprise Data Platform
Beyond Relational
• Store and consume any type of data
• Deliver Location
Intelligence within your applications
Beyond
Relational
Dynamic Development
Dynamic
Development
• Accelerate your development with entities
• Synchronize your data from anywhere
Pervasive Insight
Pervasive Insight
• Integrate all your data in the Enterprise Data Warehouse
• Reach all your users with scalable BI platform
• Empower every user with actionable insights
Enterprise
Data Platform
Protect your information
Transparent Data Encryption
External Key Management
Data Auditing
Pluggable CPU
Enhanced Database Mirroring
Encrypt your data without requiring an
application re-write
Consolidate security keys within the data
center
Answer common auditing questions like
“what data was retrieved”
Increase the reliability of your
applications
Add system resources without affecting
your users
Implement automatic failover transparent
to your existing applications
Enterprise
Data Platform
Spend less time on ongoing
operations
Declarative Management
Framework
Server Group Management
Streamlined Installation
Manage via policies instead of scripts
Define Enterprise wide data management
policies
Automated monitoring and enforcement of
policies
Simplify your installation and configuration
Integrated with your enterprise
system management
Enterprise System Management
Define Policies that are compliant with
System Definition Model
Manage your data and system infrastructure
with Microsoft System Center
Enterprise
Data Platform
Performance Data Collection
System Analysis
Data Compression
Query Optimization Modes
Resource Governor
Optimize your System
Performance
Monitor your system by collecting
and storing system events
Analyze and report on your system
performance
Reduce your storage costs and
increase query performance
Predictable performance
Manage concurrent workloads on
single system
Prevent runaway queries
Ensure consistent query performance
• Secure, trusted platform for your data
• Productive policy-based management of your infrastructure
• Optimized and predictable system performance
• 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
Dynamic
Development
Entity Data Model
LINQ
Visual Entity Designer
Entity Aware Adapters
Develop with business entities
Define your business not tables
Model your complex business
relationships
Retrieve entities instead of rows
and columns
Connect to SQL Server with entity
aware adapters
Reliable application performance
Store entities locally on your clients
Dynamic
Development
 Access your data from anywhere
SQL Server Change Tracking
Synchronized Programming Model
Visual Studio Support
SQL Server Conflict Detection
 Store your data locally while
disconnected from server
 Synchronize Incremental changes
between client and server
 Detect conflicts during
synchronization including deletes
 Add disconnected scenarios without
re-writing existing applications
• Secure, trusted platform for your data
• Productive policy-based management of your infrastructure
• Optimized and predictable system performance
• 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
Beyond
Relational
FILESTREAM data type
Integrated Full Text Search
Sparse Columns
Large User Defined Types
Date/Time Data Type
Seamless transition between
relational and non-relational
Store your documents in cost
effective storage platform
Access documents as data
Encode your complex hierarchies
within XML
Extend the database to meet your
unique needs
Find your data
Query across relational and text
data
Build global applications
Capture precise time from clients
across the globe
Beyond
Relational
GEOMETRY data type
GEOGRAPHY data type
Build location-aware applications
Capture location data from across
your organization
Integrate location intelligence to
your existing applications
Visualize your location information
Standard Spatial applications
Virtual Earth Integration
Integrate with industry standard
spatial applications
Supported by 3rd parties
• Secure, trusted platform for your data
• Productive policy-based management of your infrastructure
• Optimized and predictable system performance
• 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
Pervasive
Insight
Enhanced Partitioning
DW Query Optimizations
Data Compression
Resource Governor
Persistent Lookups
Change Data Capture
MERGE SQL Statement
Data Profiling
Scale and Manage large number of
users and data
Improved Query performance on large
tables
Queries Optimized for data warehousing
scenarios
Increase I/O performance with efficient and
cost effective data storage
Manage concurrent workloads of ad-hoc
queries, reporting and analysis
Integrate growing volumes of data
Optimize your ETL performance by
identifying data in your largest tables
Reduce the data load volumes by capturing
operational changes in data
Simplify your insert and update data
processing
Profile your information to identify dirty data
Pervasive
Insight
Enterprise Reporting Engine
Internet Report Deployment
Deliver insights throughout your
organization
Deliver reports of any size and complexity
Enhance analytical capabilities with more
complex computations and aggregations
Deploy and manage your BI infrastructure
Subspace Computations
Streamlined Analysis Tools
Enhanced Analysis Design
Scalable Backup Tool
Streamline development of the analysis
infrastructure
Backup cubes with enhanced scalability
Improve productivity with new cube design tools
Optimize cube design with real time best
practice alerts
Deploy Reporting Services without IIS
dependency
Pervasive
Insight
Render Reports in Word and Excel
Flexible Report Layout
Report Builder Enhancements
TABLIX
Rich Formatted Data
Data Visualizations
MOLAP Writeback
Enhanced Data Mining
Deliver information via Microsoft Office
Render reports to Microsoft Word
Enjoy improved rendering to Microsoft Excel
Enable users to create powerful reports
Build powerful ad-hoc reports
Create reports with any structure using Tablix
Add rich text regions your reports
Embed powerful graphical data visualizations
into reports
Empower users with enhanced analysis
Empower users with enhanced write back
scenarios
Enhanced predictive analysis
2008
2007
Q4/05
Q2/06
SQL
Server
2005
SQL
Server
2005 SP1
Q1
Q2
Q1
Q2
2010 - 2011
JOINT
LAUNCH
SQL
Server
2005 SP2
TechEd
CTP3
RTM
SQL Server
“vNext++”
Note: CTPs approximately every 60 days beginning Tech∙Ed
© 2007 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.
Microsoft Confidential – NDA