Skip to main content
Fachgebiete
Automobil + Motoren Bauwesen + Immobilien Business IT + Informatik Elektrotechnik + Elektronik Energie + Nachhaltigkeit Finance + Banking Management + Führung Marketing + Vertrieb Maschinenbau + Werkstoffe Versicherung + Risiko
DE
EN
Themenseiten
Organisationspsychologie Projektmanagement Marketing Smart Manufacturing
Bücher
Zeitschriften
Weitere Formate
Podcasts Webinare Technik Webinare Wirtschaft Kongresse Veranstaltungskalender Awards
Jetzt Einzelzugang starten
Zugang für Unternehmen
Referenzkunden
MTZ-Fachkongress

Antriebe und Energiesysteme von morgen


Austausch von Automobil- und Energiewirtschaft

Am 14./15. Mai geht es in Chemnitz um die Mobilitätswende durch Elektro- und Wasserstofffahrzeuge.
Erweiterte Suche
Anmelden
nach oben

2018 | Buch

Why SQL Server on Linux? Kapitel lesen Erstes Kapitel lesen

Pro SQL Server on Linux

Including Container-Based Deployment with Docker and Kubernetes

verfasst von: Bob Ward

Verlag: Apress

Enthalten in: Springer Professional "Wirtschaft+Technik" , Springer Professional "Technik" , Springer Professional "Wirtschaft"

Einloggen, um Zugang zu erhalten
insite
SUCHEN

Über dieses Buch

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.

Inhaltsverzeichnis

