Home Page Icon
Home Page
Table of Contents for
Code Snippets
Close
Code Snippets
by Randolph West, Melody Zacharias, William Assaf,
SQL Server 2019 Administration Inside Out
Cover
Title Page
Copyright Page
Dedication Page
Contents at a Glance
Table of Contents
About the authors
Introduction
Acknowledgments
Errata, updates, & book support
Part I. Introduction
Chapter 1. Getting started with SQL Server tools
SQL Server setup
Tools and services installed with the SQL Server Database Engine
Performance and reliability monitoring tools
SQL Server Reporting Services
SQL Server Management Studio (SSMS)
Azure Data Studio
SQL Server Data Tools
A note on discontinued and deprecated features
Chapter 2. Introducing database server components
Memory
Central Processing Unit
Storing your data
Connecting to SQL Server over the network
High availability concepts
Securing SQL Server
Understanding virtualization and containers
Chapter 3. Designing and implementing an on-premises database infrastructure
Introduction to SQL Server database architecture
Data files and filegroups
Recording changes in the transaction log
Table partitioning
Compressing data
Managing the temporary database
Configuration settings
Container orchestration with Kubernetes
Part II. Deployment
Chapter 4. Installing and configuring SQL Server instances and features
What to do before installing SQL Server
Installing a new instance
Post-installation server configuration
Post-installation configuration of other features
Chapter 5. Installing and configuring SQL Server on Linux
What is Linux?
Considerations for installing SQL Server on Linux
Installing SQL Server on Linux
Configuring SQL Server for Linux
Caveats of SQL Server on Linux
Chapter 6. Provisioning and configuring SQL Server databases
Adding databases to a SQL Server instance
Moving and removing databases
Chapter 7. Understanding table features
Reviewing table design
Special table types
Storing BLOBs
Table partitioning
Capturing modifications to data
Part III. SQL Server management
Chapter 8. Maintaining and monitoring SQL Server
Detecting, preventing, and responding to database corruption
Maintaining indexes and statistics
Managing database file sizes
Monitoring activity by using DMOs
Monitoring with the SQL Assessment API
Utilizing extended events
Capturing performance metrics with DMOs and Data Collectors
Protecting important workloads by using Resource Governor
Understanding the new servicing model
Chapter 9. Automating SQL Server administration
Components of SQL Server automated administration
Maintaining SQL Server
Using SQL Server Maintenance Plans
Strategies for administering multiple SQL Servers
Using PowerShell to automate SQL Server administration
Chapter 10. Developing, deploying, and managing data recovery
Preparing for data recovery
Understanding different types of backups
Understanding backup devices
Creating and verifying backups
Restoring a database
Defining a recovery strategy
Chapter 11. Implementing high availability and disaster recovery
Overview of high availability and disaster recovery technologies in SQL Server
Configuring failover cluster instances
Designing availability groups solutions
Configuring availability groups in SQL Server on Linux
Administering availability groups
Part IV. Security
Chapter 12. Administering security and permissions
Authentication modes
Security principals
Permissions
Common security administration tasks
Chapter 13. Protecting data through encryption, privacy and auditing
Privacy in the modern era
Introducing security principles and protocols
Protecting the data platform
Auditing with SQL Server and Azure SQL Database
Securing Azure infrastructure as a service
Part V. Performance
Chapter 14. Performance tuning SQL Server
Understanding isolation levels and concurrency
Understanding durability settings for performance
Understanding how SQL Server executes your query
Understanding advanced engine features for tuning queries
Chapter 15. Understanding and designing indexes
Designing clustered indexes
Designing rowstore nonclustered indexes
Understanding columnstore indexes
Understanding indexing in memory-optimized tables
Understanding index statistics
Understanding other types of indexes
Part VI. Cloud
Chapter 16. Designing and implementing hybrid and Azure database infrastructure
Cloud computing and Microsoft Azure
Cloud models and SQL Server
Cloud security
Other data services in Azure
Chapter 17. Provisioning Azure SQL Database
Provisioning a logical SQL server
Provisioning a database in Azure SQL Database
Provisioning an elastic pool
Managing database space
Security in Azure SQL Database
Preparing Azure SQL Database for disaster recovery
Chapter 18. Provisioning Azure SQL Database managed instance
What is a Managed Instance?
Creating a managed instance
Establishing a connection
Migrating data to Managed Instance
Deleting a Managed Instance
Network requirements for Managed Instances
Managed Instance administration features
Azure SQL Analytics
Security of Managed Instance
Data protection features
Chapter 19. Migrating to SQL Server solutions in Azure
Migration Services Options
Common causes for migration failures
Integration Runtime options for Migration Services
Best Practices for security and resiliency during migration
Part VII. Big Data and Machine Learning
Chapter 20. Leveraging big data and machine learning
A big data primer
Introducing Big Data Clusters
Deploying Big Data Clusters
Benefits of PolyBase
Operationalizing analytics with Machine Learning Server
Launchpad service
Index
Code Snippets
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Code Snippets
Next
Next Chapter
Code Snippets
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset