Designing SQL Server 2000 Databases
Regular price
19.250 KD
inc. VAT
Couldn't load pickup availability
Table of contents
- DESIGNING SQL SERVER 2000 DATABASES FOR .NET ENTERPRISE SERVERSiii
- Copyrightiv
- Acknowledgmentsv
- From Global Knowledgevi
- Contributorsvii
- Technical Editor and Contributorx
- Contentsxi
- Introductionxxvii
- Chapter 1 SQL Server 2000 Overview and Migration Strategies1
- Introduction2
- Overview of SQL Server 2000: A .NET Enterprise Server3
- New and Enhanced Featuresof SQL Server 20008
- SQL Server 2000 Versions, Features, and Requirements32
- Should You Migrate to SQL Server 2000?41
- Steps to a Successful SQL Server Migration43
- Summary52
- FAQs54
- Chapter 2 Installing and Configuring SQL Server 200057
- Introduction58
- Planning a SQL Server Installation71
- Installing SQL Server71
- Configuration Options and Settings76
- Summary92
- FAQs92
- Chapter 3 SQL Server Scalability and Availability93
- Introduction94
- Scaling Up vs. Scaling Out94
- SQL Server Fail-Over Clustering98
- Distributed Partitioned Views109
- Log Shipping115
- Indexed Views121
- Summary124
- FAQs125
- Chapter 4 Designing and Creating SQL Server Databases127
- Introduction128
- SQL Server 2000 Architecture128
- Creating SQL Server Databases144
- Creating and Configuring Your Database151
- Database Modeling Tools180
- Summary186
- FAQs188
- Chapter 5 Database and Server Security189
- Introduction190
- Planning SQL Server Security190
- Security Options in SQL Server202
- Implementing Database and Server Security231
- Summary239
- FAQs240
- Chapter 6 Administration and Active Directory Integration243
- Introduction244
- Windows 2000 Active Directory Integration244
- Tools and Techniques for SQL Server Administration262
- Moving and Copying SQL Server Databases275
- Linked Servers282
- Database Maintenance Tools284
- Automating Administrative Tasks290
- Summary293
- FAQs294
- Chapter 7 SQL Server Backup and Recovery295
- Introduction296
- Planning and Implementing a Successful Backup and Recovery Strategy296
- Backup and Restore Tools and Techniques319
- Backing Up SQL Server Databases322
- Restoring SQL Server Databases344
- Testing Your Backup and Recovery Strategy354
- Summary355
- FAQs356
- Chapter 8 Microsoft English Query and Full-Text Search359
- Introduction360
- Overview of English Query360
- Installing English Query364
- Creating an English Query Application366
- Building and Deploying Your English Query Application376
- An Overview of Full-Text Search381
- Enabling Full-Text Search387
- Querying Full-Text Indexes393
- Administering Full-Text Catalogs and Indexes398
- Summary403
- FAQs404
- Chapter 9 Importing and Exporting Data407
- Introduction408
- Overview of Data Import and Export Tools408
- Data Transformation Services410
- Creating and Editing DTS Packages419
- Executing DTS Packages429
- The Bulk Copy Program433
- SQL-DMO BulkCopy440
- The BULK INSERT Command444
- Choosing a Data Import and Export Method447
- Summary449
- FAQs450
- Chapter 10 SQL Server Analysis Services453
- Introduction454
- Online Analytical Processing and Data Mining454
- New Features in Analysis Services459
- The Analysis Services Architecture461
- Installing Analysis Services466
- Designing and Building an OLAP Solution469
- Designing and Building Cubes475
- Defining Measures and Dimensions480
- Using Your OLAP Solution482
- Data Mining in SQL Server485
- Security in Analysis Services492
- Accessing Analysis Services Over the Web494
- Performance Tuning and Optimization495
- Summary496
- FAQs498
- Chapter 11 Using XML with SQL Server499
- Introduction500
- Overview of XML and SQL Server Support500
- HTTP and URL Query Support510
- XPath Queries518
- Select…For XML522
- XML Views525
- Using and Updating XML Data534
- Summary543
- FAQs544
- Chapter 12 Database Replication Techniques and Configuration545
- Introduction546
- SQL Server Replication Architecture546
- Replication Compatibility550
- Designing for Database Replication552
- Replication Methods in SQL Server560
- Configuring SQL Server Replication565
- Dealing with Replication Conflicts575
- SQL Server CE Edition Replication Features580
- Replication and Active Directory Integration582
- Replication Performance Considerations585
- Replication Backup Strategies588
- Summary594
- FAQs595
- Chapter 13 Programming Tools and Technologies in SQL Server597
- Introduction598
- Overview of SQL Server Programming598
- New Programming Features in SQL Server 2000599
- Transact-SQL624
- Data Access Tools and Technologies633
- Programming Administrative Tasks639
- DTS Programming645
- Replication Programming646
- Meta Data Services Programming647
- Summary648
- FAQs649
- Chapter 14 Performance-Tuning Tools and Techniques651
- Introduction652
- Partitioning Data and Federated Database Servers652
- Optimizing Query Performance659
- Optimizing Database Performance with SQL Profiler665
- Optimizing Server Performance673
- Summary688
- FAQs689
- Index695
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
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