D

Index

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

-d option (SQLCMD)
DACs (dedicated administrator connections) 2nd
data
     exporting 2nd
     importing
         BCP 2nd
         bulk imports
         SSIS
data authoring
     BCP
         architecture
         bulk import optimizations
         command syntax
         error handling
         exporting data
         exporting/importing example
         format files
         importing data
         improvements
         new features
         parameters
     Query Editor
         architecture
         Database Engine support
         execution options
         fonts/colors
         Grid Control
         Grid Storage
         hotkeys
         Mobile queries
         queries, executing
         Sort View
         Storage View components
         XML support
Data Definition Language (DDL)
data flow
Data Flow tab (SSIS Designer)
Data Manipulation Language (DML)
Data Mining Designer (BI Development Studio)
     algorithms/viewers
     association rule filters
     base columns with varying settings/properties
     classification matrix reports 2nd
     data source view, customizing
     diamond symbols
     lift chart
     multiple similar base columns
     productivity enhancements
     stored procedures, viewers
     viewer graphs, copying
data mining stored procedures
     association rule
     clustering
     decision trees
     dependency net
     Naive Bayes
     neurel net
data mining tools
     Data Mining Designer
         algorithms/viewers
         association rule filters
         base columns with varying settings/properties
         classification matrix reports 2nd
         data source view, customizing
         diamond symbols
         lift chart
         multiple similar base columns
         productivity enhancements
         stored procedures, viewers
         viewer graphs, copying
     DMX templates (data mining)
     Web site
Data Mining Wizard
Data Source Editor dialog box
Data Source View Designer (BI Development Studio)
     cube/dimension/partition definitions
     customizing
     Replace tables feature
data sources
     Integration Services
     Report Designer supported
     reports
         choosing
         OLAP/relational combinations
Data tab (Report Designer)
database administrators (DBAs)
Database Designer (BI Development Studio)
Database Diagram Designer
Database Engine
     Agent
         architecture
         Database Engine monitoring
         error log file
        jobs [See Microsoft, Operations Manager, Agent; Database Engine, Agent, jobs.]
         Mail
         metadata tables
        monitoring capabilities [See Database Engine, Agent, jobs; Database Engine, Agent, monitoring capabilities.]
         multi-server administration
         replication
         security
         services, configuring
         stored procedures
         synchronization script automation
         task types supported
         upgrades
     client network protocols
     connections
     features, enabling/disabling 2nd
         ad-hoc remote queries
         Agent stored procedures
         CLR integration
         Database Mail
         Native XML Web Service
         OLE Automation
         remote DACs
         Service Broker
         SQL Mail
         Web Assistant
         xp_cmdshell
     installing 2nd
         DVD main screen
        Installation Wizard [See Database Engine, installing, Installation Wizard; installing, SQL Server 2005, Database Engine.]
         Setup Wizard
     monitoring
     network protocols
     overview
     Query Editor support
     single user mode
     startup parameters
     trace flags
     Tuning Advisor (DTA)
Database Mail
     configuring
         parameters
         Wizard
     enabling/disabling
     Executable Minimum Lifetime parameter
     log
     Log File Viewer
     mail
         profiles
         sending
     monitoring
     overview
     security
     storage
     troubleshooting
     Wizard
Database Mirroring
Database Tuning Advisor [See DTA (Database Engine Tuning Advisor).]
databases
     AdventureWorks
     backing up
     deploying across servers
     Import Analysis 9.0
     mirroring
     objects
         creating
         properties
         selecting for replication
     replication
         agents
         configuring
        monitoring [See Database Engine, Agent, replication; databases, replication, monitoring.]
         Object Explorer icons
         overview
        publications [See Database Engine, Agent, replication; administration, replication (Management Studio), publications.]
         Replication folder
         subscriptions 2nd 3rd
     restoring
     roles
     sample
     tools
     trace data, saving
$(DATE) token
DBAs (database administrators)
DCOM (Distributed Component Object Model)
DDL (Data Definition Language)
debugging packages
decision trees (data mining stored procedure)
dedicated administrator connections (DACs) 2nd
Define Relationship dialog box
Delete command (Notification Services)
deleting
     application obsolete data
     components
     email
     full text indexes
     instances
     MRU server names
     multiple objects
