Pro SQL Server on LinuxPro SQL Server on Linux

Pro SQL Server on Linux
Author : Bob Ward
Publisher : Apress
Total Pages : 622
Release : 2018-10-27
ISBN 10 : 9781484241288
ISBN 13 : 1484241282
Language : EN, FR, DE, ES & NL


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 LinuxUse tools and features to diagnose, manage, and monitor SQL Server on LinuxScale your application by learning the performance capabilities of SQL ServerDeliver 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 PostgreSQLBuild 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.

More Books:

Pro SQL Server on Linux
Language: en
Pages: 622
Authors: Bob Ward
Categories: Computers
Type: BOOK - Published: 2018-10-27 - Publisher: Apress

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
Pro SQL Server 2019 Administration
Language: en
Pages: 941
Authors: Peter A. Carter
Categories: Computers
Type: BOOK - Published: 2019-10-18 - Publisher: Apress

Use this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need to know to get their daily work done. Updated for
Pro SQL Server 2019 Wait Statistics
Language: en
Pages: 407
Authors: Enrico van de Laar
Categories: Computers
Type: BOOK - Published: 2019-06-03 - Publisher: Apress

Here is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Learn to identify precisely why your queries are runni
SQL Server 2019 Revealed
Language: en
Pages: 435
Authors: Bob Ward
Categories: Computers
Type: BOOK - Published: 2019-10-18 - Publisher: Apress

Get up to speed on the game-changing developments in SQL Server 2019. No longer just a database engine, SQL Server 2019 is cutting edge with support for machine
The SQL Server DBA’s Guide to Docker Containers
Language: en
Pages: 362
Authors: Edwin M Sarmiento
Categories: Computers
Type: BOOK - Published: 2020-05-29 - Publisher: Apress

Get introduced to the world of Docker containers from a SQL Server DBA’s perspective. This book explains container technology and how it can improve the deplo
Learn T-SQL Querying
Language: en
Pages: 484
Authors: Pedro Lopes
Categories: Computers
Type: BOOK - Published: 2019-05-03 - Publisher: Packt Publishing Ltd

Troubleshoot query performance issues, identify anti-patterns in code, and write efficient T-SQL queries Key FeaturesDiscover T-SQL functionalities and services
Pro SQL Server 2005 Replication
Language: en
Pages: 1014
Authors: Sujoy Paul
Categories: Computers
Type: BOOK - Published: 2007-03-01 - Publisher: Apress

Replication is a way of copying and updating information in a database. The Definitive Guide to SQL Server 2005 Replication is for Microsoft database developers
Pro SQL Server Reporting Services
Language: en
Pages: 305
Authors: Rodney Landrum
Categories: Computers
Type: BOOK - Published: 2004-09-27 - Publisher: Apress

* Especially applicable to readers in the US medical sector. * Supported and technically validated by the MS team. * SSRS will attract companies looking for a l
Pro SQL Server 2000 Database Design
Language: en
Pages: 578
Authors: Louis Davidson
Categories: Computers
Type: BOOK - Published: 2008-01-01 - Publisher: Apress

* Obtain a deep understanding of database design and modeling concepts. * Implement a complete case study, from initial requirements gathering, right up to the
Pro SQL Server 2005 Integration Services
Language: en
Pages: 578
Authors: Jim Wightman
Categories: Computers
Type: BOOK - Published: 2007-12-18 - Publisher: Apress

SQL Server Integration Services is groundbreaking. It exists for both the database administrator and the developer, as well as that new role SSIS has created be