Welcome Plenary Ian Moulster Lead Programme Manager Microsoft Developer

1
Welcome PlenaryIan MoulsterLead Programme
ManagerMicrosoft Developer Platform Evangelism
Group
MSDN Technical Briefing A Developers Guide to SQL
Server today and tomorrow 'Yukon' (version 2005)
2
Plenary

• \Ple"nary\, a. LL. plenarius, fr. L. plenus
  full Full entire complete absolute as, a
  plenary license plenary authority.

3
Agenda

• 0945 Welcome Plenary - Ian Moulster
• 1015 SQL Server 2000 Reporting Services - Stephen
  Turner
• 1115 Break
• 1130 SQL CLR Tim Sneath
• 1245 Lunch
• 1330 T-SQL and XML Enhancements Eric Nelson
• 1445 Break
• 1500 Analysis Services / DTS Tim Sneath
• 1615 QA / Close

4
Housekeeping

• Post-event website http//www.microsoft.com/uk/ms
  dn/events/post_events.asp
• Critique forms etc

5
(No Transcript)
6
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
7
SQL Server Summary of release activities

• Web Services Toolkit
• Launched February 14th, 2002
• SQL BI Accelerator
• Launched May 9th, 2002
• SQL Notification Services
• Launched August 26th, 2002
• SQL Server CE 2.0 v2
• Launched September 16th, 2002
• SQL Server 2000 Service Pack 3
• Launched January 17th, 2003
• SQL Server 64 bit
• Launched April 24, 2003
• SQL Server Reporting Services
• Launched January 27th 2004

8
5TB and 33B rows in single app 15TB total
3TB network schema mapping app
3 TB telephony application 12B rows
1.7TB Internet auction app
1.6TB data warehouse
1.3TB data warehouse
1.3TB data warehouse retail application
1TB data warehouse retail application
1 TB customer credit data app, 16 TB total
9

• 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

10
Industry Accolades
This new version - code-named "Yukon - is
slated to be Microsoft's greatest attack yet into
corporate enterprise data centers. The three main
themes of this release - enterprise-level
management, decision support, and a deep
development environment integration - map well to
functionality that IT organizations are seeking
in DBMS platforms. Mark Shainman, Meta Group
JULY 26, 2004 In addition to64-bit
functionality, Yukon testers this week can begin
to try out several other enhancements in SQL
Server 2005 Beta 2 designed to bolster
productivity, security and business
intelligence.

• JULY 26, 2004 -The only real downside to getting
  started with the beta (2) is that it's bound to
  make you impatient to deploy the real thing.

11

• Availability and security advancements
• Database mirroring, online operations for
  increased availability
• Data security and privacy encryption, enhanced
  auditing
• Continued focus on manageability
• Integrated management toolset for relational and
  OLAP
• Expanded self tuning
• Performance and scalability
• Scales as the business grows partitioning,
  snapshots
• From mobile devices to 64-bit data centers

12
Manageability Goals

• Integrated Management, Rich UI
• Scale down time/effort for common management
  tasks
• Server Transparency
• Everything scriptable

13
64-bit Database PlatformHigh-performance
computing

• Optimised for Windows Server 2003
• Support for AMD Opteron Intel Itanium with Beta
  2
• Intel EM64T coming with Beta 3
• Great performance
• Large memory addressability (up to 32 TB)
• Nearly unlimited virtual memory (up to 8 TB)
• I/O savings due to larger memory buffer pools
• T-SQL code-compatibility with SQL Server 2000
• 8 node clustering support
• Same on-disk format as 32-bit for easy migration
• 64bit support for relational engine and BI
• Compelling alternative to expensive Unix solutions

The highly scalable database platform for memory
intensive, performance-critical business
applications
14
SQL Server Mobile

• Expanded device support
• Support for future release of Windows Mobile
  Smartphone
• Support for TabletPC
• Support for next generation Windows Mobile
  devices
• Tighter integration with SQL Server and Visual
  Studio
• Integration with SQL Server Management Studio
• Import data to SQL Mobile from any DTS data
  source
• Integration with Visual Studio 2005
• Advanced feature set
• New storage engine
• Enhanced Query Processor
• Rich, expanded synchronization support

15
Summary DBA Productivity with SQL Server 2005

• Reliable and secure
• Ease-of-use and TCO leader for database
  management
• Achieve high availability without added
  complexity, cost
• Scales from mobile device to the datacenter

16

• Leverage existing development skills
• Integration with Visual Studio
• Multiple languages T-SQL, VB.NET, C
• Share data across any platform
• Native support for XML, Web services
• Interoperability with any platform, application
• Extensibility
• Native XML data type, user defined data types
• New distributed application framework Server
  Broker

