Transcript Enterprise Data Platform Dynamic Development Beyond Relational

Dan Galvez
Hedgehog Development
[email protected]
631-676-2186 x200
SQL Server 2005 Momentum
Data Platform Vision
Delivering on Vision
Enterprise Data Platform
Dynamic Development
Beyond Relational
Pervasive Insight
Predictable Customer Value
“We provide resources to help companies
create and communicate information to their
internal teams and customers through the use
of technology.”
Application Lifecycle Management (ALM)
Solutions using VSTS
SharePoint Intranets and Extranets
Sitecore Content Managed Web sites
Custom .NET Development Solutions
Database and BI SQL Server and PPS
Microsoft Gold Partner
Microsoft Partner of the Year 2008 - Excellence in
Application Platform Optimization (APO)
Microsoft Customer Satisfaction Awards - Three
consecutive quarters
Microsoft “Inner Circle Status” – Visual Studio
Team System (VSTS)
Certified Sitecore Partner
Enterprise Ready!
ESG: Microsoft years ahead of Oracle for secure database
OLTP and Data Warehouse Benchmark Leader
IDC: More Units sold than Oracle and IBM Combined
Gartner: Fastest growing DBMS and BI vendor
8M SQL Server Express Downloads
Over 600K IT Pros & Devs trained
Partners: >3000 ISVs
“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
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
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
Dynamic
Development
Enterprise
Data Platform
Policy-Based Manage1ment
Performance Data Collection
Extended Events
Table-Valued Parameters
Beyond
Relational
FILESTREAM data type
Pervasive
Insight
AS Scalable backup tools
AS Dimension Design
GROUPING SETS
Large User-Defined Types
Star Join Query Optimization
MERGE command
Large User-Defined Aggregates
Enterprise Reporting Engine
Database Mirroring Enhancements
Conflict Detection
Data Compression
DATE/TIME Data Types
Improved XML Support
Query Optimization Modes
AS Time Series
Visual Studio Support
VSTA Support for Script task
Sync Services for ADO.NET
Resource Governor
Virtual Earth Integration
Enhanced Data Visualization
Change Data Capture (CDC)
Report Builder Enhancements
Support for 3rd Party Certificates
Occasionally Connected Systems (OCS)
GEOGRAPHY data type
Transparent Data Encryption
Better rendering for Word & Excel
Entity Data Model (EDM)
External Key Management
GEOMETRY data type
Partitioned Table Parallelism
ADO.NET Entity Framework
Data Auditing
Sparse Columns
LINQ
AS Query Optimizations
Pluggable hot-add CPU
Streamlined Installation
Server Group Management
ADO.NET Data Services
Visual Entity Designer
Filtered Indexes
Integrated Full Text Search
Data Mining Engine Improvements
IIS Agnostic Report Deployments
Best Practice Design Alerts
Enterprise System Management
Entity Aware Adapters
Performance System Analysis
SSB Priorities & Diagnostics
Persistent Lookups
Upgrade Advisor
CLR Improvement
Scale-out AS
Partition Aligned Indexed Views
ORDPATH
Data Profiling
Backup Compression
AS Query & Writeback Perf
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
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
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
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
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
Upgrade to SQL Server 2005
http://www.microsoft.com/sql/solutions/upgrade/default.mspx
Learn more about SQL Server 2008
http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx
Download the latest CTP
https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395
Dan Galvez
Hedgehog Development
[email protected]
631-676-2186 x200