Microsoft SQL Server 2005: The Complete Reference

Customers who bought this, also bought: Microsoft SQL Server 2005 Unleashed Microsoft SQL Server 2005 Administrator's Pocket Consultant Practical Guidelines and Best Practices for Microsoft® Visual Basic® and Visual C#® Developers Extreme .NET: Introducing eXtreme Programming Techniques to .NET Developers DNS on Windows Server 2003 Programming Microsoft® ADO.NET 2.0 Applications: Advanced Topics A Tester's Guide to .NET Programming Windows Server 2003 Bible Mastering Windows Server 2008 R2 Beginning Transact-SQL with SQL Server 2000 and 2005

by: Jeffrey Shapiro

Notify me when in stock

On-line Price: $56.00 (includes GST) Paperback package 645 20%Off Retail Price You save: $14.00 Please call us to check availability	Retail Price: $70.00 Publisher: MCGRAW-HILL,17.11.06 Category: Level: ISBN: 0072261528 ISBN13: 9780072261523
Add to Shopping Cart

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 Architecture
Chapter 1: Getting to Know SQL Server 2005
Chapter 2: Database Architecture
Chapter 3: RDBMS Architecture
Chapter 4: Connecting to and Administering the Database Engine
Part II: Administering SQL Server 2005
Chapter 5: Security
Chapter 6: Databases, Tables, and Indexes
Chapter 7: SQL Server Disaster Recovery
Chapter 8: Distributed Database Architecture
Chapter 9: SQL Server 2005 High Availability
Part III: Programming SQL Server 2005
Chapter 10: Transact-SQL Primer
Chapter 11: Understanding the SQL Server Common Language Runtime
Chapter 12: Data Integrity
Chapter 13: Triggers
Chapter 14: Stored Procedures and Functions
Part IV: Working with SQL Server 2005
Chapter 15: Working with Operational Data
Chapter 16: Working with Tabular Data
Chapter 17: Working with Transactional Data
Chapter 18: Monitoring SQL Server
APPENDIX A: T-SQL REFERENCE
INDEX

Biographical note
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.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS:
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