舉報 
會員
SQL Server 2019 Administrator's Guide
Asyouadvance,thebookcoversessentialtopicssuchasmigration,upgrading,andconsolidation,alongwiththetechniquesthatwillhelpyouwhenthingsgowrong.Onceyou’vegottogripswithintegrationwithAzureandstreamliningbigdatapipelines,you’lllearnbestpracticesfromindustryexpertsformaintainingahighlyreliabledatabasesolution.Whetheryouareanadministratororarelookingtogetstartedwithdatabaseadministration,thisSQLServerbookwillhelpyoudeveloptheskillsyouneedtosuccessfullycreate,design,anddeploydatabasesolutions.
目錄(88章)
倒序
- 封面
- 版權信息
- Why subscribe?
- Contributors About the authors
- About the reviewers
- Packt is searching for authors like you
- Preface
- Section 1: Provisioning the SQL Server Environment
- Chapter 1: Setting Up SQL Server 2019
- Overview of the Microsoft SQL Server 2019 technology
- Preparing the SQL Server 2019 installation on Windows
- Installing SQL Server 2019 on Windows
- Installing SQL Server 2019 on Linux
- Installing SQL Server 2019 on containers
- Summary
- Chapter 2: Keeping Your SQL Server Environment Healthy
- Understanding SQL Server patching
- Configuring SQL Server environment
- Creating a performance baseline
- Summary
- Section 2: Server and Database Maintenance
- Chapter 3: Implementing Backup and Recovery
- Data structures and transaction logging
- Accelerated Database Recovery
- SQL Server recovery models
- Designing a backup strategy
- Using database and log restore
- Summary
- Chapter 4: Securing Your SQL Server
- Configuring SQL Server service accounts
- Configuring authentication and authorization
- Encrypting SQL Server data
- Data Discovery and Classification
- SQL Server vulnerability assessment
- Encrypting SQL Server connections
- Summary
- Chapter 5: Working with Disaster Recovery Options
- Understanding the basics of disaster recovery
- SQL Server options for high availability and disaster recovery
- Configuring replication on SQL Server
- Understanding database mirroring
- Configuring log shipping
- Summary
- Chapter 6: Indexing and Performance
- Explaining SQL Server internals
- SQL Server protocols
- Performance monitoring overview
- Tools for monitoring performance
- Indexes and maintenance
- Common performance issue patterns
- Summary
- Section 3: High Availability and the Cloud with SQL Server 2019
- Chapter 7: Planning Migration and Upgrade
- The importance of keeping up with latest version
- Planning the upgrade
- Performing the upgrade
- Migrating from other platforms
- Summary
- Chapter 8: Automation – Using Tools to Manage and Monitor SQL Server 2019
- Using SQL Server Agent
- Creating and editing maintenance plans
- Creating SQL Server Agent objects
- SQL Server Agent security
- Summary
- Chapter 9: Configuring Always On High Availability Features
- Installing Windows Server Failover Cluster
- Configuring Always On Failover Cluster Instances
- Always On Availability Groups
- Summary
- Chapter 10: 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
- Monitoring In-Memory OLTP
- Summary
- Chapter 11: Combining SQL Server 2019 with Azure
- Beginning with technologies in Microsoft Azure
- Microsoft SQL Server 2019 and hybrid scenarios
- Quick overview of running SQL workloads in Azure
- Migrating SQL Server workloads to Azure
- Summary
- Chapter 12: Taming Big Data with SQL Server
- Big data overview
- Accessing external data with PolyBase
- Explaining the SQL Server Big Data Clusters architecture and deployment
- Working with a SQL Server Big Data Clusters workload
- Summary
- Other Books You May Enjoy 更新時間：2021-06-11 18:11:38
推薦閱讀
- 繪制進程圖：可視化D++語言（第1冊）
- Word 2000、Excel 2000、PowerPoint 2000上機指導與練習
- 輕松學PHP
- Hands-On Neural Networks with Keras
- Photoshop CS3圖像處理融會貫通
- WordPress Theme Development Beginner's Guide（Third Edition）
- Windows環境下32位匯編語言程序設計
- Splunk Operational Intelligence Cookbook
- Docker on Amazon Web Services
- 突破，Objective-C開發速學手冊
- 邊緣智能：關鍵技術與落地實踐
- 手機游戲程序開發
- 深度學習與目標檢測
- Linux嵌入式系統開發
- Photoshop CS4數碼照片處理入門、進階與提高
- Data Analysis with R（Second Edition）
- Kubernetes on AWS
- Microsoft Power BI Complete Reference
- Cloud Native Development Patterns and Best Practices
- Ubuntu 9 Linux應用基礎
- Python Data Mining Quick Start Guide
- 自動化生產線組建與調試（第2版）：以亞龍YL-335B為例（三菱PLC版本）
- Network Science with Python and NetworkX Quick Start Guide
- 超限學習機：理論、技術與應用
- C# Machine Learning Projects
- 黑客防線2012合訂本
- Java開發手冊
- SAS for Finance
- 智能運維之道：基于AI技術的應用實踐
- 汽油發動機電控系統核心控制算法
