- Used Books
- Staff Picks
- Gifts & Gift Cards
- Sell Books
- Stores & Events
- Let's Talk Books
Special Offers see all
More at Powell's
Recently Viewed clear list
Used Trade Paper
Usually ships in 5 to 7 business days
available for shipping or prepaid pickup only
Sql Server 2000: the Complete Referenceby Jeffrey Shapiro
Synopses & Reviews
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:
Book News Annotation:
This reference for database administrators, operators, developers, and network administrators of all skill levels describes the various applications of Microsoft's SQL Server 2000 database management and data analysis system. Topics include, for example, how to build scalable, distributed, Web-enabled database solutions; implementing sound security protocols; and creating and using data warehouses. Coverage extends to special topics such as the Server's support for XML and English Query.
Annotation c. Book News, Inc., Portland, OR (booknews.com)
Master the revolutionary new release of Microsoft's high-performance, scalable database management system. This complete reference explains installation, configuration, administration, replication, security, backup, and recovery. You'll also learn to exploit all the advanced features of SQL Server 2000, including the Enterprise Manager, TSQL, data warehousing, and OLAP services.
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:
About the Author
Jeffrey Shapiro (Boca Raton, FL) has been involved in IT for more than 12 years and has worked with hundreds of companies around the world including Microsoft, IBM and Novell. He has been a key speaker on IT and Software Engineering at numerous conferences. Trained as a journalist, Jeffrey now spends most of his time writing on IT. He is also the editor of two new newsletters: Service Level and CRM Review.
Table of Contents
Part I: SQL Server 2000 System and Platform Architecture.
Chapter 2: Database Architecture.
Chapter 4: DBMS Architecure.
Chapter 6: Installing SQL Server 2000.
Chapter 7: Adminstering Architecture.
Chapter 9: SQL Server Disaster Recovery.
Chapter 11: SQL Server 2000 Databases.
Chapter 13: SQL Server 2000 high Availability.
Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models.
Chapter 16: Transact-SQL Primer.
Chapter 18: Stored Procedures and Triggers.
Chapter 20: Working with Operational Data.
Chapter 22: English Query.
Part IV: SQL Server 2000 Analysis Services.
Chapter 25: Getting Started: Analysis Services and OLAP.