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

Migration from other platforms

SQL Server migration projects don't necessarily include only SQL Server as a primary data source, but there are many other platforms where you may choose to upgrade to SQL Server. You can use SQL Server Migration Assistant (SSMA), which is available for several DMBS systems:

  • SSMA for access
  • SSMA for DB2
  • SSMA for Oracle
  • SSMA for SAP ASE
  • SSMA for MySQL

SSMA is able to create a project for a number of target versions of SQL Server, where SQL Server 2017 is included with both platforms—Linux and Windows operating systems. The other targets available are:

  • SQL Server 2008/2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2017 Windows/Linux
  • Azure SQL database
  • Azure SQL Data Warehouse

If you would like to use the tool for the migration, you need to have drivers for correct DBMS systems in place. For access migration, you...

Previous Section
End of Section 5
Next Section