目錄(269章)
倒序
- 封面
- 版權信息
- 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
- Summary
- 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
- Summary
- Securing Your SQL Server
- SQL Server service accounts
- Virtual accounts
- Managed service accounts
- Group managed service accounts
- Domain accounts and local accounts
- Authentication and authorization
- Authentication
- Server logins
- Managing login properties
- Authorization
- Fixed server roles
- Working with permissions on the server
- Auditing
- Configuring server audit
- Server audit specifications
- Configuring credentials
- Credentials and proxies in the SQL Server Agent
- Encrypting SQL Server data
- Transparent data encryption
- Always encrypted
- Summary
- Disaster Recovery Options
- Disaster recovery basics
- SQL Server options for high availability and disaster recovery
- Always On Failover Cluster
- Always On Availability Groups
- Database mirroring
- Log shipping
- Replication
- Configuring replication on SQL Server
- Creating a Publication
- Configuring the subscription
- Replication agents
- Database mirroring
- Configuring database mirroring
- Log shipping
- Switching log shipping roles
- Summary
- Indexing and Performance
- Performance monitoring overview
- Tools for monitoring performance
- Activity Monitor
- Overview
- Section processes
- Resource Waits
- Data File I/O
- Recent Expensive Queries and Active Expensive Queries
- Performance monitor
- SQL Server Profiler and SQL Trace
- SQL Server Profiler
- SQL Trace
- Extended Events
- Dynamic management
- How to use dynamic management
- Data collection
- Setting up MDW
- Collecting performance data
- Viewing data collection reports
- Query Store
- Indexes and maintenance
- Types of indexes
- Heap
- Non-clustered B-tree index
- Clustered B-tree index
- Non-clustered and clustered index cooperation
- Columnstore indexes
- Other index types
- Indexing considerations
- Summary
- Troubleshooting SQL Server Environment and Internals
- SQL Server protocols
- Query processor
- The storage engine layer
- Performance monitoring and tuning
- SQL Server memory monitoring and troubleshooting
- SQL Server storage monitoring and troubleshooting
- Troubleshooting wait statistics
- PAGEIOLATCH
- PAGELATCH
- CXPACKET
- Summary
- Migration and Upgrade
- Why migration is necessary
- Planning the upgrade
- Upgrade scenarios
- SQL Server in-place upgrade
- Side-by-side migration
- Rolling upgrade
- Pre-upgrade checks
- Data Migration Assistant
- SQL Server system configuration checker
- Performing the upgrade
- Upgrading Reporting Services 2017
- Migration from other platforms
- Migration example from MS Access
- Summary
- Automation - Using Tools to Manage and Monitor SQL Server 2017
- Using SQL Server Agent
- SQL Server Agent service setup
- Setting up SQL Server Agent Properties
- Database mail setup
- Sending emails from SQL Server
- Maintenance plans
- Maintenance plan wizard
- Check database integrity
- Shrink database
- Reorganize index
- Rebuild index
- Update statistics
- Clean up history
- Execute SQL Server Agent job
- Backup tasks
- Maintenance cleanup task
- Maintenance plan designer
- SQL Server Agent objects
- Operators
- Jobs
- Job definition
- Job steps definition
- Schedule definition
- Notification definition
- Monitoring and troubleshooting jobs
- Alerts
- Summary
- Always On High Availability Features
- Installing Windows Server Failover Cluster
- Always On Failover Cluster Instances
- Adding nodes to the SQL Server Failover Cluster
- Initiating a failover
- Always On Availability Groups
- Configuring Always On Availability Groups
- Creating an Availability Group
- Failover and monitoring
- Basic Availability Groups
- Distributed Availability Groups
- Summary
- In-Memory OLTP - Why and How to Use it
- In-Memory OLTP architecture
- Data storage differences in OLTP
- Request processing differences in OLTP
- Cooperation of disk-based and memory-based parts of SQL Server
- In-Memory OLTP limitations
- Creating In-Memory tables and natively compiled stored procedures
- Preparing for In-Memory OLTP
- Creating In-Memory OLTP objects
- Creating tables with indexes
- Natively compiled stored procedures
- Migrating disk-based objects to In-Memory OLTP
- Monitoring In-Memory OLTP
- In-Memory OLTP usage scenarios
- Assignment of the user story sample
- Example 1 – inserting incoming data into In-Memory tables
- Example 2 – updating data in an In-Memory table
- Example 3 – improving real-time analytics
- Summary
- Combining SQL Server 2017 with Azure
- Overview of data related technologies in Microsoft Azure
- Understanding Azure SQL database
- Starting with Azure portal
- Creating the Azure SQL database
- Understanding Azure SQL Server
- Creating Azure SQL Server
- Using Azure SQL Server
- Azure SQL Data Warehouse
- Creating Azure SQL Data Warehouse
- Using Azure SQL Data Warehouse
- Microsoft SQL Server 2017 and hybrid scenarios
- StretchDB
- Data files in Azure
- Backups to Azure
- Managed backup to Azure
- Backup to a URL
- Snapshot backups
- Summary 更新時間：2021-07-02 21:52:17
推薦閱讀
- Machine Learning for Cybersecurity Cookbook
- 網絡服務器架設（Windows Server+Linux Server）
- Linux Mint System Administrator’s Beginner's Guide
- 傳感器技術實驗教程
- Dreamweaver CS3網頁設計與網站建設詳解
- 大數據技術與應用
- 大數據驅動的設備健康預測及維護決策優化
- 基于32位ColdFire構建嵌入式系統
- 傳感器與新聞
- 軟件工程及實踐
- AI的25種可能
- 在實戰中成長：C++開發之路
- 智能鼠原理與制作（進階篇）
- 智能小車機器人制作大全（第2版）
- 網絡安全原理與應用
- Qt中的C++技術
- Proteus從入門到精通100例
- 單片機數據通信及測控應用技術詳解
- 一本書讀懂大數據（全彩圖解版）
- ABB工業機器人應用技術全集
- Hands-On Serverless Computing
- 初入職場之嵌入式Linux開發快速上手
- 撥開CCNA迷霧
- 機器學習算法實踐：推薦系統的協同過濾理論及其應用
- 排爆機器人的研究與開發
- Python Machine Learning By Example
- 大數據與人工智能導論
- Mastering pandas
- 基于Hadoop與Spark的大數據開發實戰
- 大道至簡：軟件工程實踐者的思想
