
SQL Server 2017 Administrator's Guide
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Person
He earned his MSc (business and informatics) degree from Nottingham Trent University. He started his career as a trainer for Microsoft server courses. Later, he joined AT&T as a senior database administrator with a specialization in MSSQL Server, data platforms, and machine learning. Vladimir Muzny has been a freelance developer and consultant since 1997. His first steps with SQL Server were done on version 6.5 and from that times the working with all next versions of SQL Server has been never stopped.
Now Vladimir teaches Microsoft database courses and also participates on SQL Server adoption in companies and also on projects for production tracking and migrations.
SQL Server 2017 Administrator's Guide is his first attempt to share his knowledge and experience with people around the world, but writing is a strong drug and if possible, Vladimir is interested to share other namely his development experiences with others.
Content
- Cover
- Title Page
- Copyright
- Credits
- About the Authors
- About the Reviewer
- www.PacktPub.com
- Customer Feedback
- Table of Contents
- Preface
- Chapter 1: 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
- Chapter 2: 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
- Chapter 3: 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
- Chapter 4: 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
- Chapter 5: 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
- Chapter 6: 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
- Chapter 7: 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
- Chapter 8: 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
- Chapter 9: 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
- Chapter 10: 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
- Chapter 11: 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
- Chapter 12: 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
- Index
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.