You're reading from Getting Started with SQL Server 2014 Administration

Product typeBook

Published inApr 2014

PublisherPackt

ISBN-139781782172413

Edition1st Edition

Tools

SQL Server

Concepts

Database Administration

Author (1)

Gethyn Ellis

Index

A

ACID (Atomic Consistent Independent and Durable)
- about / Memory-optimized tables
AlwaysOn Availability Group
- creating, in Windows Azure / Creating an AlwaysOn Availability Group in Microsoft Azure
AlwaysOn Availability Groups
- about / Introducing AlwaysOn Availability Groups
- enhancements / Enhancements in AlwaysOn Availability Groups
- creating / Building AlwaysOn Availability Groups
- prerequisites / Building AlwaysOn Availability Groups
asynchronous commit mode / The commit mode
Availability Group
- creating / Creating Availability Group
- troubleshooting / Troubleshooting Availability Groups
Availability Group listener
- about / The Availability Group listener

B

buffer pool extensions
- about / Buffer pool extensions
- using / Buffer pool extensions

C

cardinality estimator
- about / Cardinality estimator and query plans
- used, for improving query plans / Cardinality estimator and query plans
certificate/asymmetric key
- creating / Creating a certificate or asymmetric key
cloud-based AlwaysOn Availability Group
- creating / Creating a cloud-based AlwaysOn Availability Group
clustered columnstore index
- creating / Creating a clustered columnstore index
- table, updating / Updating a table with a clustered columnstore index
CodePlex
- URL / The container policy and Shared Access Signature
columnstore index
- about / Columnstore indexes
- benefits / Columnstore indexes
- clustered columnstore index / Creating a clustered columnstore index, Updating a table with a clustered columnstore index
commit mode
- about / The commit mode
- asynchronous commit mode / The commit mode
- synchronous commit mode / The commit mode
concurrency control
- about / Concurrency
- Pessimistic concurrency control / Concurrency
- Optimistic concurrency control / Concurrency
concurrency terminologies
- Dirty reads / Some concurrency terminologies
- Non-repeatable reads / Some concurrency terminologies
- Phantom reads / Some concurrency terminologies
Control Transaction Durability
- URL / Full Durability versus Delayed Durability
credential, Windows Azure Storage
- creating / Creating a credential

D

database
- migrating, to Windows Azure SQL Database / Migrating an existing database to Microsoft Azure
- creating, for Windows Azure Storage / Creating a database that uses the Microsoft Azure Storage integration
- creating, Windows Azure Storage used / Creating a database using Microsoft Azure Storage
- backing up, to URL / Database backups to a URL and Microsoft Azure Storage
database backup
- restoring, on Windows Azure Storage / Restoring a backup stored on Windows Azure Storage
database backup, URL
- limitations / Database backups to a URL and Microsoft Azure Storage
database master key
- creating, for master database / Creating a database master key for the master database
Delayed Durability
- about / Understanding the delayed transaction durability
- versus Full Durability / Full Durability versus Delayed Durability
- using / Using delayed transaction durability
- transaction level (Transact-SQL) / Transaction level Delayed Durability – Transact-SQL
- natively compiled stored procedures / Delayed Durability and Natively Compiled Stored Procedures
- transaction log flush / Delayed Durability and transaction log flush
- potential data loss / Delayed Durability and potential data loss
- and other SQL Server components / Delayed Durability and other SQL Server components
Disaster Recovery (DR)
- about / Integrating Microsoft Azure Storage

E

encrypted backup
- creating / Creating an encrypted backup
- database master key, creating / Creating a database master key for the master database
- certificate/asymmetric key, creating / Creating a certificate or asymmetric key
- encrypted database backup, creating / Creating an encrypted database backup
encrypted database backup
- creating / Creating an encrypted database backup
encryption
- about / Encryption
enhancements, AlwaysOn Availability Groups
- Windows Azure Replica / Enhancements in AlwaysOn Availability Groups

F

full transaction durability
- about / Understanding the full transaction durability
- versus Delayed Durability / Full Durability versus Delayed Durability

G

geo-replication / Creating a Microsoft Azure Storage account and container

H

