• eBook Price: $34.99
  • Print Book Price: $49.99
Buy eBook Buy Print Book

Pro SQL Server 2005 Cover Image

This book takes a deep look at the full range of SQL Server 2005 enhancements. Relevant examples show how these new features work and how you can architect applications effectively. The book's core topics include enhancements to database programmability features and languages, such as ADO.NET, XML, .NET assemblies, and T-SQL.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-59059-477-3
  • 704 Pages
  • User Level: Beginner to Advanced
  • Publication Date: November 6, 2005
  • Available eBook Formats: PDF

Related Titles

  • SQL Server T-SQL Recipes
  • Energy Efficient Servers
  • Introducing SQL Server
  • Expert SQL Server in-Memory OLTP
  • Extending SSIS with .NET Scripting
  • Pro SQL Server Wait Statistics
Full Description

SQL Server 2005 is a dramatically expanded and enhanced version of SQL Server 2000 that not only makes SQL Server a true enterprise-level RDBMS, but also changes how SQL Server professionals design databases and develop database applications.

Pro SQL Server 2005 provides in-depth coverage of new SQL Server features and enhancements. It focuses on what experienced SQL Server database administrators, developers, and business intelligence practitioners need to know to get up to speed with SQL Server 2005 as quickly as possible. It carefully presents each new feature and precisely illustrates the feature with examples that show you how to use it effectively.

The authors provide practical, in-depth coverage of the core topics that they specialize inall supported by realistic examples, so you’ll be able to design and implement your own SQL Server 2005 solutions quickly and painlessly. This book is a roadmap for exploring and exploiting SQL Server 2005. So fasten your seatbelts, start your computers, and race to mastery of SQL Server 2005!

What you’ll learn

This book offers incisive, expert guidance on all of the major functionality of SQL Server 2005, covering topics that are essential for all SQL Server professionals, including

  • Transact-SQL enhancements
  • SQL Server Management Studio
  • CLR integration and programming stored procedures in C#
  • SQL Server Reporting Services enhancements
  • SQL Server Analysis Services enhancements
  • The new XML datatype and XQuery support
  • Security enhancements and Service Broker
  • SQL Server Integration Services for data extraction, transformation, and loading

Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

No errata are currently published

Best-Sellers

    1. Beginning SQL Server 2012 Administration

      $34.99

      View Details

    2. Pro T-SQL Programmer\'s Guide

      $41.99

      View Details

    3. Beginning SQL Server 2008 Administration

      $31.99

      View Details

    4. Beginning SQL Server for Developers

      $34.99

      View Details