17
.NET and Visual Studio IntegrationBreakthrough
in Developer Productivity

• Choice of programming language
• T-SQL for data-intensive functions and procedures
• .NET languages for CPU-intensive functions and
  procedures
• Choice of where to run logic
• Database or mid-tier
• Symmetric data access model ADO.NET
• Integrated debugging experience across mid-tier
  and database tier
• Seamlessly step cross-language TSQL and .NET
• Set breakpoints anywhere, inspect anything
• Flexible and extensible
• Users defined functions, procedures, triggers
• User defined types and aggregates
• XML data type / web services

18
Query Notifications

• Execute query and get notified when the results
  have changed
• Subscription
• Query
• ID, Service Broker Service, TimeOut
• Notification
• SQL Server begins DIALOG with Service
• Notification is delivered to the Service
• Client APIs ADO.Net, OLEDB
• Customer Usage, benefit Caching

19
Summary Developer Productivity with SQL Server
2005

• Most productive platform for DB development
• Familiar, end-to-end development environment
• Leverage existing skills
• Flexible, interoperable and extensible

20

• Scalable, comprehensive solution
• End-to-end business intelligence
• Integrated with Visual Studio for rapid BI
  development
• Real-time decision making tools
• New extensible reporting platform
• Scalable and reliable for 247 support
• BI for the entire enterprise
• Supports heterogeneous data sources
• Enterprise-class ETL (DTS)

21
SQL Server 2005
A Complete Enterprise Data Management and BI
Solution
Management Tools
Development Tools
Reporting Services
Analysis Services OLAP Data Mining
Data Transformation Services ETL
SQL Server Relational Engine
22
Summary Business Intelligence Productivity with
SQL Server 2005

• Real-time decision making
• Drive business insight at all levels of the
  organisation Productive, integrated BI
  development experience
• End-to-end Business Intelligence capabilities
  out-of-the-box

23
Visual Studio 2005
ArchitectsDevelopersTesters ProjectManagers
HobbyistsEnthusiastsStudents
24
SQL Server 2005 Express

• Same engine as other versions
• Main differences
• Lack of enterprise features support
• Limited to one CPU
• One GB memory limit for the buffer pool
• Databases have a 4GB maximum size
• Easy to scale up to pro / enterprise versions
• Designed with two uses in mind
• Server product (eg Web Server or database server)
• Local client data store
• The three main usage scenarios are
• Non-professional developers building Web
  applications
• ISVs redistributing SQL Server Express as a
  low-end server or client data store
• Hobbyists building basic client/server
  applications

25
Timeline beta 2 to launch
Public beta
Release to Manufacturing
Available at this event
Beta 2 July 2004
Beta 3 H1 2005
RTM Summer 2005
Launch H2 2005
Timing of final release will ultimately depend on
customer and partner beta feedback
26
Yukon Ascend

• Yukon beta programme
• Fairly strict entry requirements
• Benefits to you could include a 5-day training
  course, product group support via a private
  newsgroup, access to beta code, and PR
  opportunities in 2005
• Benefits to us include good real-world feedback,
  and PR opportunities
• Nominations close end Sept speak to me (or
  email ianm_at_microsoft.com) if youre interested

27
Some activities to be aware of

• Yukon webcasts from the UK team
• 5th, 15th and 22nd Sept
• DevelopMentor Yukon courses
• Essential SQL Server 2005 Yukon for
  Developers
• 18th October, 29th November both in London
• Discount rate of 1,275 if you quote this event
  when booking! (normal fee 1,595)
• See http//www.develop.com/us/training/course.aspx
  ?id180
• Express SKU webcasts coming up
• Keep watching www.microsoft.com/uk/events

28
Whats in the bag?

• MSDN Magazine
• SQL Server 2005 beta 2 Developer Edition (CD)
• SQL Server 2005 beta 2 Resource DVD
• What about a Visual Studio 2005 beta?
• http//lab.msdn.microsoft.com/vs2005/get/emeaorder
  /default.aspx
• Small present as a thank-you!

29
Resources

• Main page on Microsoft.com http//www.microsoft.c
  om/sql/2005/
• Top 30 features http//www.microsoft.com/sql/200
  5/productinfo/top30features.asp
• Express Edition overview http//msdn.microsoft.co
  m/library/default.asp?url/library/en-us/dnsql90/h
  tml/sql_ovyukondev.asp
• Developer information http//msdn.microsoft.com/l
  ibrary/default.asp?url/library/en-us/dnsql90/html
  /sql_ovyukondev.asp
• Blogs
• http//blogs.msdn.com/tims/
• http//blogs.msdn.com/ericnel
• http//staff.develop.com/bobb/weblog/