Designing SQL Server 2000 Databases


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

See more details below
$39.31 price
(Save 28%)$54.95 List Price
Other sellers (Paperback)
  • All (8) from $1.99   
  • New (4) from $36.03   
  • Used (4) from $1.99   
Sending request ...


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 for NET Enterprise Servers 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

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 for NET Enterprise Servers 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

Read More Show Less

Editorial Reviews

A guidebook for Microsoft's Structured Query Language (SQL) Server 2000, the first .NET Enterprise Server available. Chapters cover the installation of the program, its scalability, security issues, backup and recovery of lost information, using XML with SQL Server, and more, each chapter opening with an introduction and closing with a list of frequently asked questions. Contains numerous tables and diagrams as well as screen shots and text prompts. Written for all levels, from the beginner programmer to the SQL Server veteran. Annotation c. Book News, Inc., Portland, OR (
Read More Show Less

Product Details

  • ISBN-13: 9781928994190
  • Publisher: Elsevier Science
  • Publication date: 1/1/2000
  • Pages: 608
  • Product dimensions: 7.00 (w) x 10.00 (h) x 1.48 (d)

Read an Excerpt

Chapter 1: SQL Server 2000 Overview and Migration Strategies


Microsoft Structured Query Language (SQL) Server 2000 is the latest generation of the popular SQL Server product line and the second release since its core reengineering that produced SQL Server 7.0, released in 1999. This latest release of SQL Server adds native Extensible Markup Language (XML) support, enhanced online analytical processing (OLAP), data-mining capabilities, platform support for Windows 2000, integration with Windows 2000 Active Directory, and numerous performance, usability, and programming enhancements. SQL Server 2000 is available in six different editions to meet all levels of application development and delivery:

SQL Server 2000 Enterprise Edition
SQL Server 2000 Standard Edition
SQL Server 2000 Personal Edition
SQL Server 2000 Developer Edition
SQL Server Desktop Engine (MSDE)
SQL Server 2000 for Windows CE Edition
To meet scalability and availability goals, SQL Server 2000 is the first release designed and built to take advantage of Windows 2000 with support for up to 32 processors and 64GB of memory running on Windows 2000 Datacenter Server. Windows 2000 Active Directory integration adds enhanced server and security management features to SQL Server. The latest version of OLAP support, now called Analysis Services, provides numerous wizards for ease of use and the setup of OLAP and new data-mining solutions. One of the more publicized additions to SQL Server is its native support for XML. SQL Server 2000 offers support for storing, using, and updating XML documents-an important requirement because XML becomes the language ofchoice for many business systems and a fundamental architecture component of Microsoft .NET.

SQL Server 2000 is the first released member of the .NET Enterprise Server family and offers numerous advantages to organizations considering migration to this new platform. Enhancements in reliability, scalability, performance, and administration, along with strong compatibility with previous versions, make this release a strong candidate for early adoption into SQL Server 7.0 environments and an immediate migration from organizations running on SQL Server 6.5. Native XML support in SQL Server 2000 will help many organizations begin implementing this technology, which is quickly becoming a standard to both external and internal systems, including e-commerce, Web application services, and line-of-business applications.

This chapter discusses the changes in SQL Server 2000 as well as assists you in understanding the direction of Microsoft Windows Distributed interNet Applications (DNA) Architecture Model toward .NET and the role of XML. You will review the available editions of SQL Server 2000 and their features and requirements so that you can choose the appropriate edition for your organization. The second half of this chapter discusses whether you should migrate to SQL Server 2000 as well as lays the groundwork for planning your migration.

Overview of SQL Server 2000: A.NET Enterprise Server

In September 2000, Microsoft officially announced its .NET Enterprise Server line and its commitment to .NET as Microsoft's application architecture model. The fundamental goal behind this new release of the company's popular server product line, now labeled .NET Enterprise Servers, is to provide simplified management, scalability, and availability throughout the enterprise, meeting the application goals of every organization and offering extensive support for .NET applications. SQL Server 2000 is the first .NET Enterprise Server available for public implementation and offers the data storage and management component of .NET services as well as a peek into the Microsoft's vision of .NET application capabilities.

Before we can see where the future will take us, it's always good to understand exactly where things came from. Microsoft SQL Server was first released as version 6.0 soon after Microsoft purchased and modified the code base to SQL Server from Sybase Corporation in 1995. Through version 6.5, released in 1996, SQL Server was accepted mainly as a departmental-scale database management system (DBMS) and lacked much of the scalability and reliability of enterpriseclass solutions offered by companies such as Oracle and Informix. Administration of the SQL Server 6.0 and 6.5 products required knowledgeable SQL Server database administrators committed to monitoring server availability, activity, and performance. For SQL Server to have the broad market reach that Microsoft aims for in most of its products and to make it a fundamental component in its then-new Windows Distributed interNet Applications (DNA) Architecture Model, Microsoft needed to address the broad range of concerns and downfalls that plagued SQL Server's acceptance in both large and small organizations. In 1999, after several years of development and complete reengineering, Microsoft released SQL Server 7.0, which offered numerous enhancements in reliability, functionality, administration, security, performance, and scalability and allowed SQL Server to become the most. popular relational database management system (RDBMS) in the market, with over 60 percent of all Web databases running on SQL Server by the end of 1999 and 70 percent of the total databases running on the Windows platform.

Soon after Microsoft launched SQL Server 7.0, several enhancements to the product, such as the XML Technology Preview, the OLAP Manager Add-In, and DTS Task Kit as well as two (now common) service pack updates, were released as downloadable additions. With the aggressive schedules and demanding markets that you and I represent, service packs are bound to continue, but all the previous additions and fixes have been refined and included in SQL Server 2000, along with countless enhancements in performance, availability, scalability, programmability, and management. SQL Server 2000 is light years ahead of the days of version 6.0 and is a required upgrade for nearly every SQL Server-based application.

The Future of Windows DNoblem is especially common with the 3Com Impact adapter running firmware version 2.02. If you think the second telephone number might be the problem, try reconfiguring your adapter to use only one of your ISDN numbers.

Drivers are not supported in Windows 98.

ISDN drivers from the ISDN version 1.0 Accelerator Pack are not supported in Windows 98. Contact your ISDN adapterc; Microsoft.NET

In 1997, Microsoft announced the Windows Distributed interNet Applications (DNA) Architecture Model, which laid the foundations for building scalable, Webbased solutions based on Microsoft's line of servers, technologies, and development tools. Emerging from the popular, two-tier (or client/server) application architecture, DNA presents a distributed n-tier architecture model incorporating Web technologies such as Microsoft's Internet Information Services (IIS), including Active Server Pages (ASP), standard Web browser software such as Internet Explorer or Netscape Navigator, protocols including HyperText Transfer Protocol (HTTP), and enabling technologies such as Component Object Model (COM) and Data Access (ActiveX Data Objects, OLE DB). Via standard Web browser software, users are allowed access to DNA applications with little if any need for configuration of the client. Application services are centrally managed and delivered from the enterprise for enhanced reliability, scalability, and performance. This popular application architecture model accounted for roughly 40 percent of all secure, transacted Web-based applications built by the end of 1999.

The DNA Architecture Model is logically divided into three layers: Presentation Services, Business Services, and Data Services. Each layer plays a specific role in the application, as depicted in Figure 1.1...

Read More Show Less

Table of Contents