Frontmatter
Chapter 1. Why SQL Server on Linux?
Abstract
Microsoft SQL Server 2017 became generally available on October 2nd, 2017. It marked the 12th major release of SQL Server in its history. SQL Server is now a leading data platform for the industry. It powers websites, industries, and business applications all over the world from laptops to small businesses to large enterprise servers. It is used as a data platform in private and public clouds. The database engine is the power behind Microsoft Azure SQL Database. SQL Server has for many years had a great reputation for ease of use, ease of administration, and as a leader in price/performance. But SQL Server has now become a major force in technology through breakthrough performance and scalability, trusted security, and new intelligence capabilities. Features like Columnstore indexes, Query Store, Always Encrypted, Graph Database, Always On Availability Groups, and Machine Learning Services demonstrate that SQL Server is not just a great relational database engine but truly a data platform for applications. Our proud history of running side by side with Windows Server over the years is an incredible story. Then why would we build SQL Server to also run on Linux?
Bob Ward
Chapter 2. Install and Configuration
Abstract
From the very beginning, our team wanted to make sure the installation experience for SQL Server on Linux fits well within the already well-established methods, practices, and ecosystem for Linux users. Furthermore, rather than just say that SQL Server is supported on any Linux distribution (there are hundreds out there), we wanted to ensure we provided a quality, well-tested release on popular distributions and a superior support experience for our customers.
Bob Ward
Chapter 3. Building a Database and T-SQL Fundamentals
Abstract
Now that you have installed SQL Server, the next step in your journey with SQL Server on Linux is to create a database. Then you will want to create tables, insert some data, and learn the fundamentals of the T-SQL language. Although this chapter covers basic T-SQL functionality, I’ve written the chapter from the perspective of a developer. For those of you who are experts with SQL Server and T-SQL, this chapter may seem like a review. But for those new to SQL Server, this chapter is essential, so you can build a foundation of knowledge about the T-SQL language and basic capabilities of SQL Server. To demonstrate SQL Server features in this chapter, I’ve chosen Visual Studio Code as the development tool to execute queries. Armed with this knowledge, you will be able to move to the next chapter to build an application, and learn more advanced T-SQL capabilities and new features of SQL Server 2017.
Bob Ward
Chapter 4. Building an Application and Advanced T-SQL
Abstract
Now that you have learned how to create a database, tables, and execute basic T-SQL queries, it’s time to write some code and build an application that connects to SQL Server on Linux. As in Chapter 3, I’ll use Visual Studio Code as the development environment to build a node.js application.
Bob Ward
Chapter 5. SQL Server Tools
Abstract
SQL Server has a rich tradition of providing the tools any data professional needs. Tools give anyone the power to develop, interact, tune, manage, and troubleshoot applications and queries with SQL Server. Tools for SQL Server encompass far more than programs or utilities. SQL Server comes built-in with a rich set of capabilities that I will discuss in this chapter as part of the topic of tools.
Bob Ward
Chapter 6. Performance Capabilities
Abstract
If you are going to provide a data platform that is competitive in the industry and can handle the largest enterprise workloads on the planet, the database engine must be fast. The engine must be fast, built-in. It must provide capabilities for configuration, and tuning for users and developers to use computing resources to their maximum. It must provide features that allow users to accelerate performance beyond expectation with little or no application changes. And finally, a world-class data platform should come with built-in capabilities to adapt and autotune common query performance problems.
Bob Ward
Chapter 7. Security in SQL Server
Abstract
The second major pillar of the SQL Server data platform and engine is security. SQL Server 2017 not only comes with a rich set of features to meet your security needs but has been recognized for being the least vulnerable database platform over almost the last decade. Figure 7-1 is the one of the standard visuals I use to show an overview of the SQL Security feature suite (many in the industry call this defense in depth) and a chart showing the rating of SQL Server vs. the competition on vulnerabilities.
Bob Ward
Chapter 8. High Availability and Disaster Recovery for SQL Server
Abstract
While performance and security are critical features that any world-class database engine and platform must provide, production workloads and databases need high availability and features that support a robust disaster recovery plan. SQL Server is a database platform that includes rich features and options for both high availability and disaster recovery needs.
Bob Ward
Chapter 9. Managing and Monitoring SQL Server
Abstract
After reading through the first eight chapters of this book you have learned the necessary fundamentals to install SQL Server on Linux, deploy a database and application, and set yourself up for success by understanding the fundamentals of our tools, performance, security, and high availability.
Bob Ward
Chapter 10. Migrating to SQL Server on Linux
Abstract
Some of you reading this book are building a new database and will use the previous chapters in this book to create a new database(s) and application. However, some of you have existing databases either on SQL Server or other database products and are looking to migrate to SQL Server on Linux. This chapter is intended for you. However, even if you are not performing a migration, I think you’ll be interested in looking over this chapter, which is broken down into these sections:
Bob Ward
Chapter 11. SQL Server and Containers
Abstract
The concept of virtual machines has been around for some time, but at Microsoft I really didn’t see customers start to use SQL Server as a database platform on virtual machines until around the 2006 to 2007 timeframe. Even when virtual machine environments such as Hyper-V and VMWare started to become popular, I was skeptical SQL Server would run well in a guest virtual machine. Today, SQL Server is probably deployed in virtual machines far greater than on a bare metal computer.
Bob Ward
Chapter 12. Epilogue
Abstract
The SQL Server Engineering team moves at the speed of the cloud. That is my observation since joining the team over two years ago. My good friend and architect of the SQL Server product, Conor Cunningham, once told me that if we wanted to, Microsoft could ship a quality release of SQL Server every month these days. That is a far cry from the days of Yukon (SQL Server 2005) when it took several years to ship a release. Of course we need value and new features to make a new release viable for the industry, so once a month is probably not the right cadence. SQL Server 2017 came right off the heels of SQL Server 2016, and a big part of that release was bringing SQL Server on Linux to market. So what is next for SQL Server, especially for SQL Server on Linux and containers?
Bob Ward
Backmatter
Metadaten
Titel
Pro SQL Server on Linux
verfasst von
Bob Ward
Copyright-Jahr
2018
Verlag
Apress
Electronic ISBN
978-1-4842-4128-8
Print ISBN
978-1-4842-4127-1
DOI
https://doi.org/10.1007/978-1-4842-4128-8

Premium Partner

    Bildnachweise