Transcript Integration Services

MSDN Technical Briefing
SQL Server 2005 - What's New for Developers?
Welcome
Eric Nelson
Application Architect
Microsoft UK
Agenda 
6.30 Eric Says Hello
6.45 Mike does CLR and ADO stuff
7.45 Break
8.00 Eric does TSQL and XML
9.00 Home to bed
Integration Services
SQL Server Generations
History of Innovation
1st Generation
SQL Server
6.0/6.5
• Differentiation
from Sybase SQL
Server
• Windows
integration
• First to include
Replication
Cross-release
objectives
2nd Generation
SQL Server
7.0
• Re-architecture of
relational server
• Extensive auto
resource
management
• First to include
OLAP & ETL
SQL Server
2000
• Performance,
scalability focus
• XML support
• First to include
Notification
• First to include Data
Mining & Reporting
3rd Generation
SQL Server
2005
• Availability focus
• Security
• Developer
productivity
• Native XML
• First to include
Enterprise ETL &
Deep Data Mining
• Reliability & Security
• Lowest TCO
• Integrated Business Intelligence • Automatic Tuning
High availability for enterprise applications
Key security and performance features
Focus on self manageability and optimization
Integration with Visual Studio and .NET
Native XML technology
Interoperability via Web Services
Real time decision making: reporting, data mining
Rich client and SharePoint solutions
Comprehensive ETL solution: up to 600% faster
Early Customer Deployments
Will go Live on Beta 3
Large 16-way Tandem Migration
Mobility application for delivery trucks
Large Retail Data Warehouse
High-transaction trading infrastructure
Help-Desk Service application
5000 concurrent user OLAP application
Large SAP/R3 Deployment
Multiple internal Systems – High Tech Vertical
Timeline – beta 2 to launch
Early
adopters
Engaged
More
fixes –
less
testing
Beta 2
July 2004
CTPs
Public
beta
“Release to
Manufacturing”
Beta 3
RTM
Launch
Q1 2005
Summer
2005
H2 2005
Timing of final release will ultimately depend on customer and partner beta feedback
#1 Popular with ISVs: Database Mirroring
Achieving high availability while managing costs
Database Failover
Very fast failover…less than 3 seconds
Automatic or manual failover
Automatic, transparent client redirect
Database Snapshots for Reporting
Works with standard hardware and storage
App
Mirror
SQL 2005
Principal
SQL 2005
Witness
SQL 2005
#2 Popular with ISVs: XML
In SQL 2000
Store XML in db
Retrieve XML from db
Manipulate XML
Store XML in db
In SQL Server 2005
Store XML in db
Manipulate XML in the db
#3 Popular with ISVs: Lots
CLR Integration
Integration Services
Analysis Services
TSQL Enhancements
Reporting Services/Report Builder
Service Broker
…
Some activities to be aware of
SQL Server 2005 Webcast Week
http://msdn.microsoft.com/SQL/2005Webcasts/
Dec 6th to 10th
UK Opportunities for MSDN Certified
partners
Looking at options to help active partners pre-Beta 3
Contact [email protected] if you are already
active on Beta 2
Keep watching http://www.microsoft.com/uk/events
Some activities to be aware of
SQL Server 2005 Webcast Week
http://msdn.microsoft.com/SQL/2005Webcasts/
Dec 6th to 10th
UK Opportunities for partners
Looking at options to help active partners preBeta 3
Contact [email protected] if you are
already active on Beta 2
Keep watching
http://www.microsoft.com/uk/events
Possible next steps
Wait
Wait until beta 3  
Wait until RTM 
Wait until SP1 
If you are already active and a partner, contact
[email protected]
If you just want to know more, check out the
resources and attend the Dec Webcasts
If you want to start using it now
As MSDN Subscriber – download Beta 2 and/or CTP
If not, then download SQL Express
Resources
Main page on Microsoft.com
http://www.microsoft.com/sql/2005/
Developer information
http://msdn.microsoft.com/SQL/
SQL Server 2005 Express
http://lab.msdn.microsoft.com/express/sql/
Blogs:
http://blogs.msdn.com/ericnel
Lots of links…