Welcome Eric Nelson Application Architect Microsoft UK

1
WelcomeEric NelsonApplication
ArchitectMicrosoft UK
MSDN Technical Briefing SQL Server 2005 - What's
New for Developers?
2
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

3
Integration Services
4
SQL Server GenerationsHistory of Innovation
1st Generation
2nd Generation
3rd Generation
SQL Server 7.0
SQL Server 2005
SQL Server 2000
SQL Server 6.0/6.5

• Availability focus
• Security
• Developer productivity
• Native XML
• First to include Enterprise ETL Deep Data Mining

• Performance, scalability focus
• XML support
• First to include Notification
• First to include Data Mining Reporting

• Re-architecture of relational server
• Extensive auto resource management
• First to include OLAP ETL

• Differentiation from Sybase SQL Server
• Windows integration
• First to include Replication

• Lowest TCO
• Automatic Tuning

• Reliability Security
• Integrated Business Intelligence

Cross-release objectives
5

• 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

6
Early Customer DeploymentsWill go Live on Beta 3
7
Timeline beta 2 to launch
More fixes less testing
Public beta
Early adopters Engaged
Release to Manufacturing
Beta 3 Q1 2005
Beta 2 July 2004
RTM Summer 2005
CTPs
Launch H2 2005
Timing of final release will ultimately depend on
customer and partner beta feedback
8
1 Popular with ISVs Database MirroringAchieving
high availability while managing costs

• Database Failover
• Very fast failoverless 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
9
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

10
3 Popular with ISVs Lots

• CLR Integration
• Integration Services
• Analysis Services
• TSQL Enhancements
• Reporting Services/Report Builder
• Service Broker

11
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 ericnel_at_microsoft.com if you are already
  active on Beta 2
• Keep watching http//www.microsoft.com/uk/events

12
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
  pre-Beta 3
• Contact ericnel_at_microsoft.com if you are already
  active on Beta 2
• Keep watching http//www.microsoft.com/uk/events

13
Possible next steps

• Wait
• Wait until beta 3 ? ?
• Wait until RTM ?
• Wait until SP1 ????
• If you are already active and a partner, contact
  ericnel_at_microsoft.com
• 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

14
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