SQL Server 2017 Administrator's Guide

Implement and administer successful database solution with SQL Server 2017

SQL Server 2017 Administrator's Guide

Marek Chmel, Vladimír Mužný

4 customer reviews
Implement and administer successful database solution with SQL Server 2017
Mapt Subscription
FREE
$20.83/m after trial
eBook
$30.80
RRP $43.99
Save 29%
Print + eBook
$54.99
RRP $54.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$30.80
$54.99
$29.99 p/m after trial
RRP $43.99
RRP $54.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


SQL Server 2017 Administrator's Guide Book Cover
SQL Server 2017 Administrator's Guide
$ 43.99
$ 30.80
SQL Server 2016 Developer's Guide Book Cover
SQL Server 2016 Developer's Guide
$ 47.99
$ 33.60
Buy 2 for $35.00
Save $56.98
Add to Cart

Book Details

ISBN 139781786462541
Paperback434 pages

Book Description

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.

Table of Contents

Chapter 7: Troubleshooting SQL Server Environment and Internals
Chapter 9: Automation - Using Tools to Manage and Monitor SQL Server 2017

What You Will Learn

  • Learn about the new features of SQL Server 2017 and how to implement them
  • Build a stable and fast SQL Server environment
  • Fix performance issues by optimizing queries and making use of indexes
  • Perform a health check of an existing troublesome database environment
  • Design and use an optimal database management strategy
  • Implement efficient backup and recovery techniques in-line with security policies
  • Combine SQL Server 2017 and Azure and manage your solution by various automation techniques Perform data migration, cluster upgradation and server consolidation

Authors

Table of Contents

Chapter 7: Troubleshooting SQL Server Environment and Internals
Chapter 9: Automation - Using Tools to Manage and Monitor SQL Server 2017

Book Details

ISBN 139781786462541
Paperback434 pages
Read More
From 4 reviews

Read More Reviews

Recommended for You

SQL Server 2016 Developer's Guide Book Cover
SQL Server 2016 Developer's Guide
$ 47.99
$ 33.60
SQL Server 2017 Developer's Guide Book Cover
SQL Server 2017 Developer's Guide
$ 43.99
$ 30.80
Microsoft Power BI Cookbook Book Cover
Microsoft Power BI Cookbook
$ 47.99
$ 33.60
Windows Server 2016 Administration Fundamentals Book Cover
Windows Server 2016 Administration Fundamentals
$ 31.99
$ 22.40
C# 7.1 and .NET Core 2.0 - Modern Cross-Platform Development - Third Edition Book Cover
C# 7.1 and .NET Core 2.0 - Modern Cross-Platform Development - Third Edition
$ 31.99
$ 22.40
SQL Server 2017 Developer's Guide Book Cover
SQL Server 2017 Developer's Guide
$ 43.99
$ 30.80