Updates About SQL Server 2016 on Linux

It is an exciting news which already every one knew is Microsoft is bringing SQL Server on Linux—another towards making SQL Server industry-leading data management and business analytics platform, for any data, to run any application, anywhere. SQL Server support for linux will be built on SQL Server 2016, so SQL Server on Linux gives the users the power to build and deploy intelligent applications on a single data management and business analytics platform. The advantage of SQL Server’s low total cost of ownership, supporting existing tools and skills and new innovations battle-tested in the cloud, will make the SQL Server more interesting. Microsoft trying to make it easier for us to work with data of any type, size, and speed using the tools, languages, and frameworks we want to use in a trusted cloud, hybrid, or on-premises environment. It’s another step to make SQL Server simpler and more accessible. If you want to have a quick look on how SQL Server works on linux, then see the video. However, still there are many outstanding questions from community regarding which SQL Server features will not be supported when released, which features that are planned to be supported , licensing information, performance difference of running on Server 2016 on windows vs Linux, remote management support with PowerShell, availability of pre-built test VMs to download, Azure (in)compatibility, which flavors of UNIX/Linux will be supported, and comparison/contrast with the other popular database products normally used on Linux. Also, it would be interesting to know how the High Availability, Replication, Always On features work with SQL Server on linux.

Recent updates from Microsoft community via blog posts suggest that SQL Server on linux is already developer and is under testing and now also the Microsoft product support team is getting involved with the product and looks like few support team members got access to the setup media and were able to successfully installed SQL Server on linux without any issues and after using it a bit and reading about linux they feel that SQL Server on Linux is an attainable goal. As of now, the testing is going smooth without much issues, which actually is not good because without hitting any issues during initial internal testing, the product will not improve much. If many issues are identified by users or customers, that will bring a bad impression about the product, which in every case Microsoft wants to avoid. Microsoft support team is invaluable in helping improving the product because they have enormous experience is troubleshooting many issues over a period of time and they can try test simulating different ongoing issues which are encountered on Windows to linux and see the behavior and in the process of troubleshooting the problems, they will need to use different tools and the testing will bring support for those tools as well.

So far from the preview videos and blog posts we can see that we can use SQL Server on linux through SQLCMD command that we install on linux environment, so we are to reply on commands and no GUI support yet, which many SQL Server DBAs may not like, as we are very much used to GUI. However, after the release, with growing requests from DBAs and community, we may get a GUI tool as well. Just like any other product, it is expected to have many issues initially, but thing will improve with time. When SQL Server was initially developer, it was not great and was not even in competition with Oracle, MySQL, DB2, etc, but in 15 years, SQL Server was able to beat the competition with DB2, MySQL, Sybase and few other RDBMS products and giving a tough competition to Oracle as well. Also, with new cloud competition heating up, support for SQL Server in linux has become inevitable for Microsoft to be in completion with other RDBMS products.

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2016

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

New Details regarding SQL Server on Linux and SQL Server 2016 Released on June 1st

SQLServerF1

Microsoft has officially released SQL Server 2016 on June 1st 2016. We can download an evaluation edition from here. This trial edition expires after 180 days, after which we will need to upgrade it to a licensed edition or download free express edition if the features used are minimal. Microsoft has introduced many new features with SQL Server 2016 in different areas. Some of the popular features include, Stretch database, Always Encrypt, Data Masking, also promises of significant improvement in the performance, much closer integration with SQL Azure, temporal tables, query store, Row level security, changes to upgrade advisor, etc. Initially Microsoft has released release candidate versions RC0, RC1, RC2 and RC3, which was downloaded and tested by many users in the DBA and Developer community and by some organizations and enough feedback was provided to improve the product. There were many bugs identified with the initial RC versions on various features, which were subsequently fixed in later RC versions.

Now SQL Server 2016 official RTM version has been launch on June 1st 2016. Once you install the new SQL Server 2016 RTM version, then you will see the build number as 13.0.1601.5. Some insights from Microsoft release documentation are “SQL Server 2016 is here! It is the biggest leap forward in Microsoft’s data platform history with faster transactions and queries, deeper insights on any device, advanced analytics, new security technology, and new hybrid cloud scenarios. SQL Server 2016 delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features like new Always Encrypted technology helps protect your data at rest and in motion, and a world class high availability and disaster recovery solution adds new enhancements to AlwaysOn technology.You can also gain the benefits of hyper-scale cloud with new hybrid scenarios enabled by new Stretch Database technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure in a secured way so your data is always at hand for queries, no matter the size. In addition, SQL Server 2016 delivers a complete database platform for hybrid cloud, enabling you to easily build, deploy and manage solutions that span on-premises and cloud.”

Another exciting news from Microsoft team is the announcement of further details regarding SQL Server support on Linux Operating System. So far SQL Server was supported only on Windows environment, but not there is lot of work in progress to get SQL Server work on linux environment too, just like it works on a Windows environment. SQL Server version which works on linux has not yet been released with SQL Server 2016, instead it may be released as a sub version later or as a new SQL Server version, but looks mostly it will be a sub version of SQL Server 2016 R2 or as part of a service pack. If you want to get hands on with SQL Server 2017 linux version, then at this point all we can do is sign up for Microsoft SQL Server on Linux and wait for further updates. You can register here for Microsoft SQL Server on Linux preview. Also, there has been a video released with small demos on installing and running SQL Server on linux environment. You can watch the video here. Important thing to note is that only database engine is so far been created and tested, but other services like Integration services, Reporting services, Analysis Services are still going to take some time to get on to the linux environment.

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2016

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings