SQL Server 2017 Administrators Guide

Marek Chmel, Vladimir Muzny

SQL Server 2017 Administrators Guide

買這商品的人也買了...

商品描述

Key Features

  • Master the 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
  • Make sure your SQL server is disaster-proof and always available with the help of this extensive guide

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 to quickly learn how to design, manage and secure your database solution.

You will learn how to set up your SQL Server and configure new as well as existing environments for optimal use. After covering the designing aspect, the book will dive into the performance tuning aspects by teaching you how to effectively use indexes. The book will also teach you about certain choices 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 to be used when things go wrong and other important topics like migration, upgrading and consolidation will be covered in detail. Integration with Azure is also covered in detail.

Whether you are an administrator or thinking about entering field, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2017.

What you will learn

  • Learn about the new features of SQL Server 2017 and learn 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, recovery and security techniques
  • Combine SQL Server 2017 and Azure and manage your solution by various automation techniques

商品描述(中文翻譯)

主要特點


  • 掌握成功建立、管理和維護 SQL Server 2017 資料庫解決方案的技能

  • 設計、配置、管理和保護堅固的 SQL Server

  • 通過這本詳盡的指南，確保您的 SQL Server 具有防災功能並始終可用

書籍描述

利用 SQL Server 2017 的真正威力，並涵蓋核心資料庫管理任務。本書將幫助您快速學習如何設計、管理和保護您的資料庫解決方案，從而獲得競爭優勢。

您將學習如何設置 SQL Server 並為新的和現有的環境進行配置，以實現最佳使用效果。在涵蓋設計方面之後，本書將深入探討性能調優方面，教您如何有效使用索引。本書還將教您關於備份的某些選擇以及如何實施堅固的安全策略並保持環境健康。最後，您將學習當事情出錯時應使用的技術，以及其他重要主題，如遷移、升級和合併，將被詳細介紹。還詳細介紹了與 Azure 的整合。

無論您是管理員還是考慮進入這個領域，本書都將為您提供成功使用 SQL Server 2017 創建、設計和部署資料庫所需的所有技能。

您將學到什麼


  • 了解 SQL Server 2017 的新功能並學習如何實施它們

  • 構建穩定且快速的 SQL Server 環境

  • 通過優化查詢和使用索引來解決性能問題

  • 對現有的問題資料庫環境進行健康檢查

  • 設計並使用最佳的資料庫管理策略

  • 實施高效的備份、恢復和安全技術

  • 結合 SQL Server 2017 和 Azure，並通過各種自動化技術管理您的解決方案

類似商品