Agenda

1
Welcome
2
Agenda
3
Who we are

• Don Vilen
• Program Manager
• SQL Server Storage Engine
• DonV_at_Microsoft.com
• Jason Carlson
• Product Unit Manager
• SQL Server Business Intelligence

4
The Tour
5
SQL Server 2005 Editions

• SQL Server 2005 Enterprise Edition
• 32-bit and 64-bit
• SQL Server 2005 Standard Edition
• 32-bit and 64-bit
• SQL Server 2005 Workgroup Edition
• 32-bit only
• SQL Server 2005 Developer Edition
• 32-bit and 64-bit
• SQL Server 2005 Express Edition
• 32-bit only

6
SQL Server TodayComprehensive, Integrated Data
Platform
Reporting Services Enterprise Reporting
Management Tools
Development Tools
Analysis Services OLAP Data Mining
Notification Services Notifications Alerts
Replication Services Data Replication
Integration Services ETL
SQL Server Engine Relational Database Engine
All of this comes with SQL Server
7
New in the Database Engine

• SQL Server Engine
• Message Service Broker
• HTTP Support (Native HTTP)
• Database Tuning Advisor
• Multiple Active Result Sets
• Persisted Computed Columns
• Snapshot Isolation Level
• Table and Index Partitioning
• VIA support
• NUMA support
• .NET Framework
• Common Lang. Runtime Integration
• User-defined Aggregates
• User-defined Data Types
• User-defined Functions
• SQL Server .NET Data Provider
• Extended Triggers
• Data Types
• Managed SQL Types

• XML
• XQUERY Support
• XML Data Manipulation Language
• FOR XML Enhancements
• XML Schema (XSD) Support
• MSXML 6.0 (Native)
• .Net XML Framework
• Database Failure and Redundancy
• Failover Clustering
• Enhanced Multi-instance Support
• Database Mirroring
• Database Snapshots
• Database Maintenance
• Backup / Restore Enhancements
• Checksum Integrity Checks
• Dedicated Admin Connection
• Dynamic AWE
• Fast Recovery
• Highly-available Upgrade

• Security
• All Permissions Grantable
• Fine Grain Administration Rights
• Separation of Users and Schema
• Data encryption primitives
• Full-text Search
• Indexing of XML Datatype
• Replication
• Replication Monitor
• Replicate DDL Changes
• Peer-to-peer Replication
• Auto-tuning Replication Agents
• Oracle Publication
• Improved Blob Change Tracking
• Management Tools
• New Management Studio
• MDX Query Editor
• Version Control Support
• XML/A

Plus all of BI !
8
Summary

• Getting the Most From SQL Server 2005
• Being More Secure
• Meeting the Availability Challenge
• Distributing Data for Availability and
  Scalability
• Building Data Integration Solutions with
  Integration Services
• Deliver Rich Analytics with Analysis Services
• Enterprise Reporting with Reporting Services

9
Product Feedback Center

• New Product Feedback Center
• http//labs.msdn.microsoft.com/productfeedback
• In this center - you can see and vote on
  suggestions view bugs from other customers and
  make new suggestions or file bugs
• You can also view work-arounds and sign up to
  receive progress updates from Microsoft on
  suggestions and bugs

10
Gathering Scenarios

• If you have any painpoints that you do not feel
  are addressed by SQL Server 2005
• Please send email to DonV_at_microsoft.com
• Jasoncar
• Please include
• A brief description of what it is that is causing
  the pain
• A scenario describing what it is that you are
  trying to accomplish

11
Questions

• And answers

12
Thanks for Coming