Index

Search in book...
Toggle Font Controls
Create new playlist

Name your new playlist

Playlist description (optional)
Sign In

Email address

Password

Forgot Password?

or

Continue with Facebook

Continue with Google
Sign Up

Full Name

Email address

Confirm Email Address

Password

or

Continue with Facebook

Continue with Google

Previous Chapter

Chapter 27: Migrating to the Cloud

Index

A

AlwaysOn Availability Groups (AOAG)

administrative considerations

automatic page repair

Backup Preferences tab

DR (See Disaster recovery (DR))

client access point

HA (See High availability (HA))

AlwaysOn dashboard

AlwaysOn health trace

synchronizing uncontained objects

virtualization machines (VMs)

AlwaysOn dashboard

AlwaysOn health trace

Atomic, Consistent, Isolated and Durable (ACID)

Azure SQL Database

alert conditions and actions

Alert Evaluation Window field

Alert Rule dialog box

audit configuration

Average Evaluation Window field

Basic tier performance level

client IP address configuration

firewall configuration

Object Explorer

performance metrics

premium tier performance level

quick start page

Restore Dialog box

server dialog box

Standard tier performance level

Threshold Value field

configuration page

database deployment

B

Backup database

BULK LOGGED recovery model

mirrored media set

full backup–only

full/differential/transaction logs

FULL recovery model

SIMPLE recovery model

SQL Server Management Studio

Backup Options page

Media Options page

transaction log

backup set options

error management options

log-specific options

media set options

miscellaneous options

Backup strategies

full/transaction log

clustered index scan

C

Cell-level encryption

authenticator column

cryptographic functions

DECRYPTBYKEY() function

DecryptByKey parameters

duplicate database selection

EncryptByKey() parameters

HASHBYTES() function

performance implications

bloat encryption

Central management server

in Windows Azure

INIT and NOINIT

SQL Server Managed Backup to Windows Azure

backup strategy

for individual database

recovery models

stand-alone databases

SQL Server Management Studio

CloudBlobContainer.GetSharedAccessSignature method

node configuration page

read to add node page

service accounts page

clustered instance installation

confirmation page

disk selection page

instance configuration page

management tool selection

network configuration page

PowerShell installation

PowerShell instance

preparation steps

resource group page

server roles page

server selection page

MSDTC (See MSDTC configuration)

quorum selection page

quorum witness page

Set-ClusterQuorum command

storage witness page

confirmation page

servers page selection

testing options page

validation report failover

validation test

validation warning page

service account tab

SQL server role

moving an instance

Node Configuration page

online passive node

Remove Node page

remove node parameters

remove possible owner

rolling patch upgrade

Clustered columnstore indexes

Clustered indexes

CREATE CLUSTERED INDEX

performance considerations for

primary key clustering

Cluster node configuration page

Columnstore indexes

performance considerations for

Cryptographic functions

D

DaaS (Database as a Service)

Database consistency

DBCC CHECKDB (See DBCC CHECKDB)

detecting errors

bad checksum error

CHECKSUM database

memory-optimization tables

page verify option

querying suspect_pages

TORN_PAGE_DETECTION

system database corruption

reattaching database

rebuild parameters

repair instance parameters

select instance page

Database deployment

source settings page

Windows Azure sign-in page

Database-level security

built-in database roles

contained databases

Database snapshot

recovering data

clustered index scan

DBCC CHECKALLOC

DBCC CHECKCATALOG

DBCC CHECKCONSTRAINTS arguments

CHECKCONSTRAINTS

configure notification

Corrupt Table error

errors in job history

new operator selection

REPAIR_ALLOW_DATA_LOSS

repairing corruption

running command

suggested repair option

suspect_pages table

DBCC CHECKFILEGROUP

DBCC CHECKIDENT arguments

DBCC CHECKTABLE

DB_ID() function

DDL (data definition language) triggers

auditing/limiting DBA

CREATE statement

stored procedure

XQuery Value method

EVENTDATA() function

event hierarchy

sys.server_triggers

XML data() function

ROLLBACK statement

server scoped trigger

deadlock monitor

DecryptByKey parameters

Disaster recovery (DR)

AOAG (See Disaster recovery (DR):AOAG:AlwaysOn Availability Groups (AOAG))

