ADO.NET Primer
Explains the benefits of using ADO.NET with SQL Server 2000. (20 printed pages)

Analysis Services: Choosing Dimension Types in SQL Server 2000 Analysis Services
This paper describes how and when to use the variety of dimension types available in Microsoft SQL Server 2000 Analysis Services. (24 printed pages)

Analysis Services: DISTINCT COUNT, Basket Analysis, and Solving the Multiple Selection of Members Problem
This article discusses ways to meet information demands and take full advantage of Analysis Services 2000 by illustrating the use of calculated members and multidimensional expressions (MDX). (10 printed pages)

Analysis Services: Optimizing Cube Performance Using Microsoft SQL Server 2000 Analysis Services
This paper discusses the design and implementation of a series of test scenarios that include building and querying cubes using Microsoft SQL Server 2000 and Analysis Services. (21 pages)

Analysis Services: Performance Implications of the Architecture
Targeted for advanced users, this paper outlines the internal implementation of the Analysis Services 2000 component and relates this implementation to the performance experienced by users. (18 printed pages)

Analysis Services: Semiadditive Measures and Inventory Snapshots
Focusing on a classic inventory problem, this article describes the implementation techniques of semiadditive measures in online analytical processing. (10 printed pages)

Arabic Language Support in Microsoft SQL Server 2000
Microsoft SQL Server 2000 supports Arabic data in Unicode and non-Unicode formats. Get information about the Arabic language code page, collations, components, and functions, as well as feature-specific information concerning setup, administration, replication, data transformation, and more. (39 printed pages)

Best Practices for Business Intelligence Using the Microsoft Data Warehousing Framework
Discover best practices and suggestions for working with Microsoft SQL Server and Microsoft Analysis Services for analytic applications. These practices and suggestions have been compiled from answers to questions submitted by developers and customers, and cover topics ranging from dimensional modeling to designing OLAP cubes and writing MDX expressions. This is not an introductory paper. (25 pages)

Best Practices for Using DTS for Business Intelligence Solutions
Discover the best practices for using DTS within the Data Warehousing Framework to capture and present data as Business Intelligence solutions. (108 pages)

Bitmaps in Microsoft SQL Server 2000
Microsoft SQL Server has been using bitmaps internally to speed up query execution since version 7.0. With the introduction of new operators in SQL Server 2000, further bitmap filtering techniques can now be applied for even faster query results from large data sets. (4 printed pages)

Building Search Applications for the Web Using Microsoft SQL Server 2000 Full-Text Search
Learn how to best utilize SQL Server 2000's Full-Text Search. This article includes several tips and tricks for maximum throughput and performance. (17 printed pages)

Code Access Security in SQL Server 2000 Reporting Services
This document outlines the new code access security policies of Microsoft® SQL Server™ 2000 Reporting Services. (15 printed pages)

Connection Pooling with SQL Server 2000 Analysis Services
Learn how to use the connection pooling objects included with the Microsoft XML for Analysis Provider to develop scalable client and Web applications for Microsoft SQL Server 2000 Analysis Services. (11 printed pages)

Creating Merge Replication Custom Conflict Resolvers Using Visual Basic
This article describes how to create a Visual Basic application for merge replication that will handle both conflict and non-conflict changes between the affected tables. The article documents a .DLL that, when referenced from the Visual Basic project, contains many methods that enable the developer to gather information from the Publisher and Subscriber sites to successfully resolve conflicting data and place the correct data at both locations. (39 printed pages)

Data Transformation Services (DTS) in Microsoft SQL Server 2000
Database administrators often import, export, and transform data in support of tasks such as data consolidation, archiving, and analysis; for application development purposes; and for database or server upgrades. Data Transformation Services (DTS) in SQL Server 2000 provides a set of graphical tools and programmable objects to help administrators and developers solve data movement problems, including the extraction, transformation, and consolidation of data from disparate sources to single or multiple destinations.

Data Warehouse Design Considerations
Data warehousing is one of the more powerful tools available to support a business enterprise. Learn how to design and implement a data warehouse database with Microsoft SQL Server 2000. (25 printed pages)

Database Architecture: The Storage Engine
This article provides insight into the inner workings of SQL Server architecture. It covers database engine enhancements, providing usage tips and pointers to more information. Understanding depth information about the SQL Server engines can help a Database Administrator (Database System Engineer) take greater advantage of SQL Server when designing, building or enhancing database systems. Although targeted at database professionals, this material may also be useful from an educational or marketing perspective. (21 printed pages)

Deployment Considerations for the Voicemail .NET Alerts Quick Start Kit on Notification Services
This article describes three common deployment options used with the Voicemail .NET Alerts quick start kit, which is developed using Microsoft SQL Server Notification Services. You'll learn about the configuration details associated with each deployment option, as well as Notification Services architecture basics and security considerations. By the end of the article, you should be able to identify the appropriate deployment option for your environment, and be familiar with the requirements for that configuration. (23 printed pages)

