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
John Martin | Randolph West | Anthony Nocentino | Joey DAntoni | Louis Davidson | Allan Hirt | Tim Radney
Jun, 2020 | 200 pages
Small book image
Introducing Microsoft SQL Server 2019
Arun Sirpal | Gregory Woody | James RowlandJones | Dave Noderer | Kellyn Gorman | Allan Hirt | Mitchell Pearson | Dustin Ryan
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

Combining SQL Server 2017 with Azure

Cloud technologies have been growing over the last couple of years and nowadays they are able to cover every global, technical, or business need without compromise. SQL Server can be completely hosted in cloud environments; we would also have Microsoft SQL Server provisioned on-premise but we still use the advantages of cloud environment. In this chapter, we will provide an overview of what's possible in Azure when manipulating data, and then we will go through hybrid scenarios combining on-premise instances of SQL Server with Azure.

The main outcomes of this chapter are:

  • Overview of data related technologies in Microsoft Azure: In this chapter, a set of server and serverless technologies will be described
  • Microsoft SQL Server 2017 and hybrid scenarios: This chapter offers end-to-end and step-by-step samples of several features such...
Previous Section
End of Section 1
Next Section