hash indexes
- about / Memory-optimized tables and indexes
- hash bucket / Memory-optimized tables and indexes
heap
- about / Memory-optimized tables and indexes
High Availability (HA)
- about / Integrating Microsoft Azure Storage
Hybrid Availability Group
- creating / Creating a Hybrid Availability Group

I

In-Memory Optimized tables
- using, requirements / Requirements
- virtualized environments / Virtualized environments
Infrastructure as a Service (IaaS) / Creating an AlwaysOn Availability Group in Microsoft Azure
instance service
- configuring / Configuring the instance service

M

Managed Backup
- about / SQL Server Managed Backup to Microsoft Azure
- configuring, in SQL Server 2014 / Configuring SQL Server-managed backups to Microsoft Azure
Managed Backup, SQL Server
- setting up, to Windows Azure / SQL Server Managed Backup to Microsoft Azure, Configuring SQL Server-managed backups to Microsoft Azure
Management Studio
- used, for conneting Windows Azure SQL Database / Connecting to a Windows Azure SQL database with Management Studio
- about / Connecting to a Windows Azure SQL database with Management Studio
memory-optimized tables
- about / Memory-optimized tables
- data types, supported in / Memory-optimized tables
- limitations / Memory-optimized tables
- indexes, supported in / Memory-optimized tables and indexes
- hash indexes / Memory-optimized tables and indexes
- natively compiled stored procedures / Transact-SQL and natively compiled stored procedures
- concurrency / Concurrency, Some concurrency terminologies

N

natively compiled stored procedures
- about / Transact-SQL and natively compiled stored procedures
- using / Transact-SQL and natively compiled stored procedures
- and Delayed Durability / Delayed Durability and Natively Compiled Stored Procedures
Node Majority quorum model / Creating a Hybrid Availability Group
non-clustered hash indexes / Memory-optimized tables and indexes
non-clustered indexes / Memory-optimized tables and indexes

O

Object Explorer / Creating Availability Group, Troubleshooting Availability Groups
OLTP
- about / Memory-optimized tables

P

potential data loss
- and Delayed Durability / Delayed Durability and potential data loss
prerequisites, AlwaysOn Availability Groups
- Windows Server Failover Cluster / Windows Server Failover Cluster
- instance service, configuring / Configuring the instance service
- Availability Group listener / The Availability Group listener

Q

query plans
- improving, cardinality estimator used / Cardinality estimator and query plans

R

replicas
- Windows Azure Virtual Machines, using as / Using Microsoft Azure Virtual Machines as replicas
requirements
- for using, In-Memory Optimized tables / Requirements
Resource Governor
- about / Resource Governor

S

secondary replicas
- administering on / Reporting and administrating on secondary replicas
- reporting on / Reporting and administrating on secondary replicas
Shared Access Signature (SAS) / Creating a database that uses the Microsoft Azure Storage integration
- creating / The container policy and Shared Access Signature
SQL Server 2014
- Managed Backup, configuring in / Configuring SQL Server-managed backups to Microsoft Azure
SQL Server components
- Delayed Durability, integrating with / Delayed Durability and other SQL Server components
SQL Server database
- backing up, to URL / Backing up a SQL Server database to a URL
SSD
- about / Buffer pool extensions
statistics
- about / Statistics
synchronous commit mode / The commit mode
sys.fn_hadr_is_primary_replica function / Enhancements in AlwaysOn Availability Groups, Troubleshooting Availability Groups

T

Transact-SQL
- Delayed Durability / Transaction level Delayed Durability – Transact-SQL
transaction isolation levels
- read uncommitted / Some concurrency terminologies
- read committed / Some concurrency terminologies
- repeatable read / Some concurrency terminologies
- snapshot / Some concurrency terminologies
- serializable / Some concurrency terminologies
transaction log flush
- and Delayed Durability / Delayed Durability and transaction log flush
troubleshooting
- Availability Groups / Troubleshooting Availability Groups

U

Uniform Resource Identifer (URI)
- about / Creating a credential
Uniform Resource Identifier (URI) / Database backups to a URL and Microsoft Azure Storage
URL
- database backup, creating to / Database backups to a URL and Microsoft Azure Storage
- SQL Server database, backing up to / Backing up a SQL Server database to a URL

W

