SQL Server

A First Look at Microsoft SQL Server 2005 for Developers (Microsoft .NET Development Series)

Name: A First Look at Microsoft SQL Server 2005 for Developers (Microsoft .NET Development Series)
Author: Bob Beauchemin
ISBN: 9780321180599

by Bob Beauchemin, Dan Sullivan, Niels Berglund

Write a review

Overview

Be the first to master SQL Server 2005's breakthrough database development capabilities

Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005 ("Yukon"). Now, three SQL Server insiders deliver the definitive hands-on preview—accurate, comprehensive, and packed with examples.

A First Look at SQL Server 2005 for Developers starts where Microsoft's white papers and Web articles leave off, showing working developers how to take full advantage of Yukon's key innovations. It draws on exceptional cooperation from Microsoft's Yukon developers and the authors' hands-on access to Yukon since its earliest alpha releases.

You'll find practical explanations of Yukon's new data model, built-in .NET hosting, improved programmability, SQL-99 compliance, and much more. Virtually every key concept is illuminated via sample code tested with Microsoft's public beta.

Key coverage includes:

Yukon as .NET runtime host: enhancing security, reliability, and performance
Writing procedures, functions, and triggers in .NET languages
Leveraging powerful new enhancements to T-SQL
The

SQL Server 2005 as a Web Services platform
Client-side coding: ADO/ADO.NET enhancements, SQL

Using SQL Server 2005's built-in application server capabilities

Already committed to SQL Server 2005? Simply evaluating it? Looking to set yourself apart from other SQL Server developers? Whatever your goal, start right here—today.

Synopsis

Be the first to master SQL Server 2005's breakthrough database development capabilities

Key coverage includes:

Yukon as .NET runtime host: enhancing security, reliability, and performance

Writing procedures, functions, and triggers in .NET languages

Leveraging powerful new enhancements to T-SQL

The

SQL Server 2005 as a Web Services platform

Client-side coding: ADO/ADO.NET enhancements, SQL

Using SQL Server 2005's built-in application server capabilities

Already committed to SQL Server 2005? Simply evaluating it? Looking to set yourself apart from other SQL Server developers? Whatever your goal, start right here—today.

0321180593B04152004

About the Author, Bob Beauchemin

Bob Beauchemin is a database-centric application practitioner and architect, DBA, instructor, course author, and writer. He's Director of Developer Skills at SQLskills (www.sqskills.com), and teaches his SQL Server 2005 courses around the world. Bob has written extensively on SQL Server and other databases, database security, ADO.NET, and OLE DB.

Niels Berglund, Microsoft Valued Professional for OLE DB and ADO, teaches .NET and Microsoft data access for DevelopMentor. He has consulted widely on the development of distributed financial applications built with SQL Server.

Dan Sullivan runs his own consulting company, does training for Pluralsight (www.pluralsight.com), and has worked with SQL Server since it was first distributed by Microsoft and ran on OS/2. Dan has spoken and written widely on SQL Server.

Reviews

There are no reviews yet. Log in to write one.

Editorials

From Barnes & Noble

The Barnes & Noble Review
More new features have been added to SQL Server 2005 (a.k.a. Yukon) than to any previous version. (No wonder it’s taken so long to ship!) These features can help developers accomplish remarkable things. Now the creators of Microsoft’s five-day Yukon workshops have written a developer’s preview of exceptional technical depth.

With Microsoft’s .NET CLR engine deeply embedded in SQL Server 2005, stored procedures and triggers can be written in most .NET languages. That’s huge, and this book’s DevelopMentor authors help you take full advantage. You’ll find detailed coverage of improvements to security, plus a full section on Yukon’s outstanding XML support (native XML data type functionality, XQuery support, and much more). The authors illuminate SQL Server Service Broker, Microsoft’s challenging new framework for large-scale, line-of-business applications. If you even suspect you’ll be creating SQL Server 2005 applications, you should own this book. Bill Camarda

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2003 and Upgrading & Fixing Networks for Dummies, Second Edition.