Developing Effective Decision Support Objects (DSO) Solutions with Microsoft SQL Server 2000 Analysis Services
This paper describes how to effectively develop custom applications using Decision Support Objects (DSO) in Microsoft SQL Server 2000 Analysis Services by providing practical advice in real-world situations. (9 printed pages)

Diagnosing and Troubleshooting Slow Partitioned Merge Processes
Learn how to achieve scalable, high-performance merge replication applications. (29 printed pages)

DTS Programming Techniques Used in Microsoft SQL Server Accelerator for Business Intelligence
Learn about the Data Transformation Services (DTS) programming techniques used in SQL Server Accelerator for Business Intelligence (BI Accelerator). Using these techniques, the Microsoft BI Practices team created an extensible data movement system for analytical applications that developers can extend and database administrators (DBAs) can manage. (20 printed pages)

Embedding MSDE 2000 Setup into the Setup of Custom Applications
Many software developers want to embed data storage within their custom applications. Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) enables developers to do this. This document describes how to distribute MSDE 2000 with a custom application by embedding MSDE 2000 Setup within the setup program of the custom application. (8 printed pages)

Evolution of the SQL Server Programming Model from ADO to ADO.NET 2.0
Get an annotated overview of the data access layers available today that work with SQL Server, including ADO, the XML interface of SQL Server 2000 (SQLXML), ADO.NET, and the upcoming ADO.NET 2.0. (14 printed pages)

Identifying Common Administrative Issues for Microsoft SQL Server 2000
This article describes stored procedures that can be used to identify server and database configurations outside the recommended configuration parameters for Microsoft SQL Server 2000, as well as to troubleshoot blocking issues. (19 printed pages)

Implementing Referential Integrity and Cascading Actions
This article is a chapter excerpt from the book Advanced Transact-SQL for SQL Server 2000 from APress Books. This chapter covers the use of declarative referential integrity as well as the use of triggers to maintain data integrity. (42 printed pages)

Implementing the XML for Analysis Provider for SQL Server 2000 Analysis Services
See how to install the XML for Analysis Provider for SQL Server 2000 and implement XML for Analysis client applications. (12 printed pages)

Improved Web Connectivity in Microsoft SQL Server 2000 Analysis Services
Describes the installation, implementation, and behavior of HTTP connectivity in SQL Server 2000 Analysis Services Service Pack 3. (21 printed pages)

Improving Performance with SQL Server 2000 Indexed Views
This document describes the new indexed views capability of SQL Server 2000 Enterprise Edition. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed. (17 printed pages)

Index Tuning Wizard for Microsoft SQL Server 2000
This article describes the Index Tuning Wizard in Microsoft SQL Server 2000. The Index Tuning Wizard simplifies the task of identifying which indexes to create in a table and also optionally generates scripts to create them by analyzing a user-supplied workload. Various modes are offered for tuning both indexes and indexed views. (9 printed pages)

Inside the SQLXML Virtual Directory Structure
Introduces the SQLXML tier, a combination of XML-based communication to Microsoft SQL Server through an Internet Information Services (IIS) virtual directory. (14 printed pages)

Integrating Analysis Services with Reporting Services
Create a compelling solution for your customer that defines and manages great-looking Analysis Services reports, and quickly answers analytical questions to improve traditional reporting scenarios. (33 printed pages)

International Features in Microsoft SQL Server 2000
This article introduces Microsoft SQL Server developers to the international features of SQL Server 2000. Topics covered include an explanation of Unicode, SQL Server international data types, and key issues regarding implementation. (57 printed pages)

Microsoft Reporting Services in Action: Extending Microsoft SQL Server 2000 Reporting Services with Custom Code
This article presents an excerpt from the book, Microsoft Reporting Services in Action, by Teodor Lachev. Learn how to implement advanced report functionality using custom code. (28 printed pages)

Microsoft SQL Server 2000 as a Dimensionally Friendly System
This document describes how the Microsoft SQL Server 2000 Data Warehouse technologies map to the twenty criteria for a Dimensionally Friendly System, as characterized by Ralph Kimball. (20 printed pages)

Microsoft SQL Server 2000 Distributed Queries: OLE DB Connectivity
This document describes how the Microsoft SQL Server 2000 query processor interacts with an OLE DB provider to enable distributed and heterogeneous queries. It is intended primarily for OLE DB provider developers, and assumes a solid understanding of the OLE DB specification. (35 printed pages)

Microsoft SQL Server 2000 Scalability Project--Server Consolidation
Learn about a common scenario of server consolidation, where a single system hosts many databases with a relatively small number of users per database. The effects of these parameters are studied on an actual application called the "PACE," a financial application from Microsoft bCentral. (14 printed pages)