availability group configuration

adding IP address

improving connection times

replica (See Replicas)

cluster configuration

adding IP address

modifying quorum

database creation

database mirroring

ad-hoc restores

Initialize Secondary Database tab

Log Shipping Monitor Settings

New Job Schedule

No Recovery Mode

Restore Transaction Log tab

Save Log Shipping Configuration

Transaction Log Backup Settings

Transaction Log Shipping page

T-SQL configuration

@backup_job_id output

sp_add_log_shipping_primary_database parameters

sp_add_log_shipping_primary_secondary system

sp_add_log_shipping_secondary_database parameters

sp_add_log_shipping_secondary_primary system

sp_processlogshippingmonitorsecondary parameters

recovery point objective

Distributed Replay

Clients configuration

Controller configuration

Access Permissions

Launch and Activation permissions

database creation

DReplay.exe.preprocess.config

DReplay.exe.replay.config

target synchronization

events, event fields and actions

Extended Event Session

generate activity

Dynamic link library (DLL)

Dynamic management views (DMVs)

CPU utilization

resetting statistics

sys.dm_resource_governor_resource_pool_affinity

sys.dm_resource_governor_resource_pools

sys.dm_resource_governor_resource_pool_volumes

sys.dm_resource_governor_workload_groups

E

EncryptByKey() parameters

Encryption hierarchy

asymmetric keys

certificate authority

Backup and restore Database Master Key

Database Master Key selection

Restore Service Master Key

Service Master Key

Extended Events

database creation

data collection

Aggregation dialog box

analyzing data with T-SQL

Columns dialog box

data viewer grid

data viewer toolbar

event_file target

Grouping dialog box

Data Collector Set

dialog box creation

Data Storage page

module_start event

page_splits event

merging trace files

New Session Wizard

Capture Global Fields page

Data Storage page

Set Properties page

session (see Event session)

trace file location

PageSplits session

Windows Performance Analyzer

WMI-Activity provider

Extensible Key Management (EKM) module

External fragmentation

F

Failover Clustered Instance (FCI)

active/active configuration

three-plus node configurations

backup and restore strategies

expanding files

database properties dialog box

folder hierarchy

log maintenance

log reuse waits

log size and VLFs number

transaction log

memory-optimized tables

round-robin allocation

secondary files

shrinking files

memory-optimized strategies

storage tiering strategies

performance strategies

database properties dialog box

folder hierarchy

Fragmentation of index

external fragmentation

internal fragmentation

Fully qualified domain name (FQDN)

H

High availability (HA)

AlwaysOn failover clustering

active/active configuration

three-plus node configurations

cost of downtime

database mirroring

level of availability

proactive maintenance

SQL Server configuration

standby classifications

I

IaaS (Infrastructure as a Service)

clustered columnstore indexes

clustered indexes

CREATE CLUSTERED INDEX

performance considerations for

primary key clustering

columnstore indexes

performance considerations for

external fragmentation

internal fragmentation

in-memory indexes

nonclustered hash index

nonclustered indexes

performance considerations for

missing indexes

nonclustered columnstore indexes

nonclustered indexes

covering indexes

CREATE NONCLUSTERED INDEX

performance considerations

partitioned indexes

filtered statistics

CREATE PRIMARY XML INDEX

CREATE XML INDEX

performance considerations for

primary XML index

secondary XML indexes

USING XML INDEX

Index Scan operator

Initial data synchronization

In-memory Indexes

CREATE TABLE T-SQL

nonclustered hash index

nonclustered indexes

performance considerations for

Instance configuration

buffer pool extension

Max Server Memory (MB)

Min Server Memory (MB)

communication process

database engine

IP addresses tab

processor affinity

affinity I/O mask

system databases

mssqlsystemresource

startup parameters

trace flag 1117

trace flag 1118

trace flag 3042

trace flag 3226

trace flag 3625

Windows Server Core

uninstallation (See Uninstallation process)

windows firewall rules

protocols/ports page

Instance installation

/ACTION Parameter

command line parameters

/FEATURES Parameter

/IACCEPTSQLSERVERLICENSETERMS

installation progress

optional parameters

troubleshooting

SystemConfigurationCheck_Report.htm file

Instance-level security

fixed server roles

granting permissions

