Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Title Page
Copyright
SQL Server 2017 Administrator's Guide
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
← Prev
Back
Next →
← Prev
Back
Next →