Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

DAC (dedicated administrator connection)

data collection

     Service Broker solutions

Data Conversion transformation

data encryption

     asymmetric keys

     key management

         symmetric keys 2nd 3rd 4th

     symmetric keys 2nd 3rd 4th

data explosion

data flow engine (SSIS)

Data Flow task (SSIS)

data flow tasks

     source adapters

data marts

data mining

     Association algorithm

     Naïve Bayes algorithm

     neural network algorithm

     sequence clustering

     time series algorithm

Data Mining Model Training transformation

Data Mining Query transformation

Data Mining Wizard

data source views

data sparsity

data types

     xml 2nd 3rd

data warehousing

     ETL 2nd

data-flow tasks

     destination adapters

     source adapters

     transformations

data-oriented tasks

Database Mail 2nd 3rd 4th

     configuring 2nd 3rd 4th

     monitoring 2nd

Database Maintenance tasks 2nd

database master keys

     creating

     encryption

database mirroring 2nd 3rd

     benefits of 2nd 3rd

     configuring 2nd

     monitoring 2nd

     operation modes

         asynchronous mode 2nd

         synchronous mode 2nd

     pausing

     server instances

     split-brain scenario

database snapshot

database snapshots

     copy-on-write operation

     creating 2nd

     of mirrored databases

     recovering deleted tables 2nd 3rd

     sparse files 2nd

Database Tuning Advisor

DATE CORRELATION OPTIMIZATION option 2nd

DBAs

     performing developer responsibilities

DDL

     triggers

DDL triggers

     T-SQL enhancements 2nd 3rd 4th 5th 6th 7th

deadlock graphs 2nd 3rd 4th 5th 6th

deadlock information, viewing

Debug window (BIDS)

declaring

     variables of xml data type

decrypting data 2nd 3rd

Dedicated Administrative Console feature

dedicated administrator connections 2nd

default schema 2nd 3rd 4th 5th

defragmenting indexes

DENSE RANK function

DENSE RANK ranking function 2nd

dependencies of assemblies

     viewing

deprecated features 2nd

Derived transformation

design goals of CLR hosting in SQL Server 2005 2nd

designing

     packages 2nd 3rd 4th 5th 6th 7th

     SSIS packages

         logging

         SSIS expressions

         SSIS Object model 2nd 3rd 4th

destination adapters

Developer Edition

dialog

dialog conversations 2nd

     starting 2nd

     terminating

dialog security

Dimension Processing transformation

dimension-level security 2nd

dimensions

     enhancements to Analysis Services 2005 2nd

     fact dimensions

     many-to-many

     member properties

     members

     multiple hierarchy dimensions

     reference dimensions

     virtual

disabling

     Service Broker 2nd

disabling SQL authenticated logins 2nd

disconnected editing

discontinued features 2nd

Discover method (XMLA)

distributing

     server-side processing

DMVs

     monitoring SQLCLR activity 2nd

DMVs (dynamic management views)

     monitoring Service Broker 2nd 3rd

DRI (declarative referential integrity) actions 2nd 3rd

dropping assemblies from database

DSO (Decision Support Objects) 2nd

DSVs (data source views)

DTA 2nd

     versus Index Tuning Wizard

DTA (Database Engine Tuning Advisor)

DTA (Database Tuning Advisor) 2nd 3rd 4th 5th 6th 7th 8th 9th

DTExec

DTExecUI

DTMF (Distributed Management Task Force)

DTS (Data Transformation Services)

DTS 2000 packages

     migrating to SSIS 2nd 3rd

DTS runtime engine

Dynamic AWE 2nd

dynamic management objects 2nd 3rd 4th 5th 6th

dynamic management views 2nd