Microsoft SQL Server 2005: The Complete Reference

Full Coverage of all New and Improved Features

Have a Promotion Code?

Please enter it here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.



November 17, 2006


Paperback, 672 pages


0072261528 / 9780072261523


Your Price



Main description

SQL Server 2005 is Microsoft's next-generation data management and analysis software designed to deliver increased scalability, availability, and security to enterprise data and analytical applications while making them easier to create, deploy, and manage. Filled with practical solutions and real-world examples, this resource includes full details on:

  • Enterprise data management capabilities, including security and clustering
  • Powerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0
  • Business Intelligence features, such as Integration Services, data warehousing, and reports

Table of contents

Part I: SQL Server 2005 System and Platform ArchitectureChapter 1: Getting to Know SQL Server 2005Chapter 2: Database ArchitectureChapter 3: RDBMS ArchitectureChapter 4: Connecting to and Administering the Database EnginePart II: Administering SQL Server 2005Chapter 5: SecurityChapter 6: Databases, Tables, and IndexesChapter 7: SQL Server Disaster RecoveryChapter 8: Distributed Database ArchitectureChapter 9: SQL Server 2005 High AvailabilityPart III: Programming SQL Server 2005Chapter 10: Transact-SQL PrimerChapter 11: Understanding the SQL Server Common Language RuntimeChapter 12: Data IntegrityChapter 13: TriggersChapter 14: Stored Procedures and FunctionsPart IV: Working with SQL Server 2005Chapter 15: Working with Operational DataChapter 16: Working with Tabular DataChapter 17: Working with Transactional DataChapter 18: Monitoring SQL ServerAPPENDIX A: T-SQL REFERENCEINDEX

Author comments

Jeffrey Shapiro, MCSE, MCTS, MCPD, is the author of SQL Server 2000: The Complete Reference as well as 11 other technology books. He is currently working on a variety of SQL Server business intelligence projects for Fortune 100 companies in Orlando, Florida.

Back cover copy

The Definitive Guide to Microsoft SQL Server 2005

Deliver high-performance, widely distributed enterprise database applications using Microsoft SQL Server 2005. This comprehensive resource shows you how to get up-and-running on SQL Server 2005, create and manage databases and tables, triggers, functions, stored procedures, transactions, and advanced database queries. Microsoft SQL Server 2005: The Complete Reference covers every aspect of the new release in full detail, starting with an in-depth review of the core database engine. The book goes on to cover the management and maintenance tools, the SQL Server support of the .NET Common Language Runtime, database integrity, transactions, security, performance management tools, and monitoring techniques.


  • Set up, configure, and manage Microsoft SQL Server 2005
  • Understand the RDBMS architecture
  • Develop, debug, and deploy Web-enabled database applications
  • Build databases, tables, indexes, and views
  • Create triggers, stored procedures, and functions
  • Implement sound security and disaster recovery policies
  • Integrate .NET applications and XML
  • Write sophisticated T-SQL statements in SQL Server Management Studio
  • Optimize data integrity and maximize application availability
  • Work with operational, tabular, and transactional data

Copyright 2013 McGraw-Hill Global Education Holdings, LLC


Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.

Yes, I want to receive other special offer.