Home Page Icon
Home Page
Table of Contents for
SQL Server 2017 Administration Inside Out
Close
SQL Server 2017 Administration Inside Out
by Randolph West, William Assaf, Sven Aelterman
SQL Server 2017 Administration Inside Out, First Edition
Cover Page
Title Page
Copyright Page
Dedication
Table of Contents
Foreword
Introduction
Chapter 1 Getting started with SQL Server tools
SQL Server setup
Tools and services installed with the SQL Server Database Engine
Performance and reliability monitoring tools
SQL Server Reporting Services
SQL Server Management Studio
SQL Server Data Tools
A note on deprecation
Chapter 2 Introducing database server components
Memory
Central Processing Unit
Storing your data
Connecting to SQL Server over the network
High availability concepts
Securing SQL Server
Abstracting hardware with virtualization
Summary
Chapter 3 Designing and implementing a database infrastructure
Physical database architecture
Configuration settings
Azure and the Data Platform
Chapter 4 Provisioning databases
What to do before installing SQL Server
Installing a new instance
Post-installation server configuration
Installing and configuring features
Adding databases to a SQL Server instance
Moving and removing databases
Chapter 5 Provisioning Azure SQL Database
Azure and database-as-a-service concepts
Provisioning a logical SQL server
Provisioning a database in Azure SQL Database
Provisioning an elastic pool
Limitations of Azure SQL Database
Security in Azure SQL Database
Preparing Azure SQL Database for disaster recovery
Moving to Azure SQL Database
Chapter 6 Administering security and permissions
Logins and users
Permissions in SQL Server
Moving SQL Server logins and permissions
Chapter 7 Securing the server and its data
Introducing security principles and protocols
Encryption in SQL Server
Securing data in motion
Auditing with SQL Server and Azure SQL Database
Securing Azure infrastructure as a service
Chapter 8 Understanding and designing tables
Reviewing table design
Special table types
Storing BLOBs
Table partitioning
Capturing modifications to data
Chapter 9 Performance tuning SQL Server
Understanding isolation levels and concurrency
Understanding delayed durability
Understanding execution plans
Using the Query Store feature
Understanding automatic plan correction
Understanding execution plan operators
Understanding parallelism
Chapter 10 Understanding and designing indexes
Designing clustered indexes
Designing nonclustered indexes
Designing Columnstore indexes
Understanding indexing in memory-optimized tables
Understanding other types of indexes
Understanding index statistics
Chapter 11 Developing, deploying, and managing data recovery
The fundamentals of data recovery
Understanding backup devices
Understanding different types of backups
Creating and verifying backups
Defining a recovery strategy
Chapter 12 Implementing high availability and disaster recovery
Overview of high availability and disaster recovery technologies in SQL Server
Configuring Failover Cluster Instances
Configuring availability groups
Configuring an availability group on Red Hat Linux
Administering availability groups
Chapter 13 Managing and monitoring SQL Server
Detecting database corruption
Maintaining indexes and statistics
Maintaining database file sizes
Monitoring databases by using DMVs
Reintroducing extended events
Capturing Windows performance metrics with DMVs and data collectors
Protecting important workloads using Resource Governor
Understanding the new servicing model
Chapter 14 Automating SQL Server administration
Components of SQL Server automated administration
SQL Server Agent
Maintaining SQL Server
Using SQL Server Maintenance Plans
Strategies for administering multiple SQL Servers
Using PowerShell to automate SQL Server administration
Index
About the authors
About the Foreword author
Code Snippets
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
SQL Server 2017 Administration Inside Out
Next
Next Chapter
SQL Server 2017 Administration Inside Out
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset