The 5 December 2005 release of SQL Server Books Online has either had new topics added or existing topics updated in the following technologies or categories.
ADOMD.NET
Integration Services Programming
Samples
Analysis Management Objects (AMO)
International Considerations
SQL Server Management Objects (SMO)
Analysis Services
Notification Services Programming
Tools and Utilities
Database Engine
Replication
Transact-SQL
Full-Text Search
Replication Programming
Tutorials
Installation
Reporting Services
UI Reference
Integration Services
Reporting Services Programming
WMI Provider for Configuration Management
ADOMD.NET Client Functionality
ADOMD.NET Client Object Architecture
ADOMD.NET Release Differences
ADOMD.NET Server Functionality
ADOMD.NET Server Object Architecture
ADOMD.NET Server Programming
Establishing Secure Connections in ADOMD.NET
Executing Commands Against an Analytical Data Source
Performing Transactions in ADOMD.NET
Retrieving Data from an Analytical Data Source
Retrieving Data Using the AdomdDataReader
Retrieving Data Using the CellSet
Retrieving Data Using the XmlReader
Retrieving Metadata from an Analytical Data Source
User Defined Functions and Stored Procedures
Working With Connections and Sessions in ADOMD.NET
Working With Schema Rowsets in ADOMD.NET
Working With the ADOMD.NET Object Model
Migrating From ADO MD To ADOMD.NET
Back to Top
AMO Data Mining Classes
AMO Fundamental Classes
AMO OLAP Classes
AMO Other Classes and Methods
AMO Security Classes
Introducing AMO Classes
Introducing AMO Concepts
Programming Administrative Tasks with AMO
Programming AMO Complementary Classes and Methods
Programming AMO Data Mining Objects
Programming AMO Fundamental Objects
Programming AMO OLAP Advanced Objects
Programming AMO OLAP Basic Objects
Programming AMO Security Objects
Requiring Client Authentication
Securing Client Communication with an Analysis Services Instance
About the Missing Indexes Feature
Available Tuning Options
Capacity Planning for tempdb
Connecting Using IPv6
Dialog Security for Event Notifications
Finding Missing Indexes
Growing and Shrinking the Buffer Pool Under NUMA
How to: Change the Service Startup Account for SQL Server (SQL Server Configuration Manager)
How to: Configure SQL Server to Use Soft-NUMA
How to: Create a Stored Procedure (SQL Server Management Studio)
How to: Delete a Stored Procedure (SQL Server Management Studio)
How to: Grant Permissions on a Stored Procedure (SQL Server Management Studio)
How to: Map TCP/IP Ports to NUMA Nodes
How to: Modify a Stored Procedure (SQL Server Management Studio)
How to: Rename a Database (SQL Server Management Studio)
How to: Rename a Stored Procedure (SQL Server Management Studio)
How to: Restart the SQL Server Agent Service (SQL Server Management Studio)
How to: Set a Database to Single-user Mode (SQL Server Management Studio)
How to: View the Definition of a Stored Procedure (SQL Server Management Studio)
How to: View the Dependencies of a Stored Procedure (SQL Server Management Studio)
Interpreting Execution Plans of Partitioned Objects
Moving System Databases
NUMA Scenarios
Querying the SQL Server System Catalog FAQ
Related Query Tuning Features
Service Account Types Supported for SQL Server Agent
SQL Server, Buffer Node Object
Troubleshooting Metadata Visibility of Distributed Partitioned Views
Troubleshooting Row Size Errors
Understanding SQL Dependencies
Unsupported Tuning Options
Advanced Considerations for Restore Sequences
Agent XPs Option
Asynchronous Database Mirroring (High-Performance Mode)
Audit Database Object Access Event Class
Audit Database Object GDR Event Class
Audit Database Object Take Ownership Event Class
Audit Database Principal Impersonation Event Class
Audit Database Scope GDR Event Class
Audit Schema Object Access Event Class
Audit Schema Object GDR Event Class
Audit Schema Object Take Ownership Event Class
Audit Server Object GDR Event Class
Audit Server Object Take Ownership Event Class
Audit Server Principal Impersonation Event Class
Audit Server Scope GDR Event Class
Audit Statement Permission Event Class
Backup Under the Bulk-Logged Recovery Model
Backup Under the Simple Recovery Model
Batches
Blocked Process Report Event Class
Building or Refreshing a Reporting Database
Building Statements at Run Time
Choosing the Recovery Model for a Database
Connecting to the SQL Server Database Engine
Considerations for Using Test Servers
Controlling the Locking Behavior for Bulk Import
Copy-Only Backups
Creating a Multiserver Environment
Creating and Modifying Identifier Columns
Creating SQL Server Agent Proxies
Data Integrity
Database Mail Architecture
Database Mirroring and Failover Clustering
Database Mirroring and Other Features and Components
Database Mirroring Transport Security
DDL Events for Use with Event Notifications
Default Client Connection Behavior
Default SQL Server Network Configuration
Designing Assemblies
Designing Event Notifications
Detaching and Attaching Databases
Detecting and Ending Deadlocks
Dropping a Database Snapshot
Ensuring a Correct Environment for a Scalable Shared Database
Estimating the Interruption of Service During Role Switching
Exchange Spill Event Class
Execution Plan Caching and Reuse
Exporting Data from or Importing Data to a Temporary Table
Factors That Can Delay Log Truncation
Forced Parameterization
Full File Backups
Guidelines and Limitations in Using XML Schema Collections on the Server
Guidelines for Optimizing Bulk Import
Guidelines for Performing Online Index Operations
Hash Warning Event Class
How Database Snapshots Work
How Differential Backups Work
How SQL Server 2005 Supports NUMA
How to: Configure SQL Server Agent Mail to Use SQL Mail (SQL Server Management Studio)
How to: Create a Maintenance Plan
How to: Create a SQL Server Agent master Job (Transact-SQL)
How to: Create a Trace (SQL Server Profiler)
How to: Create XML Input Files
How to: Detach a Database (SQL Server Management Studio)
How to: Drop a Database Snapshot (Transact-SQL)
How to: Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager)
How to: Enlist a Target Server to a Master Server (SQL Server Management Studio)
How to: Perform Exploratory Analysis
How to: Prepare a Mirror Database for Mirroring (Transact-SQL)
How to: Restore a Differential Database Backup (SQL Server Management Studio)
How to: Restore a Transaction Log Backup (SQL Server Management Studio)
How to: Revert a Database to a Database Snapshot (Transact-SQL)
How to: Set the Service Startup Account for SQL Server Agent (SQL Server Configuration Manager)
How to: Set Up a Mirror Database to Use the Trustworthy Property
How to: Set Up Database Diagram Designer (Visual Database Tools)
How to: Start a Job (SQL Server Management Studio)
How to: Upgrade a Database Using Detach and Attach (Transact-SQL)
Implementing Assemblies
Implementing Event Notifications
Importing Data in Parallel with Table Level Locking
Index Statistics
Introduction to Backup and Restore Strategies in SQL Server
Limitations on Database Snapshots
Limiting Deleted Rows by Using TOP
Lock Modes
Log Shipping
Maintenance Plan Wizard
Maintenance Plans
Troubleshooting a Full Transaction Log (Error 9002)
Managing the Transaction Log
master Database
Maximizing Availability of a Scalable Shared Database
Minimally Logged Operations
model Database
Modifying Data in Partitioned Views
Modifying Data Through a View
Monitoring Database Mirroring
msdb Database
Network Protocols, and TDS Endpoints
OLE DB Provider for Jet
Optimizing Bulk Import Performance
Optimizing tempdb Performance
Oracle Provider for OLE DB
Overview of Database Mirroring
Quorum: How a Witness Affects Database Availability
Overview of Scalable Shared Databases
Parallel Query Processing
Performing Piecemeal Restores
Physical Database Files and Filegroups
Plan Forcing Scenario: Use USE PLAN to Force an Index Union Algorithm
Possible Failures During Database Mirroring
Overview of the Recovery Models
Registration of Service Principal Name
Reorganizing and Rebuilding Indexes
Resource Database
Row Versioning Resource Usage
Running Jobs
Sample XML Format Files
Scalable Shared Databases
Securing Data and Log Files
Selecting an Account for the SQL Server Agent Service
Server Memory Options
Server Network Configuration
Setting Database Options
Setting Server Configuration Options
Specifying Physical Design Structures
SQL Native Client OLE DB Provider
SQL Writer Service
Switching from the Full or Bulk-Logged Recovery Model
Switching from the Simple Recovery Model
Tail-Log Backups
tempdb Database
Troubleshooting Database Mirroring Setup
Transaction Log Truncation
Typical Uses of Database Snapshots
Understanding and Managing the suspect_pages Table
Understanding and Managing Transaction Logs
Understanding Non-uniform Memory Access
Understanding Transaction Log Architecture
Using a Dedicated Administrator Connection
Using an XML Input File for Tuning
Using and Modifying Instances of User-defined Types
Using Extended Properties on Database Objects
Using Nested Triggers
Using SQL Server Profiler to Create and Test Plan Guides
Using the EVENTDATA Function
Viewing and Analyzing Traces with SQL Server Profiler
Viewing Database Metadata
Viewing User-defined Functions
XML Showplans
XML Construction (XQuery)
Configuring Thesaurus Files
Setting DTS Application Properties
Configuring Integration Services in a Clustered Environment
How to: Troubleshoot Side-by-Side Installations of SQL Server 2000 and SQL Server 2005 Reporting Services
Installing Reporting Services on 64-bit Computers
Upgrading dtsrun Command Lines
Using the Package Migration Wizard
Behavior Changes to Database Engine Features in SQL Server 2005
Deprecated Features in SQL Server 2005 Reporting Services
How to: Install 32-bit Reporting Services on a 64-bit Computer
Installing Reporting Services Using Setup
Installing SQL Server Analysis Services by Using Setup
Installing SQL Server Analysis Services from the Command Prompt
Installing SQL Server Integration Services
Installing SQL Server Integration Services by Using Setup
Installing SQL Server Integration Services from the Command Prompt
Running Setup to Install AdventureWorks Sample Databases and Samples
Setting Up Windows Service Accounts
SQL Server 2005 Integration Services Backward Compatibility
Creating and Running the Child Packages
Creating New Packages
Creating the Parent Package
How to: Copy a Package Using SSIS Designer
How to: Copy Package Objects
How to: Copy Project Level Items
How to: Designate Packages as Package Templates
How to: Loop through Excel Files and Tables
How to: Set Properties of Integration Services Service Using SQL Server Configuration Manager
How to: Use Values of Parent Variables in Child Packages
How to: View Log Entries in the Log Events Window
Installing Packages
Integration Services Development Enhancements
Load-Balancing Packages on Remote Servers by using SQL Server Agent
Managing Logging for Load Balanced Packages on Remote Servers
Maintenance Cleanup Task
Using Enumerated Constants in Property Expressions
Conditional Split Transformation
Creating a Deployment Utility
Creating Connection Managers
Creating Package Configurations
Creating Packages Using the SQL Server Import and Export Wizard
Data Flow Task
DataReader Source
DATEPART (SSIS)
Derived Column Transformation
Excel Connection Manager
Excel Destination
Excel Source
Execute Package Task
Fast Parse
Flat File Connection Manager
Flat File Destination
Fuzzy Grouping Transformation
Fuzzy Lookup Transformation
Handling Errors in Data
How to: Map Query Parameters to Variables in an Execute SQL Task
How to: Run a Package Using the DTExecUI Utility
Implementing Logging in Packages
Integration Services Considerations on 64-bit Computers
Integration Services Data Types
Integration Services Packages
Integration Services Variables
Lookup Transformation
Merge Join Transformation
Message Queue Task
Microsoft .NET Data Provider for mySAP Business Suite
Multiple Flat Files Connection Manager
OLE DB Command Transformation
OLE DB Destination
OLE DB Source
Percentage Sampling Transformation
Pivot Transformation
Row Sampling Transformation
Script Component
Script Task
Sort Transformation
SQL Server Destination
SQL Server Compact Edition Destination
SQRT (SSIS)
System Variables
Troubleshooting Package Performance
Unpivot Transformation
Using Checkpoints in Packages
Using Property Expressions in Packages
XML Source
Building Packages Programmatically
Creating an ODBC Destination with the Script Component
Developing Specific Types of Script Components
Enhancing an Error Output with the Script Component
Extending Packages with Custom Objects
Extending Packages with Scripting
Integration Services Error and Message Reference
Logging and Defining Log Entries in a Data Flow Component
