Atjaunināt sīkdatņu piekrišanu

E-grāmata: Pro SQL Server on Linux: Including Container-Based Deployment with Docker and Kubernetes

4.50/5 (8 ratings by Goodreads)
  • Formāts: PDF+DRM
  • Izdošanas datums: 27-Oct-2018
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781484241288
Citas grāmatas par šo tēmu:
  • Formāts - PDF+DRM
  • Cena: 77,31 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
  • Šī e-grāmata paredzēta tikai personīgai lietošanai. E-grāmatas nav iespējams atgriezt un nauda par iegādātajām e-grāmatām netiek atmaksāta.
Pro SQL Server on Linux: Including Container-Based Deployment with Docker and KubernetesPalielināt
  • Formāts: PDF+DRM
  • Izdošanas datums: 27-Oct-2018
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781484241288
Citas grāmatas par šo tēmu:

DRM restrictions

  • Kopēšana (kopēt/ievietot):

    nav atļauts

  • Drukāšana:

    nav atļauts

  • Lietošana:

    Digitālo tiesību pārvaldība (Digital Rights Management (DRM))
    Izdevējs ir piegādājis šo grāmatu šifrētā veidā, kas nozīmē, ka jums ir jāinstalē bezmaksas programmatūra, lai to atbloķētu un lasītu. Lai lasītu šo e-grāmatu, jums ir jāizveido Adobe ID. Vairāk informācijas šeit. E-grāmatu var lasīt un lejupielādēt līdz 6 ierīcēm (vienam lietotājam ar vienu un to pašu Adobe ID).

    Nepieciešamā programmatūra
    Lai lasītu šo e-grāmatu mobilajā ierīcē (tālrunī vai planšetdatorā), jums būs jāinstalē šī bezmaksas lietotne: PocketBook Reader (iOS / Android)

    Lai lejupielādētu un lasītu šo e-grāmatu datorā vai Mac datorā, jums ir nepieciešamid Adobe Digital Editions (šī ir bezmaksas lietotne, kas īpaši izstrādāta e-grāmatām. Tā nav tas pats, kas Adobe Reader, kas, iespējams, jau ir jūsu datorā.)

    Jūs nevarat lasīt šo e-grāmatu, izmantojot Amazon Kindle.

Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guide by one of the most respected experts on SQL Server in the industry. Get an inside look at how SQL Server for Linux works through the eyes of an engineer on the team that made it possible.

Microsoft SQL Server is one of the leading database platforms in the industry, and SQL Server 2017 offers developers and administrators the ability to run a database management system on Linux, offering proven support for enterprise-level features and without onerous licensing terms. Organizations invested in Microsoft and open source technologies are now able to run a unified database platform across all their operating system investments. Organizations are further able to take full advantage of containerization through popular platforms such as Docker and Kubernetes. 

Pro SQL Server on Linux walks you through installing and configuring SQL Server on the Linux platform. The author is one of the principal architects of SQL Server for Linux, and brings a corresponding depth of knowledge that no database professional or developer on Linux will want to be without. Throughout this book are internals of how SQL Server on Linux works including an in depth look at the innovative architecture.

The book covers day-to-day management and troubleshooting, including diagnostics and monitoring, the use of containers to manage deployments, and the use of self-tuning and the in-memory capabilities. Also covered are performance capabilities, high availability, and disaster recovery along with security and encryption. The book covers the product-specific knowledge to bring SQL Server and its powerful features to life on the Linux platform, including coverage of containerization through Docker and Kubernetes.


What You'll Learn

  • Learn about the history and internal of the unique SQL Server on Linux architecture.
  • Install and configure Microsoft’s flagship database product on the Linux platform
  • Manage your deployments using container technology through Docker and Kubernetes
  • Know the basics of building databases, the T-SQL language, and developing applications against SQL Server on Linux
  • Use tools and features to diagnose, manage, and monitor SQL Server on Linux
  • Scale your application by learning the performance capabilities of SQL Server
  • Deliver high availability and disaster recovery to ensure business continuity
  • Secure your database from attack, and protect sensitive data through encryption
  • Take advantage of powerful features such as Failover Clusters, Availability Groups, In-Memory Support, and SQL Server’s Self-Tuning Engine
  • Learn how to migrate your database from older releases of SQL Server and other database platforms such as Oracle and PostgreSQL
  • Build and maintain schemas, and perform management tasks from both GUI and command line

Who This Book Is For

