Fortunately, now there is a book for developers who need to go from SQL Server 2000 to SQL Server 2005 and to do it as a possible pain. Tom Moreau SQL Server MVP and Monthly Columnist SQL Server Professional, Brockman Moreau Consulting Inc. "A SQL book truly for developers, from two authorities on the subject of me.'ll Turn to this book first when I need to understand the components of SQL Server 2005." - Matt Milner Teacher Pluralsight "An excellent book for us who need to get up to speed on what's new in SQL Server 2005. Although a variety of great information, my favorite part was the advice given on when to use what, and how performance is affected." - Laura Blood Senior Software Developer Blue Note Computing, Inc. "SQL Server 2005 is a major release with a large number of these new features should be on every bookshelf SQL Server developers .." - Roger Wolter Solution Architect Microsoft Corporation "Although there will be plenty of good books on the development of SQL 2005 Server, when people refer to the 'Bible,' they'll talk about this book." - Dr. Greg Low Senior Consultant Readify Pty Ltd "SQL Server 2005 is loaded with new features and get a good picture is important to understand how you can benefit from the features of SQL Server 2005 as a developer they did. A good job striking a balance between imagery and substance." - Michiel Wories Senior Program Manager, SQL Server Microsoft Corporation Several technologies have been as anticipated as Microsoft SQL Server 2005 2005. A Developer's Guide to SQL Server starts where Microsoft's documentation, white papers and Web articles leave off, showing developers how to take full advantage of 2005 the key innovations of SQL Server. It draws on exceptional cooperation from Microsoft SQL Server developers and broad access authors' to SQL Server 2005 since the beginning of an alpha release. You'll find practical explanations of the new model of SQL Server 2005 data, a built-in NET hosting, improved programabilitas, SQL:. 1999 compliance, and more. Virtually every key concept is illuminated via sample code that has been fully updated for and tested with the version of product delivery. Key coverage includes Using SQL Server 2005 as NET runtime host:. Extending the server while enhancing security, reliability, and performance Writing procedures, functions, triggers, and types in the NET languages use enhancements to T-SQL for robust error-handling, efficient queries. and improving effective syntax using XML data type and XML query native Implementing SQL Server 2005 Web Services Writing efficient, robust client to SQL Server 2005 using ADO.NET, classic ADO, and other API Taking full advantage of user-defined types (UDTs ), query notifications, transactions are promoted, and sets some of the active (MARS) Using SQL Management Objects (SMO), SQL Service Broker, and SQL Server Notification Services to build integrated applications