Windows Azure
- URL / Creating a Windows Azure SQL database
- SQL Server Managed Backups, configuring to / Configuring SQL Server-managed backups to Microsoft Azure, Encryption
- AlwaysOn Availability Group, creating in / Creating an AlwaysOn Availability Group in Microsoft Azure
Windows Azure Replica
- about / Enhancements in AlwaysOn Availability Groups
Windows Azure SQL Database
- about / Windows Azure SQL Database
- creating / Creating a Windows Azure SQL database
- conneting, with Management Studio / Connecting to a Windows Azure SQL database with Management Studio
- existing database, migrating to / Migrating an existing database to Microsoft Azure
Windows Azure Storage
- about / Integrating Microsoft Azure Storage
- benefits / Integrating Microsoft Azure Storage
- database, creating / Creating a database that uses the Microsoft Azure Storage integration
- container policy / The container policy and Shared Access Signature
- Shared Access Signature (SAS), creating / The container policy and Shared Access Signature
- credential, creating / Creating a credential
- used, for creating database / Creating a database using Microsoft Azure Storage
- database backup, creating to / Database backups to a URL and Microsoft Azure Storage
- backup, restoring on / Restoring a backup stored on Windows Azure Storage
Windows Azure Storage account
- creating / Creating a Microsoft Azure Storage account and container
Windows Azure Storage container
- creating / Creating a Microsoft Azure Storage account and container
Windows Azure virtual machine
- about / Microsoft Azure Virtual Machines
- creating / Creating a Microsoft Azure Virtual Machine
Windows Azure Virtual Machines
- using, as replicas / Using Microsoft Azure Virtual Machines as replicas
Windows Server Failover Cluster
- URL / Windows Server Failover Cluster
Windows Server Failover Cluster (WSFC)
- about / Windows Server Failover Cluster

The rest of the chapter is locked

You have been reading a chapter from

Getting Started with SQL Server 2014 Administration

Published in: Apr 2014Publisher: PacktISBN-13: 9781782172413

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

undefined

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $15.99/month. Cancel anytime

Author (1)

Gethyn Ellis

Gethyn Ellis has over eighteen years of experience with SQL Server and for past ten years he has been working on Azure. He is an Microsoft certified trainer. He also trains and is a consultant for SQL Server. Prior to this he has worked with Packt and written books on "Getting Started SQL Server 2014 Administration" , "Microsoft Azure laaS Essentials", and Professional Azure SQL Database Administration.
Read more about Gethyn Ellis

Personalised recommendations for you

Based on your interests and search pattern

Et al.

Ever wonder why speech recognition systems don't understand the Scottish accent, or what would happen if an astronaut only ate mac 'n' cheese, or other spurious reflections you'd have at a bar? We did, then collated those deliberations into absurd research articles with fake figures and methodologies inspired by even more fictionally absurd studies.

BookAug 2023230 pages5

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages4

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages5

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages1

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages5

Mastering Tableau 2023

This book is a comprehensive resource to mastering your Tableau skills and becoming a BI expert. As you progress, you will learn how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.

BookAug 2023684 pages

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

BookSep 2023258 pages5

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

BookSep 2023258 pages2

Data Engineering with AWS

Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.

BookOct 2023636 pages5

Modern Data Architecture on AWS

Every organization wants an agile, performant, and cost-effective data platform that meets all their current and future business needs. Purpose-built AWS analytics services and their features play a big part in building such a modern data platform. This book brings to you all the design and architectural patterns that’ll help you achieve this goal.

BookAug 2023420 pages5

Practical Guide to Applied Conformal Prediction in Python

Discover the power of Conformal Prediction with the "Practical Guide to Applied Conformal Prediction in Python." Master the latest techniques to quantify uncertainty in machine learning and computer vision models, and seamlessly apply them to your industry applications.

BookDec 2023240 pages

TinyML Cookbook

With over 70 project-based recipes, the TinyML Cookbook is a practical guide that will help you to get the most out of your microcontrollers. It provides a comprehensive understanding of the theoretical foundations while giving you hands-on experience training ML models for deployment on Arduino Nano 33 BLE Sense, Raspberry Pi Pico, and SparkFun RedBoard Artemis Nano microcontrollers.

BookNov 2023664 pages