Enforce Password Policy

Server Roles tab

User Mapping tab

mixed-mode authentication

security vulnerability

New Server Role

Windows authentication

ownership chain

security identifier

Windows user/group

Internal fragmentation

J, K

Alert System page

Browser service

database mail configuration

notifications page

operator creation

Public Profiles tab

sp_add_job parameters

sp_add_jobstep parameters

sp_attach_schedule parameters

sy_add_jobserver parameters

system parameters configuration

monitoring and maintenance

L

online maintenance

LogFragmentation

log reuse waits

log size and VLFs number

sp_settriggerorder parameters

DR (See Disaster recovery (DR))

Log Shipping Primary Server Alert

Log Shipping Secondary Server Alert

Server Agent Alerts

sp_help_log_shipping_monitor

switching roles

Disabling Log Shipping Jobs

reconfigure log shipping

reconfigure monitoring

M

Maintenance plans

Cleanup Task properties

Database Check Integrity Task page

Database Task properties

Destination tab

Maintenance Task Order page

Maintenance Tasks page

Notify Operator Task properties

precedence constraints

Report Options page

Select Plan Properties page

Target Servers page

Master database

Master server (MSX)

Memory-optimized tables

disk-based tables

Merge replication

buffer cache usage

capacity management

sys.dm_db_file_space_usage

sys.dm_io_virtual_file_stats

sys.master_files

driven automation

database snapshots

rebuild indexes

dynamic management view

information schema view

perfmon counters

sys.dm_os_performance_counters

Type 1073874176

query troubleshooting process

database creation

longest running

sys.dm_exec_query_stats

registry values

server and instance level

service details

sys.dm_os_wait_stats

Missing indexes

MSDTC configuration

Add-ClusterResource cmdlet

Client Access Point page

role page selection

storage page selection

mssqlsystemresource database

Multiserver jobs

Multiserver job conversion

sp_add_jobserver parameters

sp_delete_jobserver parameters

sp_msx_enlist stored procedure

sp_update_job procedure

sp_update_jobstep procedure

MSX and TSX servers

enlisting servers

Login Credentials page

Master Server operator page

MsxEncryptChannelOptions

Registry updation

sp_msx_enlist parameters

Target Servers page

Download Instructions tab

Force Defection button

Post Instructions button

Start Job, TARGETSERVER1

synchronize clocks

Target Server Status tab

N

Nonclustered columnstore indexes

Nonclustered hash index

Nonclustered indexes

covering indexes

CREATE NONCLUSTERED INDEX

performance considerations

Non-uniform memory access (NUMA) node

O

Object-level security

column-level permissions

ownership chaining

OBJET_ID() function

P, Q

Partitioned indexes

$PARTITION function

index alignment

partitioning Key

new table creation

object creation

Performance Monitor

Policy-based management

central management server

importing and exporting policies

policy evaluation with PowerShell

evaluation modes

On Change: Log Only

On Change: Prevent

supported execution types

ExecuteSQL() Parameters

ExecuteWQL() Parameters

PreventDatabaseCreation trigger

PreventLoginDuringETL trigger

Primary role property

Primary XML index

R

RDP (Remote Desktop Protocol)

RECONFIGURE command

RECONFIGURE WITH OVERRIDE command

Recovery point objective (RPO)

Recovery time objective (RTO)

data synchronization page

page connection

validation page

transactional (See Transactional replication)

Replication, SQL Server Management Studio (SSMS)

distributor/publisher

Agent Security page

Article Properties

distributor page

Filter Table Rows page

Publication Database page

Publication Type page

Snapshot Agent page

Snapshot Agent Security

Snapshot Folder page

SQL Server Agent Start page

Distribution Agent

Distribution Agent Location page

Initialize Subscriptions page

Publication page

Subscribers page

Replication, T-SQL

distributor/publisher

sp_adddistpublisher

sp_adddistributiondb

sp_adddistributor

sp_addlogreader_agent

sp_addpublication

sp_addpublication_snapshot

Sp_articlefilter

sp_replicationdboption

sp_addpushsubscription_agent

sp_ addsubscription

Resource Governor

resource pool stats

workload group stats

classifier function

instance preparation

CPU utilization

Performance Monitor

resetting statistics

resource pool stats

sales user and manger login

