{"id":43432,"date":"2021-08-27T12:24:12","date_gmt":"2021-08-27T04:24:12","guid":{"rendered":"https:\/\/version-2.com\/?p=43432"},"modified":"2022-02-07T16:38:11","modified_gmt":"2022-02-07T08:38:11","slug":"microsoft-sql-server-can-now-be-run-on-linux-gnu","status":"publish","type":"post","link":"https:\/\/version-2.com\/zh\/2021\/08\/microsoft-sql-server-can-now-be-run-on-linux-gnu\/","title":{"rendered":"Microsoft SQL Server can now be run on Linux GNU."},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\"\"<\/p>\n\n

\n

Microsoft SQL Server \u00ae on Linux GNU is here to stay. Get ready<\/h2>\n

Introduction<\/h2>\n

On December 28, 2016 \u2013 feast of the Holy Innocents, that special day when Spanish speakers make jokes throughout the day \u2013 it was announced the acquisition of a \u201cPlatinum\u201d type membership<\/a> by the company Microsoft \u00ae in the Linux Foundation and the launch of Microsoft SQL Server \u00ae. We took this news very seriously since for us, English-speaking people, we have April Fools\u2019 Day on April 1st, that special day when we joke around. And if we had any doubts, it was officially published in the blog of the Microsoft \u00ae technical team, which included a funny figure which showed a \u201cMicrosoft Linux\u201d (sic)<\/em> sign along with a penguin.<\/p>\n

We have been using computers since 1989 with the famous MS-DOS\u00ae (Mr. Linus Torvalds<\/strong> wasn\u2019t even studying at university at that point) we are still trying to conceive the idea that Microsoft SQL Server<\/strong><\/em> \u00ae can be run on Linux. But nowadays, this is an unavoidable reality and those days of antagonism with former CEO Steve Ballmer<\/strong> are long gone. He left office in 2014 and his successor Mr. Satya Nadella<\/strong> led the company and he developed one of the largest computer infrastructures on the cloud computing network<\/em> with the product \u201cMicrosoft Azure\u00ae\u201d (formerly known as \u201cWindows Azure\u00ae\u201d).<\/p>\n

This \u201cWindows Azure\u00ae\u201d product stands out because of its software development kit or \u201cSDK\u201d which is published as open-source (which is different from the free software license in Linux). To this day, artificial intelligence is already being developed in \u201cMicrosoft Azure\u00ae\u201d<\/a>, which is now known as \u201cmachine learning\u201d<\/em>.<\/p>\n

This brief introduction leads us to our article today: Microsoft SQL Server \u00ae on Linux GNU.<\/strong><\/p>\n

Microsoft SQL Server \u00ae on Microsoft Windows\u00ae<\/h2>\n

Okay, we don\u2019t want to fool you and yes, we are going to talk about GNU\/Linux but first we need to know the framework of that popular database engine. Microsoft SQL Server \u00ae was born in 1989 to be run on \u2026 IBM OS\/2, yes, I am not joking. At that time, it was the \u201cAshton-Tate\u201d company with its flagship product dBase<\/strong> that caused large volumes of data to flow through the local area network because each customer took a copy of the database to each computer where it was running. That\u2019s why Microsoft bought the SQL Server \u00ae license from Sybase which worked with the client\/server model through simple commands and returned limited amounts of data (almost all the work is done separately and remotely on the server). Ashton-Tate provided its customer market and dBase worked as an interface for the user, while Microsoft and Sybase handled the work on the server side.<\/p>\n

After some time (in 1994) the version 6 of SQL Server \u00ae appeared, which was also run on the recent Windows NT\u00ae and that version was no longer made by Sybase. From version 7.0 onwards, it was massively rewritten in C ++ language and as of 2000, when it was time for OS\/2 to be discontinued, SQL Server<\/strong> \u00ae remained only for the Windows NT \u00ae operating system. Then in 2001 its successor Windows XP\u00ae inherits the Windows NT\u00ae technology \u2013 by the way, \u201cNT\u201d means \u201cNew Technology\u201d \u2013 and it was able to reach common users and their small and medium enterprises: the efficient management of relational data was no longer for exclusive use for large corporations<\/em>.<\/p>\n

In 2005, a dilemma emerged: the rise of 64-bit and multi-core processors, as well as a large amount of RAM for which Microsoft SQL Server<\/strong> \u00ae was not prepared to take full advantage of all this potential. In reaction to this, it is decided to make a platform layer to contain \u201cSQLOS layer\u201d. A SQLOS is a \u201chighly configurable user-level operating system with a powerful application-programming interface.\u201d (You can have a look at the official and detailed explanation here<\/a>) We will soon see why it was a very good choice, since it completely separates programming from the workloads and threads on a computer, on which Microsoft\u00ae SQL Server \u00ae is installed.<\/p>\n

Microsoft SQL Server \u00ae on Linux GNU<\/h2>\n

In the world of web servers, GNU\/Linux distributions have been the leading ones for many years. Debian has the Ubuntu Server, used by many companies of different sizes, to publish their sites on the Internet. But for the databases there are quite a few programmers who have chosen Microsoft SQL Server<\/strong> \u00ae and because of this, companies must acquire a Microsoft Windows\u00ae operating system, this way creating additional work in the management of the local area network due to a mixed environment.<\/p>\n

This concern gradually surfaced<\/em> among Microsoft\u00ae customers and so they told the Redmond-based company (in Washington, USA) which put them on the spot because they did not know how to carry the millions of lines of code, accumulated during all these years, to the environment of the operating system of the penguin. The answer to this problem was found in a project dating back to 2011 called Drawbridge\u00ae, which was originally intended for virtualization of applications in a secure environment (called \u201csandbox\u201d<\/em>).<\/p>\n

It was then necessary to \u201cisolate\u201d Microsoft SQL Server \u00ae. Programmers coded in a carefree way as they worked in a well-known environment, which dealt with the various existing hardware. Once the Drawbridge processes were well understood and adapted, the following parameters were established:<\/p>\n