HomeWinBuzzer NewsMicrosoft Demonstrates SQL Server on Linux in Video

Microsoft Demonstrates SQL Server on Linux in Video

The Linux version includes all the standard SQL Server management features found in the Windows version. The service is currently available in preview.


The first thing that catches the eye is how easy and fast it is to set up on . Download and installation of the services take no more than a minute.

Key features such as transparent data encryption, always encrypted, row level security, in memory tables, column store indexing and more are part of the new version.

In the video, Travis Wright, lead engineer, shows an example by running a SQL server-based app inside of a Docker container. The example shows a basic voting application and the full process that goes behind it.

The video emphasizes one of the most powerful features of SQL Server – Columnstore. This feature stores data on disk and in memory in a special order for fast access and better compression rates. An example shows running a simple Java application and what it actually does in terms of improved performance.

also announced that all of the program ability features, previously available in Enterprise edition, are now available in all editions of SQL servers, both for Linux and Windows.

The company, somewhat surprisingly, first announced the Linux version in March this year. The service was in private preview up until now, marking a debut for Microsoft software on Linux servers.

Microsoft states it had a strong reception for the private preview, with more than 50% of Fortune 500 companies applying. The public preview is currently available for download at sqlserveronlinux.com.

Continuing the Linux development

The release presents another step in the ongoing Linux development that Microsoft has pursued in the recent years. The shift in Microsoft's mission to bring its services and tools to its customers irrelevant of the OS continues strongly.

Yesterday we got the confirmation on just how serious Microsoft is regarding Linux by joining The Linux Foundation. The tech giant joins the group as a Platinum member, the highest membership available.

Microsoft will have an active role in internal decisions of the group. In addition, the company will work more closely with the open-source community on improving cloud and mobile technology.

The Microsoft SQL Server team will host a special Ask Me Anything session or Reddit on Friday, November 18th, 2016. More details can be found here.

Sead Fadilpasic
Sead Fadilpasichttp://journalancer.com/
Sead is a former Al Jazeera journalist who shares his passion for technology on various tech media outlets. Formerly a heavy gamer (semi-professional Warcraft 3 gosu), he now enjoys reviewing software and churning out words about the latest tech-news. He holds a college degree in Journalism and likes to annoy his neighbors by playing one of his three electric and two acoustic guitars.

Recent News