Pro sql server on linux

Saved searches

Use saved searches to filter your results more quickly

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

Source code for ‘Pro SQL Server on Linux’ by Bob Ward

License

Apress/pro-sql-server-on-linux

This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

Sign In Required

Please sign in to use Codespaces.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching Xcode

If nothing happens, download Xcode and try again.

Launching Visual Studio Code

Your codespace will open once ready.

There was a problem preparing your codespace, please try again.

Latest commit

Git stats

Files

Failed to load latest commit information.

README.md

This repository accompanies Pro SQL Server on Linux by Bob Ward (Apress, 2018).

Download the files as a zip using the green button, or clone the repository to your machine using Git.

Release v1.0 corresponds to the code in the published book, without corrections or updates.

See the file Contributing.md for more information on how you can contribute to this repository.

About

Source code for ‘Pro SQL Server on Linux’ by Bob Ward

Источник

Pro SQL Server on Linux: Including Container-Based Deployment with Docker and Kubernetes

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.

Table of Contents

Chapter 1: Why SQL Server on Linux?
Chapter 2: Install and Configuration
Chapter 3: Building a Database and T-SQL Fundamentals
Chapter 4: Building an Application and Advanced T-SQL
Chapter 5: SQL Server Tools
Chapter 6: Performance Capabilities
Chapter 7: Security in SQL Server
Chapter 8: High Availability and Disaster Recovery for SQL Server
Chapter 9: Managing and Monitoring SQL Server
Chapter 10: Migrating to SQL Server on Linux
Chapter 11: SQL Server and Containers
Chapter 12: Epilogue

Источник

Pro SQL Server on Linux: Including Container-Based Deployment with Docker and Kubernetes

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.

Resolve the captcha to access the links!

Источник

Pro SQL Server on Linux: Including Container-Based Deployment with Docker and Kubernetes

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Book description

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.

• 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

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.

Источник