Cover image for Designing SQL server 2000 databases for .net enterprise servers
Title:
Designing SQL server 2000 databases for .net enterprise servers
Author:
Bordwell, Darlene.
Publication Information:
Rockland, MA : Syngress, [2001]

©2001
Physical Description:
xxx, 716 pages : illustrations ; 24 cm
General Note:
Includes index.
Language:
English
Title Subject:

Added Author:
ISBN:
9781928994190
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.C55 D47 2001 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

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

Introductionp. xxvii
Chapter 1 SQL Server 2000 Overview and Migration Strategiesp. 1
Introductionp. 2
Overview of SQL Server 2000: A .NET Enterprise Serverp. 3
The Future of Windows DNA: Microsoft.NETp. 4
New and Enhanced Features of SQL Server 2000p. 8
XML Supportp. 10
Development Tools and Technologiesp. 14
Analysis Servicesp. 20
SQL Server Administrationp. 23
Scalability and Availabilityp. 24
Data Transformation Servicesp. 27
Replication Servicesp. 28
Multiple Server Instance Supportp. 29
Web and Internet Standards Supportp. 31
SQL Server 2000 Versions, Features, and Requirementsp. 32
Common Edition Requirementsp. 33
SQL Server Licensing and Pricingp. 34
Enterprise Editionp. 35
Standard Editionp. 36
Personal Editionp. 37
Developer Editionp. 38
SQL Server 2000 Desktop Enginep. 39
SQL Server 2000 Windows CE Editionp. 39
Should You Migrate to SQL Server 2000?p. 41
How Will SQL Server 2000 Benefit My Organization?p. 42
Will SQL Server 2000 Fit into My Organization?p. 43
Steps to a Successful SQL Server Migrationp. 43
Planning a SQL Server Migrationp. 44
Migrating to SQL Server 2000p. 46
Summaryp. 52
FAQsp. 54
Chapter 2 Installing and Configuring SQL Server 2000p. 57
Introductionp. 58
Planning a SQL Server Installationp. 59
Installation Requirementsp. 60
Installation Optionsp. 63
Installing SQL Serverp. 71
Standard Installationp. 71
Advanced Installationp. 75
Configuration Options and Settingsp. 76
Summaryp. 92
FAQsp. 92
Chapter 3 SQL Server Scalability and Availabilityp. 93
Introductionp. 94
Scaling Up vs. Scaling Outp. 94
TPC Benchmarksp. 97
SQL Server Fail-Over Clusteringp. 98
SQL 2000 Fail-Over Clustering Architecturep. 99
Planning for SQL Server Clusteringp. 99
Implementing Fail-Over Clusteringp. 102
Distributed Partitioned Viewsp. 109
Federated Serversp. 109
Data Partitioningp. 111
Creating Distributed Partitioned Viewsp. 111
Log Shippingp. 115
Setting Up Log Shippingp. 116
Monitoring Log Shippingp. 120
Indexed Viewsp. 121
Requirements for an Indexed Viewp. 122
Creating an Indexed Viewp. 124
Summaryp. 124
FAQsp. 125
Chapter 4 Designing and Creating SQL Server Databasesp. 127
Introductionp. 128
SQL Server 2000 Architecturep. 128
Relational Databasesp. 129
SQL Server System Databasesp. 131
Physical Storage Architecturep. 135
SQL Server Servicesp. 139
Creating SQL Server Databasesp. 144
Designing Your Database Solutionp. 144
Designing the Physical Databasep. 146
Creating and Configuring Your Databasep. 151
Getting Startedp. 151
Using the Create Database Wizardp. 153
Configuring Your Databasep. 158
Using T-SQL to Create and Alter a Databasep. 169
Monitoring and Maintenancep. 171
Database Modeling Toolsp. 180
Entity-Relationship Diagramsp. 180
SQL Server Database Designerp. 184
Summaryp. 186
FAQsp. 188
Chapter 5 Database and Server Securityp. 189
Introductionp. 190
Planning SQL Server Securityp. 190
Understanding SQL Server Securityp. 191
Administration Access and Server Securityp. 194
Object and Data Securityp. 197
Network Communications Securityp. 201
Security Options in SQL Serverp. 202
Selecting a Security Modep. 207
Loginsp. 210
Server Rolesp. 216
Database Usersp. 218
Database Rolesp. 225
Implementing Database and Server Securityp. 231
The Scenariop. 231
User Authenticationp. 232
Assigning Permissionsp. 234
Network Communications Securityp. 236
Summaryp. 239
FAQsp. 240
Chapter 6 Administration and Active Directory Integrationp. 243
Introductionp. 244
Windows 2000 Active Directory Integrationp. 244
Registering SQL Servers in Active Directoryp. 246
Registering Databases in Active Directoryp. 249
SQL Replication Services and Active Directoryp. 249
Analysis Services and Active Directoryp. 260
Tools and Techniques for SQL Server Administrationp. 262
Windows 2000 Active Directoryp. 262
Microsoft Management Consolep. 265
Moving and Copying SQL Server Databasesp. 275
Enterprise Managerp. 277
Copy Database Wizardp. 278
Detaching and Attaching Databasesp. 281
Linked Serversp. 282
Distributed Queriesp. 284
Database Maintenance Toolsp. 284
DBCCp. 285
Database Maintenance Plansp. 286
SQL-DMOp. 288
Automating Administrative Tasksp. 290
SQL Server Agentp. 290
Alerts and Operatorsp. 290
Summaryp. 293
FAQsp. 294
Chapter 7 SQL Server Backup and Recoveryp. 295
Introductionp. 296
Planning and Implementing a Successful Backup and Recovery Strategyp. 296
Determining Data Recovery Requirementsp. 296
Planning for Hardware Failurep. 299
Selecting a Backup Strategyp. 302
Backup Storagep. 307
Creating a Recovery Strategyp. 317
Backup and Restore Tools and Techniquesp. 319
The Create Database Backup Wizardp. 319
The Database Maintenance Plan Wizardp. 320
Transact-SQLp. 321
Backing Up SQL Server Databasesp. 322
Restoring SQL Server Databasesp. 344
Testing Your Backup and Recovery Strategyp. 354
Summaryp. 355
FAQsp. 356
Chapter 8 Microsoft English Query and Full-Text Searchp. 359
Introductionp. 360
Overview of English Queryp. 360
What's New in English Query?p. 362
Installing English Queryp. 364
Installation Requirementsp. 365
Creating an English Query Applicationp. 366
Planning Your English Query Applicationp. 366
Creating an English Query Projectp. 367
Building and Deploying Your English Query Applicationp. 376
Implementing Web-Based English Query Applicationsp. 376
Testing Your English Query Applicationp. 377
Putting It All Togetherp. 379
An Overview of Full-Text Searchp. 381
File Filteringp. 381
Full-Text Search Architecturep. 382
Performance Considerations for Full-Text Indexesp. 383
Enabling Full-Text Searchp. 387
Creating a Full-Text Catalogp. 387
Building the Full-Text Indexp. 391
Querying Full-Text Indexesp. 393
Freetext and Freetexttablep. 393
Contains and Containstablep. 395
Administering Full-Text Catalogs and Indexesp. 398
Backing Up Full-Text Catalogsp. 399
Populating Full-Text Indexesp. 401
Summaryp. 403
FAQsp. 404
Chapter 9 Importing and Exporting Datap. 407
Introductionp. 408
Overview of Data Import and Export Toolsp. 408
Data Transformation Servicesp. 410
What's New in DTS?p. 410
Data Transformation Services Architecturep. 412
Security in DTS Packagesp. 416
DTS Performance Considerationsp. 417
Creating and Editing DTS Packagesp. 419
DTS Import/Export Wizardp. 420
DTS Designerp. 422
Saving DTS Packagesp. 427
Executing DTS Packagesp. 429
The Bulk Copy Programp. 433
Using BCPp. 436
SQL-DMO BulkCopyp. 440
Using the BulkCopy Objectp. 440
The BULK INSERT Commandp. 444
Using BULK INSERTp. 445
Choosing a Data Import and Export Methodp. 447
Import/Export Job Requirementsp. 447
Existing Data Formatp. 448
Frequency of Import or Export Taskp. 448
Data Manipulation Tasksp. 448
Performance Considerationsp. 449
Summaryp. 449
FAQsp. 450
Chapter 10 SQL Server Analysis Servicesp. 453
Introductionp. 454
Online Analytical Processing and Data Miningp. 454
OLTP vs. OLAP vs. Data Warehousingp. 455
Data Miningp. 458
New Features in Analysis Servicesp. 459
OLAP Enhancementsp. 459
Data-Mining Capabilitiesp. 461
The Analysis Services Architecturep. 461
Analysis Serverp. 461
Analysis Managerp. 462
Cubesp. 464
Mining Modelsp. 465
PivotTable Servicep. 466
Decision Support Objectsp. 466
Installing Analysis Servicesp. 466
Analysis Services Requirementsp. 467
Installing Analysis Services for the First Timep. 467
Upgrading from Earlier Versionsp. 468
Designing and Building an OLAP Solutionp. 469
Designing and Building a Data Warehousep. 469
Creating an Analysis Services Databasep. 474
Designing and Building Cubesp. 475
Defining Measures and Dimensionsp. 480
Using Your OLAP Solutionp. 482
Querying Cubesp. 482
Data Mining in SQL Serverp. 485
Mining Modelsp. 485
Creating and Editing Data-Mining Modelsp. 486
Using Data-Mining Modelsp. 488
Security in Analysis Servicesp. 492
Users and Groupsp. 492
Rolesp. 492
Data Securityp. 493
Implementing Security in Analysis Servicesp. 493
Accessing Analysis Services Over the Webp. 494
Configuring IIS for Analysis Servicesp. 494
Performance Tuning and Optimizationp. 495
Usage Analysis Wizardp. 495
Usage-Based Optimization Wizardp. 496
Summaryp. 496
FAQsp. 498
Chapter 11 Using XML with SQL Serverp. 499
Introductionp. 500
Overview of XML and SQL Server Supportp. 500
What Is XML?p. 500
The Benefits of XMLp. 501
Working with XMLp. 502
XML Support and Limitations in SQL Serverp. 509
Additional XML Resources on the Webp. 509
HTTP and URL Query Supportp. 510
Configuring IIS for HTTP Query Supportp. 510
Querying SQL Server Using HTTPp. 512
XPath Queriesp. 518
Overview of XPath Queries and SQL Server Limitationsp. 518
XPath Data Types and Conversionsp. 519
Using XPath Queriesp. 520
Select...For XMLp. 522
FOR XML Syntax and Usep. 522
Limitations of FOR XMLp. 525
XML Viewsp. 525
XML Data-Reduced Schemasp. 526
Mapping XML Data to Database Tables and Columnsp. 529
Using and Updating XML Datap. 534
Updategramsp. 534
T-SQL OPENXML Statementp. 536
ActiveX Data Objectsp. 539
Summaryp. 543
FAQsp. 544
Chapter 12 Database Replication Techniques and Configurationp. 545
Introductionp. 546
SQL Server Replication Architecturep. 546
Publisherp. 546
Subscriberp. 547
Distributorp. 547
Publicationp. 547
SQL Server Agentp. 548
Replication Agentsp. 548
New Replication Features in SQL Serverp. 549
Replication Compatibilityp. 550
Previous Versions of SQL Serverp. 550
Heterogeneous Publishers and Subscribersp. 551
Designing for Database Replicationp. 552
Replication Requirementsp. 552
Data Locationp. 552
Data Modificationp. 552
Connection Bandwidth and Availabilityp. 553
Application and Database Design Considerationsp. 553
Replication Methods in SQL Serverp. 560
Transactional Replicationp. 560
Merge Replicationp. 561
Snapshot Replicationp. 563
Selecting a Replication Methodp. 564
Configuring SQL Server Replicationp. 565
Enabling Server Publishingp. 565
Creating Publicationsp. 566
Adding Subscribersp. 569
Replicating Data Over the Internetp. 571
Dealing with Replication Conflictsp. 575
Viewing Conflictsp. 577
Resolving Conflictsp. 577
SQL Server CE Edition Replication Featuresp. 580
Windows CE Subscribersp. 581
Replication and Active Directory Integrationp. 582
Registering Publications in Active Directoryp. 582
Replication Performance Considerationsp. 585
Replication Backup Strategiesp. 588
Summaryp. 594
FAQsp. 595
Chapter 13 Programming Tools and Technologies in SQL Serverp. 597
Introductionp. 598
Overview of SQL Server Programmingp. 598
New Programming Features in SQL Server 2000p. 599
Data Typesp. 600
Query Analyzerp. 604
User-Defined Functionsp. 609
Referential Integrity Enhancementsp. 613
Trigger Enhancementsp. 614
Indexed Viewsp. 617
Meta Data Servicesp. 622
Transact-SQLp. 624
Data Definition Languagep. 625
Data Manipulation Languagep. 626
Data Control Languagep. 631
Data Access Tools and Technologiesp. 633
Command-Line Utilitiesp. 633
ADO, OLE DB, and ODBCp. 634
Programming Administrative Tasksp. 639
Distributed Management Objectsp. 640
Namespacesp. 642
Analysis Services Programmingp. 643
DTS Programmingp. 645
Replication Programmingp. 646
Meta Data Services Programmingp. 647
Summaryp. 648
FAQsp. 649
Chapter 14 Performance-Tuning Tools and Techniquesp. 651
Introductionp. 652
Partitioning Data and Federated Database Serversp. 652
Overviewp. 653
Designing Your Tablesp. 656
Configuring the Serversp. 657
Creating the Viewp. 659
Optimizing Query Performancep. 659
Understanding Indexesp. 660
Types of Indexesp. 661
Optimizing Database Performance with SQL Profilerp. 665
Index Tuning Wizardp. 668
SQL Query Analyzerp. 669
Optimizing Server Performancep. 673
Hardware Configurationp. 674
Software Configurationp. 678
Performance Monitorp. 684
Summaryp. 688
FAQsp. 690
Indexp. 695

Google Preview