Book Image

SQL Server 2017 Administrator's Guide

4 (1)
Book Image

SQL Server 2017 Administrator's Guide

4 (1)

Overview of this book

Take advantage of the real power of SQL Server 2017 with all its new features, in addition to covering core database administration tasks. This book will give you a competitive advantage by helping you quickly learn how to design, manage, and secure your database solution. You will learn how to set up your SQL Server and configure new (and existing) environments for optimal use. After covering the designing aspect, the book delves into performance-tuning aspects by teaching you how to effectively use indexes. The book will also teach you about certain choices that need to be made about backups and how to implement a rock-solid security policy and keep your environment healthy. Finally, you will learn about the techniques you should use when things go wrong, and other important topics, such as migration, upgrading, and consolidation, are covered in detail. Integration with Azure is also covered in depth. Whether you are an administrator or thinking about entering the field, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2017.

Related Content you might be interested in

Current Title:

Small book image
SQL Server 2017 Administrator's Guide
Dec, 2017 | 434 pages
Small book image
SQL Server on Azure Virtual Machines
Tim Radney | Anthony Nocentino | John Martin | Randolph West | Joey DAntoni | Louis Davidson | Allan Hirt
Jun, 2020 | 200 pages
Small book image
Introducing Microsoft SQL Server 2019
Dave Noderer | Gregory Woody | Kellyn Gorman | James RowlandJones | Mitchell Pearson | Dustin Ryan | Allan Hirt | Arun Sirpal
Apr, 2020 | 488 pages
Small book image
SQL Server on Linux
Jasmin Azemoviá
Aug, 2017 | 222 pages
Table of Contents (13 chapters)
Preface
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Free Chapter
1
Setting up SQL Server 2017
Setting up SQL Server 2017
Microsoft SQL Server 2017 technology overview
Preparing for installation
Installation process
Summary
2
Keeping Your SQL Server Environment Healthy
Keeping Your SQL Server Environment Healthy
Understanding SQL Server patching
Post-installation configuration
Creating a performance baseline
Summary
3
Backup and Recovery
Backup and Recovery
Data structures and transaction logging
Backup
Restore
Summary
4
Securing Your SQL Server
Securing Your SQL Server
SQL Server service accounts
Authentication and authorization
Encrypting SQL Server data
Summary
5
Disaster Recovery Options
Disaster Recovery Options
Disaster recovery basics
SQL Server options for high availability and disaster recovery
Configuring replication on SQL Server
Database mirroring
Log shipping
Summary
6
Indexing and Performance
Indexing and Performance
Performance monitoring overview
Tools for monitoring performance
Indexes and maintenance
Summary
7
Troubleshooting SQL Server Environment and Internals
Troubleshooting SQL Server Environment and Internals
SQL Server protocols
Performance monitoring and tuning
Summary
8
Migration and Upgrade
Migration and Upgrade
Why migration is necessary
Planning the upgrade
Performing the upgrade
Migration from other platforms
Summary
9
Automation - Using Tools to Manage and Monitor SQL Server 2017
Automation - Using Tools to Manage and Monitor SQL Server 2017
Using SQL Server Agent
Maintenance plans
SQL Server Agent objects
Summary
10
Always On High Availability Features
Always On High Availability Features
Installing Windows Server Failover Cluster
Always On Failover Cluster Instances
Always On Availability Groups
Summary
11
In-Memory OLTP - Why and How to Use it
In-Memory OLTP - Why and How to Use it
In-Memory OLTP architecture
Creating In-Memory tables and natively compiled stored procedures
In-Memory OLTP usage scenarios
Summary
12
Combining SQL Server 2017 with Azure
Combining SQL Server 2017 with Azure
Overview of data related technologies in Microsoft Azure
Microsoft SQL Server 2017 and hybrid scenarios
Summary

Securing Your SQL Server

Securing SQL Server is a crucial task, as SQL Server usually holds very important and sensitive information in your environment. You need to apply many principles in order to properly secure your databases. Fortunately, SQL Server offers you many options in order to help you with securing your data stored on the SQL Server. Securing a SQL Server is quite a complex task; you need to consider that SQL Server is a client application running on the Windows server, which is accessible via a network. In order to fully secure the environment, you need to secure the Windows OS too and put proper security measures on the network as well.

In this chapter, we will be covering the following topics:

  • SQL Server service accounts
  • Authentication and authorization
  • Encrypting SQL Server data
Previous Section
End of Section 1
Next Section