SQL Server 2017 Administrator's Guide
eBook - ePub

SQL Server 2017 Administrator's Guide

,
  1. English
  2. ePUB (mobile friendly)
  3. Only available on web
eBook - ePub

SQL Server 2017 Administrator's Guide

,
Book details
Table of contents
Citations

About This Book

Implement and administer successful database solution with SQL Server 2017About This Book• Master the required skills to successfully set up, administer, and maintain your SQL Server 2017 database solution• Design and configure, manage, and secure a rock-solid SQL server• Comprehensive guide in keeping your SQL server disaster proof and all-time availabilityWho This Book Is ForThis book targets database administrators with an interest in SQL Server 2017 administration. Readers are expected to have some experience with previous SQL Server versions.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 consolidationIn DetailTake 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.Style and approachA comprehensive guide for database professionals, covering a wide range of topics from installation, maintenance, and configuration to managing systems for operational efficiency and high availability; best practices for maintaining a highly reliable database solution are also supplied from industry experts.

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access SQL Server 2017 Administrator's Guide by in PDF and/or ePUB format, as well as other popular books in Computer Science & Databases. We have over one million books available in our catalogue for you to explore.

Information

Publisher
Packt Publishing
Year
2017
ISBN
9781786467324
Edition
1
Topic
Computer Science
Subtopic
Databases
Index
Computer Science

Table of contents

  1. Title Page
  2. Copyright
  3. Credits
  4. About the Authors
  5. About the Reviewer
  6. www.PacktPub.com
  7. Customer Feedback
  8. Preface
  9. Setting up SQL Server 2017
  10. Keeping Your SQL Server Environment Healthy
  11. Backup and Recovery
  12. Securing Your SQL Server
  13. Disaster Recovery Options
  14. Indexing and Performance
  15. Troubleshooting SQL Server Environment and Internals
  16. Migration and Upgrade
  17. Automation - Using Tools to Manage and Monitor SQL Server 2017
  18. Always On High Availability Features
  19. In-Memory OLTP - Why and How to Use it
  20. Combining SQL Server 2017 with Azure