最新章節
- Summary
- Snapshot backups
- Backup to a URL
- Managed backup to Azure
- Backups to Azure
- Data files in Azure
品牌：中圖公司
上架時間：2021-07-02 18:41:41
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Summary 更新時間：2021-07-02 21:52:17
- Snapshot backups
- Backup to a URL
- Managed backup to Azure
- Backups to Azure
- Data files in Azure
- StretchDB
- Microsoft SQL Server 2017 and hybrid scenarios
- Using Azure SQL Data Warehouse
- Creating Azure SQL Data Warehouse
- Azure SQL Data Warehouse
- Using Azure SQL Server
- Creating Azure SQL Server
- Understanding Azure SQL Server
- Creating the Azure SQL database
- Starting with Azure portal
- Understanding Azure SQL database
- Overview of data related technologies in Microsoft Azure
- Combining SQL Server 2017 with Azure
- Summary
- Example 3 – improving real-time analytics
- Example 2 – updating data in an In-Memory table
- Example 1 – inserting incoming data into In-Memory tables
- Assignment of the user story sample
- In-Memory OLTP usage scenarios
- Monitoring In-Memory OLTP
- Migrating disk-based objects to In-Memory OLTP
- Natively compiled stored procedures
- Creating tables with indexes
- Creating In-Memory OLTP objects
- Preparing for In-Memory OLTP
- Creating In-Memory tables and natively compiled stored procedures
- In-Memory OLTP limitations
- Cooperation of disk-based and memory-based parts of SQL Server
- Request processing differences in OLTP
- Data storage differences in OLTP
- In-Memory OLTP architecture
- In-Memory OLTP - Why and How to Use it
- Summary
- Distributed Availability Groups
- Basic Availability Groups
- Failover and monitoring
- Creating an Availability Group
- Configuring Always On Availability Groups
- Always On Availability Groups
- Initiating a failover
- Adding nodes to the SQL Server Failover Cluster
- Always On Failover Cluster Instances
- Installing Windows Server Failover Cluster
- Always On High Availability Features
- Summary
- Alerts
- Monitoring and troubleshooting jobs
- Notification definition
- Schedule definition
- Job steps definition
- Job definition
- Jobs
- Operators
- SQL Server Agent objects
- Maintenance plan designer
- Maintenance cleanup task
- Backup tasks
- Execute SQL Server Agent job
- Clean up history
- Update statistics
- Rebuild index
- Reorganize index
- Shrink database
- Check database integrity
- Maintenance plan wizard
- Maintenance plans
- Sending emails from SQL Server
- Database mail setup
- Setting up SQL Server Agent Properties
- SQL Server Agent service setup
- Using SQL Server Agent
- Automation - Using Tools to Manage and Monitor SQL Server 2017
- Summary
- Migration example from MS Access
- Migration from other platforms
- Upgrading Reporting Services 2017
- Performing the upgrade
- SQL Server system configuration checker
- Data Migration Assistant
- Pre-upgrade checks
- Rolling upgrade
- Side-by-side migration
- SQL Server in-place upgrade
- Upgrade scenarios
- Planning the upgrade
- Why migration is necessary
- Migration and Upgrade
- Summary
- CXPACKET
- PAGELATCH
- PAGEIOLATCH
- Troubleshooting wait statistics
- SQL Server storage monitoring and troubleshooting
- SQL Server memory monitoring and troubleshooting
- Performance monitoring and tuning
- The storage engine layer
- Query processor
- SQL Server protocols
- Troubleshooting SQL Server Environment and Internals
- Summary
- Indexing considerations
- Other index types
- Columnstore indexes
- Non-clustered and clustered index cooperation
- Clustered B-tree index
- Non-clustered B-tree index
- Heap
- Types of indexes
- Indexes and maintenance
- Query Store
- Viewing data collection reports
- Collecting performance data
- Setting up MDW
- Data collection
- How to use dynamic management
- Dynamic management
- Extended Events
- SQL Trace
- SQL Server Profiler
- SQL Server Profiler and SQL Trace
- Performance monitor
- Recent Expensive Queries and Active Expensive Queries
- Data File I/O
- Resource Waits
- Section processes
- Overview
- Activity Monitor
- Tools for monitoring performance
- Performance monitoring overview
- Indexing and Performance
- Summary
- Switching log shipping roles
- Log shipping
- Configuring database mirroring
- Database mirroring
- Replication agents
- Configuring the subscription
- Creating a Publication
- Configuring replication on SQL Server
- Replication
- Log shipping
- Database mirroring
- Always On Availability Groups
- Always On Failover Cluster
- SQL Server options for high availability and disaster recovery
- Disaster recovery basics
- Disaster Recovery Options
- Summary
- Always encrypted
- Transparent data encryption
- Encrypting SQL Server data
- Credentials and proxies in the SQL Server Agent
- Configuring credentials
- Server audit specifications
- Configuring server audit
- Auditing
- Working with permissions on the server
- Fixed server roles
- Authorization
- Managing login properties
- Server logins
- Authentication
- Authentication and authorization
- Domain accounts and local accounts
- Group managed service accounts
- Managed service accounts
- Virtual accounts
- SQL Server service accounts
- Securing Your SQL Server
- Summary
- System database restore
- Restoring data pages
- Using file or filegroup backups
- Using full transaction log and differential backup strategies
- Point-in-time recovery
- Using full and transaction log backup strategy
- Using the full backup strategy
- Executing restores
- Preparing for restore
- Restore
- Backup summary
- Backup system databases
- File or filegroup backup
- Backup reliability
- Backup media
- Advanced backup scenarios
- Differential backup
- Transaction log backup
- Full backup
- Backup types
- Recovery model
- Backup
- Transaction log
- Data files
- Filegroup
- Database resourcedb
- Database tempdb
- Database model
- Database msdb
- Database master
- Database
- How data is stored
- Data structures and transaction logging
- Backup and Recovery
- Summary
- Creating a performance baseline
- SQL Server post-installation configuration
- Configuring firewall rules
- Configuring power settings
- Configuring security rights for a SQL Server account
- Post-installation configuration
- Installing updates
- Understanding SQL Server patching
- Keeping Your SQL Server Environment Healthy
- Summary
- Testing connection to a fresh SQL Server
- SQL Server network configuration node
- SQL Server services configuration node
- Checking the completed installation
- New installation possibilities
- Command line
- Installation wizard
- Installation options
- Installation process
- Security accounts for SQL Server
- Software and other requirements
- Planning disk capacity
- Planning memory
- Preinstallation tasks
- Edition comparison
- Preparing for installation
- Conclusion
- SQL Server Agent
- Machine learning services
- SQL Server Reporting Services
- PowerPivot mode of SSAS installation
- Multidimensional mode of SSAS installation
- SQL Server Analysis Services
- Data Quality Services
- Master Data Services
- SQL Server integration services
- Understanding SQL Server DE
- Microsoft SQL Server 2017 technology overview
- Setting up SQL Server 2017
- Questions
- Piracy
- Errata
- Downloading the example code
- Customer support
- Reader feedback
- Conventions
- Who this book is for
- What you need for this book
- What this book covers
- Preface
- Customer Feedback
- Why subscribe?
- www.PacktPub.com
- About the Reviewer
- About the Authors
- Credits
- 版權信息
- 封面
- 封面
- 版權信息
- 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
