更新时间：2021-07-02 21:52:17
封面
版权信息
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Why subscribe?
Customer Feedback
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
Setting up SQL Server 2017
Microsoft SQL Server 2017 technology overview
Understanding SQL Server DE
SQL Server integration services
Master Data Services
Data Quality Services
SQL Server Analysis Services
Multidimensional mode of SSAS installation
PowerPivot mode of SSAS installation
SQL Server Reporting Services
Machine learning services
SQL Server Agent
Conclusion
Preparing for installation
Edition comparison
Preinstallation tasks
Planning memory
Planning disk capacity
Software and other requirements
Security accounts for SQL Server
Installation process
Installation options
Installation wizard
Command line
New installation possibilities
Checking the completed installation
SQL Server services configuration node
SQL Server network configuration node
Testing connection to a fresh SQL Server
Summary
Keeping Your SQL Server Environment Healthy
Understanding SQL Server patching
Installing updates
Post-installation configuration
Configuring security rights for a SQL Server account
Configuring power settings
Configuring firewall rules
SQL Server post-installation configuration
Creating a performance baseline
Backup and Recovery
Data structures and transaction logging
How data is stored
Database
Database master
Database msdb
Database model
Database tempdb
Database resourcedb
Filegroup
Data files
Transaction log
Backup
Recovery model
Backup types
Full backup
Transaction log backup
Differential backup
Advanced backup scenarios
Backup media
Backup reliability
File or filegroup backup
Backup system databases
Backup summary
Restore
Preparing for restore
Executing restores
Using the full backup strategy
Using full and transaction log backup strategy
Point-in-time recovery
Using full transaction log and differential backup strategies
Using file or filegroup backups
Restoring data pages
System database restore
Securing Your SQL Server
SQL Server service accounts
Virtual accounts
Managed service accounts
Group managed service accounts
Domain accounts and local accounts
