SQL Server on Linux!? – Meet SQL Server 2017

August 17, 2017
| 290 views

Over the last decade, DATA is the NEW OIL. While the increasing amount of digitization has led to data exploding exponentially, several other factors have also contributed. The cost of data storage has dropped substantially; enterprises are unwilling to delete any of their data. DATA is now a Corporate Asset and archived NOT deleted.

In the “Always On-Line” world all the systems accumulate huge amounts of data in real time. Analysts & experts want to analyze these mountains of data, popularly known as “Big Data”. The world today believes that in order to prosper and grow, they have to have the ability to “spot” emerging trends and patterns before they become mainstream.

This has led to a spectacular increase in the use of the Apache Hadoop Linux platform for Analytics. Data scientists across the world have been using this platform to manage and analyze “Big Data” since traditional SQL databases were not suitable in this environment.In the past, Microsoft provided interfaces to these technologies. To aid its own expansion and grab a market share in the emerging technologies Microsoft released R server for Hadoop & Linux and included R services starting with SQL 2016. They are further fortifying this position with the launch of SQL 2017 RC1.

SQL server 2017 includes analytics using built in Python & R services! Microsoft has always focussed on security. SQL server 2017 has TLS support so the data between SQL Server & clients can be always encrypted!

Some the features are not supported in this release of SQL server as yet. You can find details of the Microsoft release notes here.

MetaSys Software has been delivering high performance and secure database solutions using legacy SQL server version and recent undertakings are on SQL server 2016. If you are looking for web or database solutions, please connectwith us.

1 Comment

Customers will be able to bring the performance and security features of SQL Server to Linux workloads. SQL Server 2017 on Red Hat Enterprise Linux delivers mission-critical OLTP database capabilities and enterprise data warehousing with in-memory technology across workloads. SQL Server 2017 embraces developers by delivering choice in language and platform, with container support that seamlessly facilitates DevOps scenarios. The new release of SQL Server delivers all of this, built-in. And, it runs wherever you want, whether in your datacenter, in Azure virtual machines, or in containers running on Red Hat OpenShift Container Platform!