A First Look at SQL Server 2005 for Developers

Description

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 XML data type and XML query languages
• SQL Server 2005 as a Web Services platform
• Client-side coding: ADO/ADO.NET enhancements, SQLXML, mapping, ObjectSpaces, and more
• 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

Get the book

Similar books

• 

  JDBC API Tutorial and Reference: Universal Data Access for the Java 2 Platform

  By Seth White

  This license allows and is limited to the creation and distribution of clean room implementations of this specification that ... For more information , please contact : Pearson Education Corporate Sales Division ; 201 W. 103rd Street ...

• 

  XML: Designing XML internet applications

  By David Megginson

  XML: Designing XML internet applications

• 

  数据挖掘在医学中的应用

  By 徐颖, 张维朋

  由于各部分自由度不相等,因此各部分离差平方和不能比较,必须将各部分离差平方和除以相应自由度,其即比值称为均方差,简称为均方。组间均方: ,组内均方:。这时根据这两个值可以进行F检验,即: }gs}image81-5.jpg}/gs} ,表示各个样本不是来自同一总体, ...

• 

  Inside Microsoft SQL Server 2008: T-SQL Querying

  By Itzik Ben-Gan

  Tackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals--and gain practical approaches and...

• 

  Inside Microsoft SQL Server 2008: T-SQL Programming

  By Itzik Ben-Gan

  Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the...

• 

  Advanced Oracle PL/SQL: Programming with Packages

  By Steven Feuerstein

  Steven Feuerstein's first book,Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and...

• 

  Inside Microsoft SQL Server 2005: Query Tuning and Optimization

  By Kalen Delaney

  Dig into the internals of tuning and optimization features in SQL Server 2005--with insights from leading SQL Server experts. This in-depth guide delivers best practices, pragmatic advice, and code samples...

• 

  A Developer's Guide to SQL Server 2005

  By Bob Beauchemin, Dan Sullivan

  "I come from a T-SQL background, so when I first laid my eyes on SQL Server 2005, I was shocked--and then, I was scared! I didn't have a CLR or...

• 

  SQL Fundamentals

  By John J. Patrick

  A comprehensive tutorial covering the fundamental concepts and ideas of SQL, and showing how these are implemented in both Oracle 9I and Access 2000 databases. John Patrick discusses how to...

• 

  Microsoft SQL Server 7.0 Programming Unleashed

  By Matthew Shepker, John Papa

  Certified professionals offer the benefits of their experiences in a variety of SQL Server settings as well as useful tips and workarounds to common problems. Overview of Major Topics: Part...