Dependency Discovery phase (SMO scripting)
dependency net (data mining stored procedure)
DependencyTreeNode object
Deploy Report Project command (Report Designer Build menu)
deploying
     databases across servers
     instances
         argument encryption
         database objects, creating
         high availability
         Notification Services
         NSControl deployment script
         registration
         scaling out
         SQL Server permissions
         starting instances
         Windows permissions
     packages 2nd
     reports
     tools
         Analysis Services Deployment Wizard
         Copy Database Wizard
         Management Studio
Deployment Wizard
designers (BI Development Studio) 2nd 3rd
Detail Pane (Publisher)
Developer Edition
development tools
     BIDS
     Visual Studio
dialog boxes
     Add Filter
     Add Join
     Add Publisher
     Add SSIS Connection Manage
     Advanced Replay Options
     Advanced System Properties Windows
     Analysis Server Properties
     Analysis Services Properties
     Article Properties
     Attach
     Choose Toolbox Items
     Choose Variable Columns
     Configure SSIS Logs
     Connect To
     Connect to Database
     Connect to Server
     Connection 2nd
     Connection Parameters
     Data Source Editor
     Define Relationship
     Edit Filter
     Environment Variables Windows
     Event Rule Properties
     Export Package
     Filter Settings
     Generate Filters
     Import Package
     Instance Properties
     Job History
     Launch a Script
     Log Entry
     Login
     Management
         non-modality
         opening
         resizability
         scheduling
         scriptability
     Management Studio Options
     Named Calculation
     New Alert
     New Database
     New Job
     New Job Schedule
     New Job Step
     New Operator
     New Project
     New Proxy Account
     New Server Registration
     Notification Services Instance
     Object Explorer Filter Settings
     Package Configuration Organizer
     Package Execution Progress
     Package Roles
     Performance counter selection
     Process
     Project Properties
     Properties For All Tables
     Property Expressions Editor
     Property Pages
     Refresh Settings
     Register Instance 2nd
     Replay Configuration options
     Restore Database 2nd
     Restore File and Filegroups
     Save Copy of Package
     Security Property
     Select Computer
     Set Breakpoints
     SQL Agent Properties
     Surface Area Configuration for Features
     Trace Properties 2nd
     Update Instance 2nd
     Update Summary
diamond symbols (Data Mining Designer)
Dimension Designer (BI Development Studio)
Dimension Editor
     multiple parents rollup with weights
     tree views
     UDM picture support
Dimension Usage tab (Cube Designer)
     measure groups dimensionality
     measure groups granularity
Dimension Wizard
dimensions
     attribute relationships
     creating
     definitions
     quick designs 2nd
         data source customizations
         Replace tables feature
     security
     time
     types 2nd
disabling
     ad hoc data mining queries
     ad hoc remote queries
     Analysis Services features
         ad hoc data mining queries
         anonymous connections
         linked objects
         user-defined functions
     anonymous connections
     applications
     CLR integration
     Database Engine features 2nd
         ad hoc remote queries
         Agent stored procedures
         CLR integration
         Database Mail
         Native XML Web Service
         OLE Automation
         remote DACs
         Service Broker
         SQL Mail
         Web Assistant
         xp_cmdshell
     Database Mail
     HTTP Access
     instances
     linked objects
     Native XML Web Service
     OLE Automation
     remote connections
     remote DACs
     report deliveries
     Reporting Services features
     scheduled events
     Service Broker
     SQL Mail
     user-defined functions
     Web Assistant
     Web Services
     Windows Integrated Security
     xp_cmdshell
Display Estimated Execution Plan command (Query Editor Query menu)
Distributed Component Object Model (DCOM)
Distribution agents
Distributor to Subscriber History tab (Transactional Subscription Detail window)
DML (Data Manipulation Language)
DMO
DMX templates
Documenter
drop/create events
DTA (Database Engine Tuning Advisor)
     architecture
     database/table selection grid
     evaluative tuning
     recommendations
     Session Monitor
     starting
     Submitting Configuration Information phase
     tuning options 2nd
DTA.exe command line interface
dtexec command line utility
dtutil command line utility
dump directories
Dynamic Help command (Management Studio Help menu)
Dynamic Help window