Designing SQL Server 2000 Databases

Designing SQL Server 2000 Databases

by Syngress
Released January 2001
Publisher(s): Syngress
ISBN: 9780080477190

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

The Microsoft .NET initiative is the future of e-commerce - making it possible for organisations to build a secure, reliable e-commerce infrastructure. This is the first book to outline the capabilities of SQL Server 2000, one of the key components of .NET. SQL Server 2000 introduces powerful new data mining functionality designed specifically to capture and process customer profiles and to predict future buying patterns on e-commerce sites.

Designing SQL Server 2000 Databases addresses the needs of IT professionals migrating from the popular SQL 7 databases to the new SQL 2000, as well as those who are starting from scratch.
  • Covers all key features of SQL Server 2000 including; XML support, enhanced data-mining capabilities and integration with Windows 2000
  • While there are many books available on SQL 7 - this is the first to be announced for SQL 2000
  • Free ongoing customer support and information upgrades

Table of contents

  1. Cover image
  2. Title page
  3. Table of Contents
  4. Copyright page
  5. Acknowledgments
    1. From Global Knowledge
  6. Contributors
  7. Technical Editor and Contributor
  8. Introduction
  9. Chapter 1: SQL Server 2000 Overview and Migration Strategies
    1. Introduction
    2. Overview of SQL Server 2000: A .NET Enterprise Server
    3. New and Enhanced Features of SQL Server 2000
    4. SQL Server 2000 Versions, Features, and Requirements
    5. Should You Migrate to SQL Server 2000?
    6. Steps to a Successful SQL Server Migration
    7. Summary
    8. FAQs
  10. Chapter 2: Installing and Configuring SQL Server 2000
    1. Introduction
    2. Planning a SQL Server Installation
    3. Installing SQL Server
    4. Configuration Options and Settings
    5. Summary
    6. FAQs
  11. Chapter 3: SQL Server Scalability and Availability
    1. Introduction
    2. Scaling Up vs. Scaling Out
    3. SQL Server Fail-Over Clustering
    4. Distributed Partitioned Views
    5. Log Shipping
    6. Indexed Views
    7. Summary
    8. FAQs
  12. Chapter 4: Designing and Creating SQL Server Databases
    1. Introduction
    2. SQL Server 2000 Architecture
    3. Creating SQL Server Databases
    4. Creating and Configuring Your Database
    5. Database Modeling Tools
    6. Summary
    7. FAQs
  13. Chapter 5: Database and Server Security
    1. Introduction
    2. Planning SQL Server Security
    3. Security Options in SQL Server
    4. Implementing Database and Server Security
    5. Summary
    6. FAQs
  14. Chapter 6: Administration and Active Directory Integration
    1. Introduction
    2. Windows 2000 Active Directory Integration
    3. Tools and Techniques for SQL Server Administration
    4. Moving and Copying SQL Server Databases
    5. Linked Servers
    6. Database Maintenance Tools
    7. Automating Administrative Tasks
    8. Summary
    9. FAQs
  15. Chapter 7: SQL Server Backup and Recovery
    1. Introduction
    2. Planning and Implementing a Successful Backup and Recovery Strategy
    3. Backup and Restore Tools and Techniques
    4. Backing Up SQL Server Databases
    5. Restoring SQL Server Databases
    6. Testing Your Backup and Recovery Strategy
    7. Summary
    8. FAQs
  16. Chapter 8: Microsoft English Query and Full-Text Search
    1. Introduction
    2. Overview of English Query
    3. Installing English Query
    4. Creating an English Query Application
    5. Building and Deploying Your English Query Application
    6. An Overview of Full-Text Search
    7. Enabling Full-Text Search
    8. Querying Full-Text Indexes
    9. Administering Full-Text Catalogs and Indexes
    10. Summary
    11. FAQs
  17. Chapter 9: Importing and Exporting Data
    1. Introduction
    2. Overview of Data Import and Export Tools
    3. Data Transformation Services
    4. Creating and Editing DTS Packages
    5. Executing DTS Packages
    6. The Bulk Copy Program
    7. SQL-DMO BulkCopy
    8. The BULK INSERT Command
    9. Choosing a Data Import and Export Method
    10. Summary
    11. FAQs
  18. Chapter 10: SQL Server Analysis Services
    1. Introduction
    2. Online Analytical Processing and Data Mining
    3. New Features in Analysis Services
    4. The Analysis Services Architecture
    5. Installing Analysis Services
    6. Designing and Building an OLAP Solution
    7. Designing and Building Cubes
    8. Defining Measures and Dimensions
    9. Using Your OLAP Solution
    10. Data Mining in SQL Server
    11. Security in Analysis Services
    12. Accessing Analysis Services Over the Web
    13. Performance Tuning and Optimization
    14. Summary
    15. FAQs
  19. Chapter 11: Using XML with SQL Server
    1. Introduction
    2. Overview of XML and SQL Server Support
    3. HTTP and URL Query Support
    4. XPath Queries
    5. SELECT…FOR XML
    6. XML Views
    7. Using and Updating XML Data
    8. Summary
    9. FAQs
  20. Chapter 12: Database Replication Techniques and Configuration
    1. Introduction
    2. SQL Server Replication Architecture
    3. Replication Compatibility
    4. Designing for Database Replication
    5. Replication Methods in SQL Server
    6. Configuring SQL Server Replication
    7. Dealing with Replication Conflicts
    8. SQL Server CE Edition Replication Features
    9. Replication and Active Directory Integration
    10. Replication Performance Considerations
    11. Replication Backup Strategies
    12. Summary
    13. FAQs
  21. Chapter 13: Programming Tools and Technologies in SQL Server
    1. Introduction
    2. Overview of SQL Server Programming
    3. New Programming Features in SQL Server 2000
    4. Transact-SQL
    5. Data Access Tools and Technologies
    6. Programming Administrative Tasks
    7. Analysis Services Programming
    8. DTS Programming
    9. Replication Programming
    10. Meta Data Services Programming
    11. Summary
    12. FAQs
  22. Chapter 14: Performance-Tuning Tools and Techniques
    1. Introduction
    2. Partitioning Data and Federated Database Servers
    3. Optimizing Query Performance
    4. Optimizing Database Performance with SQL Profiler
    5. Optimizing Server Performance
    6. Summary
    7. FAQs
  23. Index
  24. The Global Knowledge Advantage
    1. Global Knowledge Classroom Education Programs
    2. Custom Learning Solutions
    3. Self-Paced and Multimedia Products
    4. Electronic Delivery of Training
  25. Global Knowledge Courses Available
  26. Custom Corporate Network Training
  27. Get More at access.globalknowledge: The premier online information source for IT professionals
  28. Syngress Solutions…

Product information

  • Title: Designing SQL Server 2000 Databases
  • Author(s): Syngress
  • Release date: January 2001
  • Publisher(s): Syngress
  • ISBN: 9780080477190