Microsoft SQL Server 2017 on Linux
1st Edition
Published on 8. June 2018
322 pages
978-1-260-12114-8 (ISBN)
Available for download
Description
Essential Microsoft(R) SQL Server(R) 2017 installation, configuration, and management techniques for LinuxForeword by Kalen Delaney, Microsoft SQL Server MVPThis comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear coverage of both Linux and SQL Server and complete explanations of the latest features, tools, and techniques. The book offers clear instruction on adaptive query processing, automatic tuning, disaster recovery, security, and much more.*Understand how SQL Server 2017 on Linux works*Install and configure SQL Server on Linux*Run SQL Server on Docker containers*Learn Linux Administration*Troubleshoot and tune query performance in SQL Server*Learn what is new in SQL Server 2017*Work with adaptive query processing and automatic tuning techniques*Implement high availability and disaster recovery for SQL Server on Linux*Learn the security features available in SQL Server
More details
Other editions
Additional editions
Benjamin Nevarez
Microsoft SQL Server 2017 on Linux
Book
07/2018
McGraw-Hill Education
€51.50
Shipment within 10-20 days
Content
- Cover
- Title Page
- Copyright Page
- Dedication
- Contents
- Foreword
- Acknowledgments
- Introduction
- Chapter 1 SQL Server on Linux: Getting Started
- Creating a Virtual Machine
- Step 1. Basics: Configure Basic Settings
- Step 2. Size: Choose Virtual Machine Size
- Step 3. Settings: Configure Optional Features
- Step 4. Summary and Purchase
- Installing SQL Server
- Configuring SQL Server
- Intro to Unix Commands
- Connecting to SQL Server
- Installing Additional Components
- Installing on Ubuntu
- Installing on SUSE Linux Enterprise Server
- Running SQL Server on Docker
- Uninstalling SQL Server
- Summary
- Chapter 2 How SQL Server on Linux Works
- The Sybase Years
- SQLOS
- The Industry Changes
- Project Helsinki
- A Virtualization Surprise
- Drawbridge
- Looking for a Shortcut
- SQLPAL
- Summary
- Chapter 3 Linux for the SQL Server Professional
- Getting Started
- Files and Directories
- Files
- The Unix File System
- Additional Commands
- Building a Command
- Permissions
- Bash Shell
- Services Management
- Software Management
- Disk Management
- System Monitoring
- Summary
- Chapter 4 SQL Server Configuration
- The mssql-conf Utility
- Using Variables
- Linux Settings
- Kernel Settings
- Transparent Huge Pages
- Swap File
- Last Accessed Date/Time
- SQL Server Configuration
- Linux Out-of-Memory Killer
- tempdb Configuration
- Process Affinity
- Max Degree of Parallelism
- Cost Threshold for Parallelism
- Statistics
- Trace Flag 2371
- Summary
- Chapter 5 SQL Server Query Tuning and Optimization
- Query Performance
- Query Processor Architecture
- Parsing and Binding
- Query Optimization
- Generating Candidate Execution Plans
- Assessing the Cost of Each Plan
- Query Execution and Plan Caching
- Execution Plans
- Graphical Plans
- XML Plans
- Text Plans
- Query Troubleshooting
- sys.dm_exec_requests and sys.dm_exec_sessions
- sys.dm_exec_query_stats
- statement_start_offset and statement_end_offset
- sql_handle and plan_handle
- query_hash and plan_hash
- Finding Expensive Queries
- SET STATISTICS TIME / IO
- Indexes
- Creating Indexes
- Clustered Indexes vs. Heaps
- Clustered Index Key
- Statistics
- Creating and Updating Statistics
- The New Cardinality Estimator
- Cardinality Estimation Errors
- Statistics Maintenance
- Parameter Sniffing
- Optimizing for a Typical Parameter
- Optimizing on Every Execution
- Using Local Variables and the OPTIMIZE FOR UNKNOWN Hint
- Disabling Parameter Sniffing
- Query Processor Limitations
- Query Optimization Research
- Break Down Complex Queries
- Hints
- Summary
- Chapter 6 New Query Processing Features
- Adaptive Query Processing
- Batch Mode Adaptive Joins
- Batch Mode Adaptive Memory Grant Feedback
- Interleaved Execution for Multistatement Table-Value Functions
- Automatic Tuning
- SQL Server 2016 Service Pack 1
- USE HINT Query Option
- CXPACKET and CXCONSUMER Waits
- Wait Statistics on Execution Plans
- Recent Announcements
- Summary
- Chapter 7 High Availability and Disaster Recovery
- SQL Server High-Availability and Disaster-Recovery Features
- Always On Availability Groups
- Availability Groups on Windows vs. Linux
- Implementing Availability Groups
- T-SQL Configuration
- SQL Server Management Studio Configuration
- Configuring Pacemaker on Red Hat Enterprise Linux
- Configuring Pacemaker on Ubuntu
- Operating an Availability Group Resource
- Summary
- Chapter 8 Security
- Introduction to Security on SQL Server
- Transparent Data Encryption
- Attach or Restore a TDE Database to Another SQL Server Instance
- Always Encrypted
- Row-Level Security
- Dynamic Data Masking
- Summary
- Index