Middle Tier Application Data Caching with SQL Server 2000
How to use Microsoft SQL Server 2000 to construct and maintain data copies in cache solutions. (17 printed pages)

Moving Your Access 2002 Database to SQL Server
Use this features comparison in preparation for migrating your Access 2002 database back end to SQL Server 2000. (37 printed pages)

Notification Services Capacity Planning and Performance Tuning
Discover performance data for standard Notification Services components on three common system designs. When you complete this document, you will have a clear idea of the capabilities of Notification Services, common performance bottlenecks, and ways that you can design and test your own systems and Notification Services applications for optimal performance. (30 printed pages)

Notification Services Quick Start Guide for Sample Installation
Microsoft SQL Server Notification Services provides four sample applications that show how to use its various features: Flight, Weather, Stock, and Realtor. (5 printed pages)

OLAP Distinct Counts and Performance Analysis
Learn techniques to answer useful Distinct Counts business questions by using the Sales and Marketing scenario and Analysis Services 2000 to learn about performance characteristics of Analysis Services 2000 when dealing with Distinct Counts using a multiprocessor ES7000 server. (28 printed pages)

Optimizing SQLXML Performance
How to optimize SQLXML performance for databases, including SQL Server 2000. (12 printed pages)

Optimizing Cell Writeback in Microsoft SQL Server 2000 Analysis Services
Learn about improvements in cell writeback, a key feature of SQL Server 2000 Analysis Services, and learn how to optimize cell writeback performance. (6 printed pages)

Preserving Client-Server Data Integrity with Unicode and Microsoft SQL Server 2000
Learn about preserving the integrity of character data as it moves between client applications and SQL Server 2000. The particular focus is such data transmission in a global setting that may include a mix of Unicode and non-Unicode code pages. Topics include an explanation of Unicode and its impact on storage and performance, client-server data flow programming issues, and working with Data Transformation Services, bcp, BULK INSERT, and the XML functionality in SQL Server 2000. (17 printed pages)

Query Recompilation in SQL Server 2000
How to understand and consider the implications of query recompilation during the application development cycle. (7 printed pages)

Registry Entries for Microsoft SQL Server 2000 Analysis Services
This paper describes the registry entries that control the behavior of the Microsoft® SQL Server™ 2000 Analysis Services server, and how they can be used to optimize performance during OLAP and data mining operations. (48 printed pages)

SmallLibrary Sample: Incorporating Notification ServicesDemonstrates how adding Microsoft SQL Server Notification Services as a feature can enhance an existing application. Gives an overview of an existing, simplified library management Web application, and the process of designing the notification service features for the library. (23 printed pages)

SQLXML Managed Classes
How to use SQLXML Managed Classes for .NET code to retrieve XML from a Microsoft SQL Server database or to generate XML on the client side, using ad hoc queries, stored procedures, annotated schemas with XPath, or XML templates. (19 printed pages)

Statistics Used by the Query Optimizer in Microsoft SQL Server 2000
Describes what data is collected, where it is stored, and which commands create, update, and delete statistics about indexes and column data stored in the Microsoft SQL Server 2000 database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving data and performing INSERT, SELECT, DELETE or UPDATE queries. It also outlines how SQL Server default statistics creation and maintenance settings can be changed on different levels (index, table, and database). (15 printed pages)

The Reality of Real-time OLAP
Discover the functionality and implementation of real-time OLAP, a key feature of SQL Server 2000 Analysis Services. (11 printed pages)

Transactional Replication Performance Tuning and Optimization
This paper examines performance in transactional replication and demonstrates ways in which you can improve the performance of your applications. (30 printed pages)

Tutorial: Creating an Ad Hoc Report Application with Reporting ServicesNew to .NET programming or Reporting Services? Get step-by-step instruction on creating a .NET application to create and publish reports using the Reporting Services API. (43 printed pages)

Using an ADO.NET DataSet as a Reporting Services Data Source
Learn how to build a data processing extension for Reporting Services that enables you to use an ADO.NET DataSet as a data source. (21 printed pages)

Using Forms Authentication in Reporting Services
Learn about Reporting Services security extensions with a primary focus on Forms Authentication. In addition, download and deploy a sample Forms Authentication extension for Reporting Services. (23 printed pages)

Using Partitions in a Microsoft SQL Server 2000 Data Warehouse
This article describes how to use partitions to improve the manageability, query performance, and load speed of data warehouses in SQL Server 2000 Enterprise Edition. Horizontal partitioning of dimensional schema, both in the relational database and in Analysis Services cubes, is addressed.

Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
Experiment with the security solutions presented here using SSL for SQL Server 2000 Reporting Services before implementing security on your network. (37 printed pages)

Using SQL Server 2000 Technologies to Deliver Data
Learn how to use Notification Services and Reporting Services in SQL Server 2000 to generate and deliver data to your users when they want it. (12 printed pages)