1377
Index
log shipping, 683
MDW, 978
metadata, 1177
Object Explorer, 92
ODBC, 1157
OLE DB, 1157
Package Deployment Model,
1188–1190
package logging, 1187–1188
Package Parameter, 1160
parameters, 1160
PowerShell, 783
Precedence Constraint Editor,
1174–1175
Project Deployment Model, 1156,
1160, 1167, 1190–1191
Properties window, 1160–1161
Registered Servers, 86
Shared Connection Managers,
1158
Azure SQL Database, 816–826
SSDT, 1158, 1166–1167
Toolbox, 1160
variables, 1160
SQL Server Logs, Object Explorer, 92
SQL Server Management Studio
(SSMS), 4, 81–107. See
also Object Explorer;
Query Designer
advanced server confi guration,
505
All Blocks Transactions, 1057
ANSI, 516
authentication, 844
backup, 556–559
backup compression, 528
backward compatibility, 81
batch-separators, 390
BI, 81
Bookmarks window, 83
cascading deletes, 312
Change Tracking, 948
code snippets, 106
connections, 500
context menu, 85
cursor close on commit, 514
data compression, 1103–1104
data modifi cation, 292
database
confi guration, 475
mirroring, 694–695
Database Diagrams, 95–96
default language, 508
distributed queries, 377
Error List, 83execution plans, 996
Generate and Publish Scripts
Wizard, 808
GO, 433
GUI, 81, 434, 802
Import and Export Wizard, 628
Index Properties Storage, 1103
installation, 68
Installation Center, 42
instances, 58
interface, 82–86
lightweight pooling, 493
Linked Servers, 368
linking, 369–371
log shipping confi guration,
667–675
logins, 372–373
Management Tools, 1262
max degree of parallelism,
494
MDW, 978
media retention, 527
nested triggers, 522
New Page Restore, 82
nodes, 82
object security, 849–850
output parameters, 445
Output window, 83
PAGE_VERIFY, 526
point-in-time restore, 82
PowerShell, 769, 782
PRINT, 446
priority boost, 492
Properties window, 83
Query Editor, 9, 83, 99–105
recovery interval, 529
recovery model, 526
recursive triggers, 522
Registered Servers, 82, 86–89
registering, 368
remote access, 502
remote proc trans, 503
reports, transaction blocks,
1057
restore, 570–574
roles, 1271, 1273
scripts, 620–621
security, 372–373, 497
Server Audit Specifi cation, 972
server confi guration, 471
Server Properties, 483
SMOs, 81
snapshot/transactional
publication, 738
Solution Explorer, 83, 105SP2, 82
SPID, 602
Azure SQL Database, 802–803
SQL Profi ler, 920
SSAS, 1227
stored procedures, 434, 450
Table Designer, 94–95
Table Properties, 1103
Task List, 83
Template Explorer, 83
templates, 106
Toolbox, 83
T-SQL, 81, 82
UDFs, 454
user connections, 501
Utility Explorer dashboard, 83
views, 274, 278
Web Browser, 83
windows, 83–85
XML, 347
SQL Server Mobile
Registered Servers, 86
SSIS Connection Managers, 1168
SSIS Data Flow, 1179
SQL Server Native Client (SNAC), 71,
73–74
features, 74–79
SQL Server Operating System
(SQLOS), wait states,
931–932
SQL Server Reporting Services
(SSRS), 7, 9
administering, 1261–1280
backup, 1269, 1278
cubes, 1245–1247
data, 1244–1250
Data Alerts, 1262, 1269, 1277
data sources, 1271
datasets, fi elds, 1253
disaster recovery, 1277–1280
Excel, 1269
expressions, 1250
installation, 32, 1261–1265
Installation Center, 42
matrix reports, 1245–1247
native mode, 1261–1262
roles, 1271–1275
parameters, 1248–1250
permissions, 1273–1274
Power View, 1235, 1327
Registered Servers, 86
Report Builder, 1235
reports, 1255–1258
Report Designer, 1234,
1240–1244bindex July 23, 2012 2:44 PM V1bindex.indd 1377bindex.indd 1377 7/31/2012 10:39:59 AM7/31/2012 10:39:59 AM
http://www.it-ebooks.info