SQL Server 2005 for Developers

1
SQL Server 2005 for Developers

• Jeremy Boyd
• email jeremyb_at_intergen.co.nz
• blog http//turtle.net.nz/blog

2
Agenda

• Quick 50 Minute Tour
• Improvements with ADO.NET 2.0
• New T-SQL Functions
• How the SQLCLR works for you
• Full support for XML

3
ADO.NET 2.0

• Top 3
• Query Notifications
• System.Transactions
• Datasets

4
ADO.NET
5
T-SQL

• Top 3
• Ranking Functions
• try foo catch bar
• Common Table Expressions

6
T-SQL
7
SQLCLR

• Top 3
• Managed Functions
• Managed User Defined Types
• Calling to the Outside World

8
SQLCLR
9
SQLXML

• Top 3
• XML Querying
• XML Manipulation
• Tight integration between .NET and SQLXML

10
SQLXML
11
Service Pack 1

• Now released!
• Functionality and fix release
• Database Mirroring
• http//www.microsoft.com/sql/sp1.mspx

12
SQL Express

• Supports everything shown today
• Get the SP1 version
• Reporting Services support
• Full Text Indexing support
• Management Studio Express tool
• Free!

13
Summary

• ADO.NET Better client side capabilities, more
  efficiencies for large data
• T-SQL Finally the useful functions we were
  missing from other SQL families
• SQLCLR Provides support for complex code /
  helper functions
• SQLXML Full support for XML