sys.dm_resource_governor_resource_pools

sys.dm_resource_governor_resource_pool_volumes

sys.dm_resource_governor_workload_groups

workload group stats

properties dialog

sys.dm_resource_governor_resource_pool_affinity

workload groups

Restore database

SQL Server Management Studio

backup timeline page

error management options

media set options

miscellaneous options

restore arguments

restore options

S

Secondary XML indexes

AUDIT_CHANGE_GROUP

Audit-ProSQLAdmin

database audit specification

enabling and invoking

FOR SERVER AUDIT clause

SensitiveData table

SERVER_ROLE_MEMBER_CHANGE_GROUP

Windows Application log

Session Timeout property

Shared access signature (SAS)

Software prerequisites

.NET Framework 3.5

Snapshot replication

ALTER SERVER CONFIGURATION

Max Server Memory

Min Server Memory

processor affinity

sp_estimate_data_compression_savings

SQL Data Files, Windows Azure

Access Policies dialog box

Adhoc-query string components

database creation

partitioning objects

monitoring and managing

Access Policies dialog box

query string components

shared access signature

Shared Access Signature dialog box

SQL Server instance

Standard Local Redundant account

Storage Account Connection dialog box

SQL Server Agent

SQL Server events

SQL Server performance conditions

alerts and responses

credentials creation

credentials with T-SQL

database mail configuration

environment preparation

Frequency and Duration sections

@frequency_interval values

New Job Schedule box

notifications page

removing old backups

schedule creation

sp_add_proxy parameters

sp_add_schedule parameters

subsystem mappings

SQL Server Integration Services (SSIS)

administrative scenarios, SSIS

control flow toolbox

integration services template

SMO Connection Manager Editor

Transfer Logins Task

SQL Server Memory Pool

SQL Server security model

database administrators

database-level security

built-in database roles

contained databases

domain user/group

instance-level (See Instance-level security)

object-level security

column-level permissions

ownership chaining

AUDIT_CHANGE_GROUP

Audit-ProSQLAdmin

database audit specification

enabling and invoking

FOR SERVER AUDIT clause

SERVER_ROLE_MEMBER_CHANGE_GROUP

Windows Application log

SSDT (SQL Server Data Tools)

Standby classifications

Statistics of index

filtered statistics

Synchronous Commit Mode

sys.fn_dump_dblog()

T

data compression wizard

dictionary compression

prefix compression

row compression

sp_estimate_data_compression_savings

tables and partitions

variable-length metadata

memory-optimized tables (See Memory-optimized tables)

$PARTITION function

index alignment

new table creation

object creation

partitioning key

Target servers (TSX)

TDE (Transparent Data Encryption)

TempDB database

Transactional replication

All Subscriptions tab

CommitBatchSize

publication access list

sp_grant_publication_access

SubscriptionStreams

Tracer Tokens tab

verbose logging

Verbose statistics

memory-optimized tables

database creation

data synchronization

sp_addlogreader_agent

sp_addpublication

sp_addpublication_snapshot

sp_addsubscription

sp_changearticle

sp_replicationdboption

Subscription Database

atomic transaction

consistent property

cross-container transactions

Read Committed isolation

Read Committed Snapshot isolation

Repeatable Read

snapshot isolation

nonrepeatable read

optimistic levels

pessimistic level

Transmission Control Protocol (TCP)

Transparent Data Encryption (TDE)

Backup certificate

FILESTREAM filegroup

Database Encryption key

Database Master Key selection

database progress

In-Memory filegroup

performance implications

benchmark queries

Benchmark running

Duplicate Database selection

restore and encrypted database

Server Certificate restore database

U

Uninstallation process

feature rules page

global rules page

PowerShell command

programs and features console

select features page

select instance page

V

DBCC CHECKALLOC

DBCC CHECKDB with physical only option

secondary server

split work load

W

Windows Authentication model

Windows Server Core Installation

auto-install script

configuration file

instance (See Instance Installation)

PROSQLADMINCONF2

SQLAutoInstall3.ps1

SQLAutoInstall.ps1

X, Y, Z

CREATE PRIMARY XML INDEX

CREATE XML INDEX

performance considerations for

primary XML index

secondary XML indexes

USING XML INDEX

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.

18.188.57.172