Introduction xxvii
Chapter 1 SQL Server 2000 Overview and Migration Strategies 1
Introduction 2
Overview of SQL Server 2000: A .NET Enterprise Server 3
The Future of Windows DNA: Microsoft.NET 4
New and Enhanced Features of SQL Server 2000 8
XML Support 10
Development Tools and Technologies 14
Analysis Services 20
SQL Server Administration 23
Scalability and Availability 24
Data Transformation Services 27
Replication Services 28
Multiple Server Instance Support 29
Web and Internet Standards Support 31
SQL Server 2000 Versions, Features, and Requirements 32
Common Edition Requirements 33
SQL Server Licensing and Pricing 34
Enterprise Edition 35
Standard Edition 36
Personal Edition 37
Developer Edition 38
SQL Server 2000 Desktop Engine 39
SQL Server 2000 Windows CE Edition 39
Should You Migrate to SQL Server 2000? 41
How Will SQL Server 2000 Benefit My Organization? 42
Will SQL Server 2000 Fit into My Organization? 43
Steps to a Successful SQL Server Migration 43
Planning a SQL Server Migration 44
Migrating to SQL Server 2000 46
Summary 52
FAQs 54
Chapter 2 Installing and Configuring SQL Server 2000 57
Introduction 58
Planning a SQL Server Installation 59
Installation Requirements 60
Installation Options 63
Installing SQL Server 71
Standard Installation 71
Advanced Installation 75
Configuration Options and Settings 76
Summary 92
FAQs 92
Chapter 3 SQL Server Scalability and Availability 93
Introduction 94
Scaling Up vs. Scaling Out 94
TPC Benchmarks 97
SQL Server Fail-Over Clustering 98
SQL 2000 Fail-Over Clustering Architecture 99
Planning for SQL Server Clustering 99
Implementing Fail-Over Clustering 102
Distributed Partitioned Views 109
Federated Servers 109
Data Partitioning 111
Creating Distributed Partitioned Views 111
Log Shipping 115
Setting Up Log Shipping 116
Monitoring Log Shipping 120
Indexed Views 121
Requirements for an Indexed View 122
Creating an Indexed View 124
Summary 124
FAQs 125
Chapter 4 Designing and Creating SQL Server Databases 127
Introduction 128
SQL Server 2000 Architecture 128
Relational Databases 129
SQL Server System Databases 131
Physical Storage Architecture 135
SQL Server Services 139
Creating SQL Server Databases 144
Designing Your Database Solution 144
Designing the Physical Database 146
Creating and Configuring Your Database 151
Getting Started 151
Using the Create Database Wizard 153
Configuring Your Database 158
Using T-SQL to Create and Alter a Database 169
Monitoring and Maintenance 171
Database Modeling Tools 180
Entity-Relationship Diagrams 180
SQL Server Database Designer 184
Summary 186
FAQs 188
Chapter 5 Database and Server Security 189
Introduction 190
Planning SQL Server Security 190
Understanding SQL Server Security 191
Administration Access and Server Security 194
Object and Data Security 197
Network Communications Security 201
Security Options in SQL Server 202
Selecting a Security Mode 207
Logins 210
Server Roles 216
Database Users 218
Database Roles 225
Implementing Database and Server Security 231
The Scenario 231
User Authentication 232
Assigning Permissions 234
Network Communications Security 236
Summary 239
FAQs 240
Chapter 6 Administration and Active Directory Integration 243
Introduction 244
Windows 2000 Active Directory Integration 244
Registering SQL Servers in Active Directory 246
Registering Databases in Active Directory 249
SQL Replication Services and Active Directory 249
Analysis Services and Active Directory 260
Tools and Techniques for SQL Server Administration 262
Windows 2000 Active Directory 262
Microsoft Management Console 265
Moving and Copying SQL Server Databases 275
Enterprise Manager 277
Copy Database Wizard 278
Detaching and Attaching Databases 281
Linked Servers 282
Distributed Queries 284
Database Maintenance Tools 284
DBCC 285
Database Maintenance Plans 286
Automating Administrative Tasks 290
SQL Server Agent 290
Alerts and Operators 290
Summary 293
FAQs 294
Chapter 7 SQL Server Backup and Recovery 295
Introduction 296
Planning and Implementing a Successful Backup and Recovery Strategy 296
Determining Data Recovery Requirements 296
Planning for Hardware Failure 299
Selecting a Backup Strategy 302
Backup Storage 307
Creating a Recovery Strategy 317
Backup and Restore Tools and Techniques 319
The Create Database Backup Wizard 319
The Database Maintenance Plan Wizard 320
Transact-SQL 321
Backing Up SQL Server Databases 322
Restoring SQL Server Databases 344
Testing Your Backup and Recovery Strategy 354
Summary 355
FAQs 356
Chapter 8 Microsoft English Query and Full-Text Search 359
Introduction 360
Overview of English Query 360
What's New in English Query? 362
Installing English Query 364
Installation Requirements 365
Creating an English Query Application 366
Planning Your English Query Application 366
Creating an English Query Project 367
Building and Deploying Your English Query Application 376
Implementing Web-Based English Query Applications 376
Testing Your English Query Application 377
Putting It All Together 379
An Overview of Full-Text Search 381
File Filtering 381
Full-Text Search Architecture 382
Performance Considerations for Full-Text Indexes 383
Enabling Full-Text Search 387
Creating a Full-Text Catalog 387
Building the Full-Text Index 391
Querying Full-Text Indexes 393
Freetext and Freetexttable 393
Contains and Containstable 395
Administering Full-Text Catalogs and Indexes 398
Backing Up Full-Text Catalogs 399
Populating Full-Text Indexes 401
Summary 403
FAQs 404
Chapter 9 Importing and Exporting Data 407
Introduction 408
Overview of Data Import and Export Tools 408
Data Transformation Services 410
What's New in DTS? 410
Data Transformation Services Architecture 412
Security in DTS Packages 416
DTS Performance Considerations 417
Creating and Editing DTS Packages 419
DTS Import/Export Wizard 420
DTS Designer 422
Saving DTS Packages 427
Executing DTS Packages 429
The Bulk Copy Program 433
Using BCP 436
SQL-DMO BulkCopy 440
Using the BulkCopy Object 440
The BULK INSERT Command 444
Choosing a Data Import and Export Method 447
Import/Export Job Requirements 447
Existing Data Format 448
Frequency of Import or Export Task 448
Data Manipulation Tasks 448
Performance Considerations 449
Summary 449
FAQs 450
Chapter 10 SQL Server Analysis Services 453
Introduction 454
Online Analytical Processing and Data Mining 454
OLTP vs. OLAP vs. Data Warehousing 455
Data Mining 458
New Features in Analysis Services 459
OLAP Enhancements 459
Data-Mining Capabilities 461
The Analysis Services Architecture 461
Analysis Server 461
Analysis Manager 462
Cubes 464
Mining Models 465
PivotTable Service 466
Decision Support Objects 466
Installing Analysis Services 466
Analysis Services Requirements 467
Installing Analysis Services for the First Time 467
Upgrading from Earlier Versions 468
Designing and Building an OLAP Solution 469
Designing and Building a Data Warehouse 469
Creating an Analysis Services Database 474
Designing and Building Cubes 475
Defining Measures and Dimensions 480
Using Your OLAP Solution 482
Querying Cubes 482
Data Mining in SQL Server 485
Mining Models 485
Creating and Editing Data-Mining Models 486
Using Data-Mining Models 488
Security in Analysis Services 492
Users and Groups 492
Roles 492
Data Security 493
Implementing Security in Analysis Services 493
Accessing Analysis Services Over the Web 494
Configuring IIS for Analysis Services 494
Performance Tuning and Optimization 495
Usage Analysis Wizard 495
Usage-Based Optimization Wizard 496
Summary 496
FAQs 498
Chapter 11 Using XML with SQL Server 499
Introduction 500
Overview of XML and SQL Server Support 500
What Is XML? 500
The Benefits of XML 501
Working with XML 502
XML Support and Limitations in SQL Server 509
Additional XML Resources on the Web 509
HTTP and URL Query Support 510
Configuring IIS for HTTP Query Support 510
Querying SQL Server Using HTTP 512
XPath Queries 518
Overview of XPath Queries and SQL Server Limitations 518
XPath Data Types and Conversions 519
Using XPath Queries 520
Select...For XML 522
FOR XML Syntax and Use 522
Limitations of FOR XML 525
XML Views 525
XML Data-Reduced Schemas 526
Mapping XML Data to Database Tables and Columns 529
Using and Updating XML Data 534
Updategrams 534
T-SQL OPENXML Statement 536
ActiveX Data Objects 539
Summary 543
FAQs 544
Chapter 12 Database Replication Techniques and Configuration 545
Introduction 546
SQL Server Replication Architecture 546
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)