Developers and IT professionals who are new to SQL Server and wish to configure it on the Linux operating system. This book is also useful to those familiar with SQL Server on Windows who want to learn the unique aspects of managing SQL Server on the Linux platform and Docker containers. Readers should have a grasp of relational database concepts and be comfortable with the SQL language. 
About the Author xv
About the Technical Reviewer xvii
Acknowledgments xix
Foreword xxi
Introduction xxv
Chapter 1 Why SQL Server on Linux? 1(22)
Platform of Choice
2(1)
How We Built It
3(11)
Drawbridge
4(2)
SOLOS, SQLPAL, and Helsinki
6(2)
The SQL Server on Linux Architecture
8(6)
SQL Server on Windows vs. Linux. Is it the Same?
14(5)
SQL Server on Linux Capabilities
14(3)
What Features Are Not Available
17(1)
Should I Use Windows or Linux?
18(1)
Containers Are the New Virtual Machine
19(3)
Database Containers
20(1)
Platform Independence, Portability, and Consistency
20(1)
Continuous Integration/Continuous Deployment
21(1)
Kubernetes
21(1)
Summary
22(1)
Chapter 2 Install and Configuration 23(54)
Preparing for Install
23(11)
Linux Distributions
24(2)
System Requirements
26(1)
Testing for SQL Server
27(1)
Linux Tips
28(6)
Just Install It!
34(8)
Deploy in 60 Seconds
35(1)
Download a Repository Config File
36(1)
Do the Install of the SQL Server Engine
37(2)
Complete the Setup of SQL Server
39(3)
The Complete Installation Experience
42(19)
Installing Other Versions
42(2)
Verifying Install
44(8)
Unattended Install
52(1)
Offline Install
53(2)
Installing Other Packages
55(1)
Installing in Azure
56(2)
Troubleshooting Install
58(3)
Exploring SQL Server on Linux
61(3)
What Is Installed
61(2)
Using Log Files
63(1)
Post-Install Configuration
64(7)
Using mssql-conf
64(5)
SQL Server Instance Configuration
69(1)
Windows Configuration Options on Linux
70(1)
Updates and Uninstall
71(4)
Updating SQL Server
71(2)
Rolling Back to a Previous Update
73(1)
Removing SQL Server
74(1)
Summary
75(2)
Chapter 3 Building a Database and T-SQL Fundamentals 77(34)
Setting Up Your Environment
77(2)
Creating a Database
79(10)
System Databases
80(2)
Creating a Login and User
82(2)
Creating a User Database
84(5)
Creating Tables
89(11)
Creating Schemas
90(1)
Creating Sequences
91(1)
Finally Creating the Tables
92(8)
Creating the Complete Database
100(2)
Building and Running Queries
102(7)
Inserting and Reading Data
102(3)
Updating and Deleting data
105(1)
Building Views and Stored Procedures
106(3)
Summary
109(2)
Chapter 4 Building an Application and Advanced T-SQL 111(34)
Setting Up Your Environment
112(1)
Building and Running a Data Application for SQL Server
113(13)
Using node.js with SQL Server
114(1)
Connecting to SQL Server with node.js
115(3)
Inserting and Reading Data
118(5)
Executing Stored Procedures
123(2)
Enhancing Your Application
125(1)
Go Big on T-SQL
126(9)
Creating and Using Temporary Objects
126(6)
Triggers
132(1)
Analytic Queries
132(1)
Complex Datatypes
133(2)
String Functions
135(1)
Other T-SQL Commands
135(1)
Exploring New SQL Server Capabilities
135(9)
JSON
136(1)
Temporal Tables
136(3)
Graph Database
139(3)
Native Scoring
142(2)
Summary
144(1)
Chapter 5 SQL Server Tools 145(84)
Command Line Tools
146(13)
sqlcmd
147(4)
bcp
151(2)
mssql-cli
153(3)
mssql-scripter
156(2)
sqlservr Command Line Options
158(1)
SQL Operations Studio
159(16)
Installation
160(3)
Configuration
163(4)
Object Explorer
167(2)
Dashboards, Insights, and Extensions
169(4)
T-SQL Query Editor
173(1)
Other Features
174(1)
SQL Server Management Studio
175(6)
Object Explorer
176(3)
T-SQL Query Editor
179(1)
Reports
180(1)
Tools Built into the Engine
181(37)
System Tables and Catalog Views
182(2)
System Stored Procedures
184(1)
Dynamic Management Views
184(12)
Extended Events
196(8)
T-SQL Performance Features
204(7)
Query Store
211(3)
DBCC Commands
214(2)
Trace Flags
216(2)
SSIS for ETL
218(10)
Creating a Package
219(7)
Executing a Package
226(1)
Go Further with SSIS
227(1)
Summary
228(1)
Chapter 6 Performance Capabilities 229(88)
Performance Built In
230(19)
SQL Server Built-in Scalability
231(4)
Dynamic Memory and Cache Management
235(5)
Efficient I/O Processing
240(7)
Parallel Processing
247(2)
Configuration for Maximum Performance
249(10)
SQL Server Instance Configuration
250(5)
Database Options
255(3)
Linux Kernel Configuration
258(1)
Tuning for Success
259(29)
Files and File Groups
260(10)
Indexes
270(10)
Statistics
280(4)
Tips for Developers
284(4)
Accelerating Performance
288(23)
Partitioned Tables and Indexes
288(6)
Columnstore Indexes
294(8)
In-Memory OLTP
302(9)
The Intelligent SQL Server Engine
311(5)
Adaptive Query Processing
311(2)
Automatic Tuning
313(3)
Summary
316(1)
Chapter 7 Security in SQL Server 317(52)
Logins and Users
318(5)
Active Directory Authentication
323(5)
How it Works
324(2)
Setting it Up
326(2)
Using AD Authentication
328(1)
Permissions and Access
328(17)
Grant and Revoking Access
328(1)
Roles and Permissions
329(7)
Row Level Security
336(4)
Dynamic Data Masking
340(5)
SQL Server and Encryption
345(10)
SQL Server Keys and Certificates
346(1)
Transparent Data Encryption
347(1)
Encrypting Database Backups
348(1)
Encrypting Connections
349(3)
Always Encrypted
352(3)
Encryption Summary
355(1)
Data Classification and Auditing
355(12)
Data Classification
356(4)
Vulnerability Assessment
360(2)
SQL Server Audit
362(5)
Summary
367(2)
Chapter 8 High Availability and Disaster Recovery for SQL Server 369(68)
Backup and Restore
370(27)
Database Backup
370(11)
Database Restore and Recovery
381(16)
Always On Failover Cluster Instance
397(8)
How It Works
398(3)
Setup and Configuration
401(2)
sp_server_diagnostics and failover
403(2)
Always On Availability Groups
405(31)
How it Works
406(5)
Setup and Configuration
411(16)
Let's Test it
427(4)
Database Health Detection
431(1)
Performance Considerations
431(2)
Readable Secondaries
433(1)
Automatic Page Repair
434(1)
Clusterless Availability Groups
434(2)
Summary
436(1)
Chapter 9 Managing and Monitoring SQL Server 437(58)
Managing the SQL Server Instance
438(14)
Changing Server Configuration Options
439(1)
Creating an SQL Server Agent Job
440(2)
Using Resource Governor
442(3)
Using the Dedicated Admin Connection
445(4)
sqlservr Command Line Options
449(3)
Managing Databases
452(15)
Moving Databases
452(1)
Managing Files
453(2)
Detaching and Attaching Databases
455(2)
Alter Database Usage Scenarios
457(1)
Repairing Databases
458(9)
Managing Objects
467(8)
Managing Tables
467(2)
Managing Indexes
469(6)
Managing Server-Side Code
475(1)
Monitoring SQL Server
475(14)
Monitoring SQL Server Performance
476(7)
Using the System Health Session
483(2)
Smart Log Backups
485(1)
Linux Tools for Monitoring
485(4)
SQL Server Troubleshooting
489(4)
Dump Files
489(2)
Core Dump Files
491(1)
PSSDiag
492(1)
Summary
493(2)
Chapter 10 Migrating to SQL Server on Linux 495(50)
Migrating from SQL Server
496(13)
Preparing for the Migration
497(7)
Executing the Migration
504(5)
Migrating from Oracle
509(5)
Preparing for the Migration
510(1)
Executing the Migration
511(3)
Migrating from PostgreSQL
514(20)
How Does PostgreSQL Compare with SQL Server?
515(17)
Executing the Migration
532(2)
Post Migration Considerations
534(9)
Optimizing Performance Post Migration
534(3)
Design Your Security and HADR Strategy
537(1)
Using Database Compatibility
537(4)
Migrate SQL Server Instance Objects
541(1)
Using New Features
541(1)
Using an Existing Application Against SQL Server on Linux
542(1)
Summary
543(2)
Chapter 11 SQL Server and Containers 545(42)
Introduction to Containers
545(3)
How to use SQL Server with Containers
548(23)
Deploy and Run the SQL Server Image
549(10)
Build Your Own Container with a Dockerfile
559(4)
Compose a Multicontainer Application
563(8)
The SQL Mac Challenge
571(6)
SQL Server and Kubernetes
577(8)
The Basics
578(2)
SQL Server HADR and Kubernetes
580(5)
Summary
585(2)
Chapter 12 Epilogue 587(2)
Index 589
Bob Ward is Principal Architect for the Microsoft Database Systems Group, which owns the development for all SQL Server versions. He has worked for Microsoft for 24 years, supporting and speaking on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2017. He has worked in customer support as a principal escalation engineer and Chief Technology Officer (CTO), interacting with some of the largest SQL Server deployments in the world. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, performance, and troubleshooting at events such as PASS Summit, SQLBits, SQLIntersection, and Microsoft Ignite. 
Biežāk uzdotie jautājumi par e-grāmatām Biežāk uzdotie jautājumi par e-grāmatām
Permanent link: https://www.kriso.lv/db/97814842412882e.html
Keywords: