Designing SQL Server 2000 Databases - 1st Edition - ISBN: 9781928994190, 9780080477190

Designing SQL Server 2000 Databases

1st Edition

Authors: Syngress
Paperback ISBN: 9781928994190
eBook ISBN: 9780080477190
Imprint: Syngress
Published Date: 23rd January 2001
Page Count: 608
Tax/VAT will be calculated at check-out
51.95
31.99
39.95
Unavailable
Compatible Not compatible
VitalSource PC, Mac, iPhone & iPad Amazon Kindle eReader
ePub & PDF Apple & PC desktop. Mobile devices (Apple & Android) Amazon Kindle eReader
Mobi Amazon Kindle eReader Anything else

Institutional Access


Description

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

Key Features

  • 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

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

Details

No. of pages:
608
Language:
English
Copyright:
© Syngress 2001
Published:
Imprint:
Syngress
eBook ISBN:
9780080477190
Paperback ISBN:
9781928994190

About the Author