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]
-A option (SQLCMD)
access restrictions
Account Retry Attempts parameter
Account Retry Delay parameter
accounts
proxy
services
Action templates
Actions, DTA, Start Analysis menu command
Activity Monitor
auto-refresh functionality
blocked processes
filtering
last executed commands, viewing
Locks by Object page
Locks by Process page
overview
Process Info page
starting
user connections, killing
ad hoc queries
data mining
remote
$(A-DBN) token
Add Filter dialog box
Add Join dialog box
Add Publisher dialog box
Add SSIS Connection Manage dialog box
adding
joins to tables
packages to projects
Publishers
ADFs (application definition files)
administration
multi-server
replication (Management Studio)
agents
configuring
Object Explorer icons
publications
[See Database Engine, Agent, replication; administration, replication (Management Studio), publications.]
Replication folder
subscriptions
[See Database Engine, Agent, replication; administration, replication (Management Studio), subscriptions.]
administration and management tools
BCP
architecture
bulk import optimizations
command syntax
error handling
exporting data
exporting/importing example
format files
importing data
improvements
new features
overview
parameters
Management Studio
[See Management Studio.]
OSQL
query editors
architecture
Database Engine support
fonts/colors
Grid Control
Grid Storage
hotkeys
Management Studio
Mobile queries
overview
queries, executing
Sort View
SQLCMD
starting
Storage View components
XML support
Report Manager 2nd
SQLCMD
[See SQLCMD.]
Administrator Console (MOM)
Advanced Replay Options dialog box
Advanced System Properties Windows dialog box
AdventureWorks database
$(A-ERR) token
Agent
architecture
Database Engine monitoring
error log file
jobs
Activity Monitor
assigning to target servers
creating
history
replication maintenance
schedules
starting
steps 2nd
Windows Performance Monitor
Mail
metadata tables
monitoring capabilities
event alerts
mechanism
operators
performance alerts
WMI alerts 2nd
multi-server administration
replication
security
database roles
job steps, logging
proxy accounts
services, configuirng
stored procedures
synchronization script automation
task types supported
upgrades
Alert drill-down (MOM Operator Console)
alerts
event
performance
WMI 2nd
Alerts view (MOM Operator Console)
algorithm (Data Mining)
Align command (BIDS Format menu)
All Subscriptions tab (Transactional Publication detail pane)
AMO (Analysis Management Objects)
overview
Surface Area Configuration tool dependency
$(A-MSG) token
Analysis Server Properties dialog box
Analysis Services
BI Development Studio
Action templates
auto-scrolling
Calculation templates
changes, documenting
Cube Browser filter components
cubes, creating
cubes, definitions
cubes, prototyping
dimensions, creating
dimensions, definitions
dimensions, types/attribute types
KPI browser, rebuilding
KPI company health indexes
KPI Display folder
KPI parent property
KPI templates
MDX debugger 2nd
measure groups dimensionality, comparing
measure groups granularity
object documentation, viewing
partitions 2nd
project deployment
Project mode versus Immediate mode
quick cube/dimension designs/testing 2nd
sample measures, viewing
security
time intelligence templates
translations, loading
upgrading AS2K cubes to AS2K5
Visual Studio environment, customizing
data mining
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, viewing
viewer graphs, copying
Deployment Wizard
Dimension Editor tree views
dimensions with multiple parents rollup with weights
features, enabling/disabling
ad hoc data mining queries
anonymous connections
linked objects
user-defined functions
installing
multiple MDX queries
OLAP tools
BI Development Studio 2nd
Management Studio
overview
process options
Properties dialog box
server properties, finding
time dimensions, creating
UDM 2nd
upgrades
enhance
migration
options
rebuilding
anonymous connections
APIs (application programming interfaces)
Notification Services
Replay Objects
Trace Objects
saving trace tables to files
saving traces to tables
starting traces
trace objects
application definition files (ADFs)
architecture
Agent
BCP
Configuration Manager
DTA
Notification Services
Query Editor
SMO
Surface Area Configuration tool
Upgrade Advisor
argumentkey option (nscontrol create command)
arguments, encrypting
Article Properties dialog box
Articles page (New Publication wizard)
properties
table properties
AS2K cubes, upgrading to AS2K5
$(A-SEV) token
assemblies
association rules
data mining stored procedure
filters
$(A-SVR) token
asymmetrical reports
Attach dialog box
attributes
dimensions
relationships
Auto Layout command (BIDS Format menu)
auto-scrolling
Autobuild
|
Ajax Editor
Ajax development