Microsoft® SQL Server® 2012 Bible

1349

Index

hierarchies, 1206–1207

1NF, 165–166

AttributeHierarchyDisplay

Folder, 1207

AttributeHierarchyOptimized

State, 1207

AttributeHierarchyVisible,

1207

audits. See also Server Audit

Specifi cation; SQL Audit

C2 audit tracing, 497–498

Database Audit Specifi cations,

973

Object Explorer Security, 91

security, 497–498

Security Audit, 922

SSIS Data Flow, 1180

audit trails

data, data integrity, 19

SQL Audit, 974

triggers, 892

Aurum, 4

authentication, 833–839. See also

SQL authentication;

Windows authentication

LoginMode, 844–845

PowerShell, 845

SMOs, 845

SSMS, 844

authenticator, encryption, 856

AUTO, 355–359

auto close, 510–511

auto_cleanup, 947

AUTO_CREATE_STATISTICS, 511

autoexec.bat, 482

auto-hiding, windows, 85

automatic data refresh, PowerPivot

for SharePoint,

1318–1319

automatic failover, 690

auto_shrink, 510–511

AUTO_UPDATE_STATISTICS, 512

AUTO_UPDATE_STATISTICS_ASYNC,

512, 590

availability. See also AlwaysOn

Availability Groups; high-

availability

database, 20

mirroring, 686

group listeners, SNAC, 76

log shipping, 661–664

redundancy, 662

testing, 662–663

Availability Groups, Object Explorer,

92

AVG(), 185, 252

avg(), 250

AWE. See Address Windowing

Extensions

awe enabled, 487

awk, 771

Azure. See Azure SQL Database;

Windows Azure SQL

Database

B

Babylon, 3

backup, 562. See also recovery

certifi cates, 854

compression, 669

data, 1098, 1099

data

database availability, 20

replication, 729

database, 555–562

snapshots, 636

destination, 555–556

instances, 793

log shipping, 668

passwords, 561

rotation, 556

SSMS, 556–559

SSRS, 1269

symmetric encryption,

1278–1279

storage, database availability, 20

TDE, 854

transaction logs, 565–566

BACKUP

DISK, 560

Server Agent, 559–562

backup compression, 528

Backup Devices, Object Explorer

Security, 91

BACKUP LOG WITH NO_LOG, 567

BACKUP LOG WITH TRUNCATE_

ONLY, 567

BackupDir, 1228

Backup-SQLDatabase, 793

backward compatibility

outer joins, 223

SQL authentication, 837, 838

SSMS, 81

BACPAC, 632

base indexes, 1034

batches

DDL, 391

deadlocks, 1066

OUTPUT, 320

PowerShell, 769

schemas, 390

.sql, 391

statements, 390

terminating, 390–391, 433

T-SQL, 390–391

Query Editor, 102–103

USE, 391

batch-separators, 390

BCNF. See Boyce-Codd normal form

bcp. See bulk copy program

BEFORE, 883

BEGIN, 392

statements, 137

T-SQL, 82

BEGIN CATCH, 137

BEGIN CONVERSATION, 651

BEGIN DIALOG CONVERSATION,

648–649

BEGIN DISTRIBUTED TRANSACTION,

382

BEGIN TRAN, 420

BEGIN TRANSACTION, 382

begin transaction, 1050, 1090

BEGIN/END

IF, 399–400

inline table-valued functions,

458

WHILE, 401

BeginTransaction, 79

Best Practices Analyzer (BPA),

67–68

BETWEEN, 121–122, 266–267

between, where, 1018

BI. See business intelligence

BIDS. See Business Intelligence

Development Studio

Bigint, 175

Binary(), 176

binary large object (BLOB), 455

bulk-loaded recovery model, 553

BISM. See Business Intelligence

Semantic Models

Bit, 175

bit, 313

bitwise operators, 179–181

blackbox trace, 929

*.blg, 861

BLOB. See binary large object

blocks, transactions

Activity Monitor, 1057–1058

default, 1054–1056

monitoring, 1057–1060

OLTP, 1093

SQL Profi ler, 1058–1059

SSMS reports, 1057

bindex July 23, 2012 2:44 PM V1

bindex.indd 1349bindex.indd 1349 7/31/2012 10:39:56 AM7/31/2012 10:39:56 AM

http://www.it-ebooks.info