Microsoft® SQL Server® 2012 Bible

1374

Index

Server Audit Specifi cation

create, 972

Object Explorer Security, 91

SQL Audit, 971–973

SSMS, 972

T-SQL, 972

Server Authentication Certifi cate,

750

server authentication mode,

496–497

Server Broker, 921

Server Confi guration Manager, 71,

72–73

SNAC, 73

Server Manager, 753

Server Objects, Object Explorer

Security, 91

Server Options, SSMS, 371

Server Properties, SSMS, 483

Server Roles, Object Explorer

Security, 91

Server Role Services, 749–750

@@ServerName, 405

SERVERPROPERTY, 472

SERVERPROPERTY(), 210–211

$servers, 774

Get-WMIObject, 779

service accounts installation, 54

Service Broker, 27

AlwaysOn Availability Groups,

655–656

asynchronous messaging,

647–659

Catalog Views, 650–651, 657–658

DDL, 649

dialogs, 651–655

DML, 658

message queue, 649–651

monitoring and troubleshooting,

656–658

multicast, 655

Object Explorer, 91, 650

poison message, 656

queues, 651–652

receiving messages, 652–655

service level agreement (SLA), 663

Service Pack 2 (SP2), 82

Service Principal Name (SPN), 838

service_broker_guid, 648

service-level agreement (SLA)

database mirroring, 688

Resource Governor, 27

@@ServiceName, 405

Service-Oriented Architecture

(SOA), 647

Sessions

Extended Events, 940–941, 943

SQL Profi ler, 922

SET

connections, 476

@ErrorMsg, 413

variables, 394–395

SET ANSI_DEFAULTS, 516

SET ANSI_NULLS, 517

Azure SQL Database, 814

set difference queries

full, 233

left, 232–233

outer joins, 226

SET IDENTITY_INSERT, 295

set-based queries, 25–26

Set-Location, 782

Set-Location SQL, 783

set_lock_timeout, 1069

SETSPN, 838

Setup Support Rules, 756

Setup Wizard, 46–47, 53, 55

setup.exe, 580

Shared, 1087

Shared Connection Managers,

1158

Shared Data Sets, 1241

Shared Data Sources, 1241

shared locks, 1067

Shared Memory, 72

SNAC, 73

Shared with Intent Exclusive Lock

(SIX), 1068

SharePoint

BISM, 1301, 1317–1318

PowerPivot

automatic data refresh,

1318–1319

BISM, 1301

SSAS, 1223

SSRS, 1262–1265

reports, 1269–1271

Shiloh, 4

shortcuts, Query Editor, 102

show advanced options, 478, 480

SHOWPLAN, 996, 999

Showplan_all, 999

Showplan_text, 999

Showplan_xml, 999

Shut Down Server, 968

SID. See security identifi er

SIGN(), 1187

SIMPLE, 554

Simple, 687

simple CASE, 182–183

Simple Mail Transfer Protocol

(SMTP), 1169

Simple Object Access Protocol

(SOAP), 1225

asynchronous messaging, 648

SSAS data mining, 1288

simple recovery model, 525, 548,

549, 550–551

sequence, 569

transaction logs, 567

simple subqueries, 237–241

CTEs, 239–240

simplicity, database extensibility,

18

single sign-on, Windows

authentication, 836

single_user, database state, 524

single-user mode, AUTO_UPDATE_

STATISTICS_ASYNC, 590

SIX. See Shared with Intent

Exclusive Lock

size, 599

SKIP, backup, 562

SLA. See service level agreement;

service-level agreement

slicers, Power View, 1335–1338

Slowly Changing Dimension, SSIS

Data Flow, 1182

Smalldatetime, 176

SmallDateTimeFromParts(), 197

Smallint, 175

SmallMoney, 175

Smart Database Design, 22–29

concurrency, 24

hardware, 29

issues and objections, 28

performance, 28

physical schema, 24

scalability, 24

smart keys, 166

SMOs. See SQL Management Objects

SMTP. See Simple Mail Transfer

Protocol

SNAC. See SQL Server Native Client

snapshots

agent, 731, 736

database, 635–645

copy-on-fi rst-write, 637

CREATE DATABASE, 639

data compression, 1099

dropping, 643

mechanics of, 636–637

Object Explorer, 640

queries, 641–643

RESTORE, 638

bindex July 23, 2012 2:44 PM V1

bindex.indd 1374bindex.indd 1374 7/31/2012 10:39:59 AM7/31/2012 10:39:59 AM

http://www.it-ebooks.info