Muutke küpsiste eelistusi

E-raamat: Microsoft SQL Server 2017 on Linux

2.00/5 (1 hinnangut Goodreads-ist)
  • Formaat: PDF+DRM
  • Ilmumisaeg: 08-Jun-2018
  • Kirjastus: McGraw-Hill Education
  • Keel: eng
  • ISBN-13: 9781260121148
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 46,80 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Microsoft SQL Server 2017 on LinuxSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 08-Jun-2018
  • Kirjastus: McGraw-Hill Education
  • Keel: eng
  • ISBN-13: 9781260121148
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Essential Microsoft® SQL Server® 2017 installation, configuration, and management techniques for Linux

This 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, configure, and connect to SQL Server
•Administer files, directories, users, and permissions
•Handle disk management and system management
•Learn to apply the latest Linux techniques for SQL Server 
•Use the mssql-conf utility to tweak and customize settings
•Troubleshoot and tune query performance using the query optimizer
•Work with adaptive query processing and automatic tuning
•Manage high availability and disaster recovery for SQL Server on Linux


Foreword xiii
Acknowledgments xv
Introduction xviii
Chapter 1 SQL Server on Linux: Getting Started
1(40)
Creating a Virtual Machine
2(9)
Step 1 Basics: Configure Basic Settings
5(1)
Step 2 Size: Choose Virtual Machine Size
6(1)
Step 3 Settings: Configure Optional Features
7(2)
Step 4 Summary and Purchase
9(2)
Installing SQL Server
11(5)
Configuring SQL Server
16(3)
Intro to Unix Commands
18(1)
Connecting to SQL Server
19(7)
Installing Additional Components
26(4)
Installing on Ubuntu
30(3)
Installing on SUSE Linux Enterprise Server
33(2)
Running SQL Server on Docker
35(4)
Uninstalling SQL Server
39(1)
Summary
39(2)
Chapter 2 How SQL Server on Linux Works
41(16)
The Sybase Years
43(2)
SQLOS
45(2)
The Industry Changes
47(1)
Project Helsinki
48(2)
A Virilization Surprise
50(1)
Drawbridge
51(2)
Looking for a Shortcut
51(2)
SQLPAL
53(3)
Summary
56(1)
Chapter 3 Linux for the SQL Server Professional
57(36)
Getting Started
58(3)
Files and Directories
61(9)
Files
64(4)
The Unix File System
68(2)
Additional Commands
70(7)
Building a Command
75(2)
Permissions
77(2)
Bash Shell
79(3)
Services Management
82(3)
Software Management
85(3)
Disk Management
88(2)
System Monitoring
90(2)
Summary
92(1)
Chapter 4 SQL Server Configuration
93(28)
The mssql-conf Utility
94(7)
Using Variables
100(1)
Linux Settings
101(7)
Kernel Settings
102(4)
Transparent Huge Pages
106(1)
Swap File
107(1)
Last Accessed Date/Time
108(1)
SQL Server Configuration
108(11)
Linux Out-of-Memory Killer
109(1)
Tempdb Configuration
110(4)
Process Affinity
114(1)
Max Degree of Parallelism
114(1)
Cost Threshold for Parallelism
115(1)
Statistics
116(3)
Trace Flag 2371
119(1)
Summary
119(2)
Chapter 5 SQL Server Query Tuning and Optimization
121(54)
Query Performance
122(1)
Query Processor Architecture
123(6)
Parsing and Binding
125(1)
Query Optimization
126(1)
Generating Candidate Execution Plans
126(1)
Assessing the Cost of Each Plan
127(1)
Query Execution and Plan Caching
128(1)
Execution Plans
129(7)
Graphical Plans
130(4)
XML Plans
134(2)
Text Plans
136(1)
Query Troubleshooting
136(12)
sys.dm_exec_requests and sys.dm_exec_sessions
137(2)
sys.dm_exec_query_stats
139(2)
statement_start_offset and statement_end_offset
141(1)
Sql-handle and plan-handle
142(1)
Query-hash and plan-hash
143(2)
Finding Expensive Queries
145(1)
Set Statistics Time/IO
146(2)
Indexes
148(6)
Creating Indexes
149(3)
Clustered Indexes vs. Heaps
152(1)
Clustered Index Key
153(1)
Statistics
154(8)
Creating and Updating Statistics
155(2)
The New Cardinality Estimator
157(2)
Cardinality Estimation Errors
159(2)
Statistics Maintenance
161(1)
Parameter Sniffing
162(6)
Optimizing for a Typical Parameter
165(1)
Optimizing on Every Execution
165(1)
Using Local Variables and the Optimize For Unknown Hint
166(2)
Disabling Parameter Sniffing
168(1)
Query Processor Limitations
168(6)
Query Optimization Research
169(1)
Break Down Complex Queries
170(1)
Hints
171(3)
Summary
174(1)
Chapter 6 New Query Processing Features
175(28)
Adaptive Query Processing
177(12)
Batch Mode Adaptive Joins
178(4)
Batch Mode Adaptive Memory Grant Feedback
182(3)
Interleaved Execution for Multistatement Table-Value Functions
185(4)
Automatic Tuning
189(5)
SQL Server 2016 Service Pack 1
194(1)
USE HINT Query Option
195(4)
CXPACKET and CXCONSUMER Waits
199(1)
Wait Statistics on Execution Plans
200(1)
Recent Announcements
200(1)
Summary
201(2)
Chapter 7 High Availability and Disaster Recovery
203(46)
SQL Server High-Availability and Disaster-Recovery Features
204(2)
Always On Availability Groups
206(2)
Availability Groups on Windows vs. Linux
208(1)
Implementing Availability Groups
209(37)
T-SQL Configuration
211(6)
SQL Server Management Studio Configuration
217(11)
Configuring Pacemaker on Red Hat Enterprise Linux
228(12)
Configuring Pacemaker on Ubuntu
240(4)
Operating an Availability Group Resource
244(2)
Summary
246(3)
Chapter 8 Security
249(22)
Introduction to Security on SQL Server
250(2)
Transparent Data Encryption
252(5)
Attach or Restore a TDE Database to Another SQL Server Instance
254(3)
Always Encrypted
257(9)
Row-Level Security
266(2)
Dynamic Data Masking
268(2)
Summary
270(1)
Index 271
Benjamin Nevarez is a database professional who specializes in SQL Server query tuning and optimization. He is the author of High Performance SQL Server, SQL Server 2014 Query Tuning and Optimization, and Inside the SQL Server Query Optimizer.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97812601211482e.html
Märksõnad: