The Fictioning Horror Sale
 
 

Recently Viewed clear list


Original Essays | Yesterday, 10:00am

Lois Leveen: IMG Forsooth Me Not: Shakespeare, Juliet, Her Nurse, and a Novel



There's this writer, William Shakespeare. Perhaps you've heard of him. He wrote this play, Romeo and Juliet. Maybe you've heard of it as well. It's... Continue »
  1. $18.19 Sale Hardcover add to wish list

    Juliet's Nurse

    Lois Leveen 9781476757445

spacer
Qualifying orders ship free.
$5.95
Used Trade Paper
Usually ships in 5 to 7 business days
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
1 Remote Warehouse Database- Design

Sql Server 2000: the Complete Reference

by

Sql Server 2000: the Complete Reference Cover

 

Synopses & Reviews

Publisher Comments:

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

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)

Synopsis:

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.

Synopsis:

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

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 1: Getting to Know SQL Server 2000.

Chapter 2: Database Architecture.

Chapter 3: SQL Server 2000 Client/Server Architecture.

Chapter 4: DBMS Architecure.

Chapter 5: Meta Data Services.

Chapter 6: Installing SQL Server 2000.

Part II: SQL Server 2000 Platform Adminstration.

Chapter 7: Adminstering Architecture.

Chapter 8: SQL Server Security and Access Control.

Chapter 9: SQL Server Disaster Recovery.

Chapter 10: SQL Server Replication.

Chapter 11: SQL Server 2000 Databases.

Chapter 12: Administering SQL Server 2000.

Chapter 13: SQL Server 2000 high Availability.

Part III: Programming SQL Server 2000.

Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models.

Chapter 15: Getting Started with SQL Query Analyzer.

Chapter 16: Transact-SQL Primer.

Chapter 17: SQL Server Integrity Programming and Management.

Chapter 18: Stored Procedures and Triggers.

Chapter 19: Query Fundamentals and Strategy.

Chapter 20: Working with Operational Data.

Chapter 21: SQL Server 2000 Advanced Concepts.

Chapter 22: English Query.

Chapter 23: SQL Server and the Internet.

Part IV: SQL Server 2000 Analysis Services.

Chapter 24: Data Mining and Data Warehousing.

Chapter 25: Getting Started: Analysis Services and OLAP.

Product Details

ISBN:
9780072125887
Subtitle:
The Complete Reference
Author:
Shapiro, Jeffrey
Author:
Shapiro, Jeremy
Publisher:
McGraw-Hill Osborne Media McGraw-Hill Osborne Media
Location:
Berkeley, Calif.
Subject:
Programming Languages - SQL
Subject:
Database Management - General
Subject:
Client-server computing
Subject:
Database Management - SQL Server
Subject:
Sql server
Copyright:
Edition Number:
2
Edition Description:
Includes index.
Series:
Database Professional's Library
Series Volume:
no 4
Publication Date:
20001208
Binding:
Paperback
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Yes
Pages:
672
Dimensions:
9.250 x 7.380 in

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

Sql Server 2000: the Complete Reference Used Trade Paper
0 stars - 0 reviews
$5.95 In Stock
Product details 672 pages McGraw-Hill/Osborne Media - English 9780072125887 Reviews:
"Synopsis" by , 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.
"Synopsis" by , 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
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.