The article discusses the new Linux-SQL release and its similarities with SQL Server Core.
The reason why Windows never fails to hit the popularity chart is because it’s easy to use. Users find it incredibly delicate to work with windows on servers and databases without worrying about learning a dozen of new languages to perform basic tasks.
A few years ago, Windows Server 2012 exclusively came out with Core promising a plethora of options, but the expectations didn’t match the reality. But it did create the buzz back then and as it seems, it will do it again. SQL Server 2017 is now available for windows as well as Linux and this is the first time Linux is being considered for SQL Server. It totally changes the market because servers being ported to Linux directly risk the Windows corresponding server revenue. Interestingly, SQL Server on Linux will almost use the same code as it does on Windows. Let’s take a look at the similarities it draws with Core.
Is it going to be Similar to Core?
Well, Yes! There are a few similarities which can’t be overlooked for the sake of excitement. Both are presenting big stumbling blocks for Database Admins of Windows, and their working is somewhat similar. There are a few differences which could be found in the Notes of SQL Server Linux.
It’s good that they both focused on expected problems for sysadmins but the problems for database administrators still remains unacknowledged. However, a few features of SQL Server Core such as integrated Windows authentication and clustering support couldn’t make it in Linux Support.
How does it help?
The business heads surely understand the nerves of market and limiting SQL Server to windows would not have helped them much as releasing it on SQL grounds would do. It’ll definitely buy a lot of buzz and customer support and would obviously increase sales.
The SQL Server 2017 is bringing a fresh adaptive Query processing engine which would be faster than previous versions, and other features like Automatic tuning, Graph Database, Resumable Online index Rebuild, etc are highly promising.
One challenge that might come up the surface, as it did with Core, is staff availability, a group of data admins with proper expertise in both the fields of SQL Server and Linux management.
DBAs and why they should learn Linux
Sysadmins love Linux and would prefer Linux over Windows any day, and why not, Linux is secure and provides better control than Microsoft. Now with the SQL Server being available on Linux, it makes things easier for your organization and your data management. So learning Linux won’t cause any harm in fact it will only help you with better opportunities.
Microsoft’s extension of availability to Linux platform only proves that Microsoft is focusing on being a just and open source oriented company. The company has admitted that the move was necessary as they no longer wanted to confine their customers to limited choices.
While Linux is typically known to offer a more secure ecosystem for running databases, it hardly makes any difference to your backup and recovery plans. In fact it is even more important for you to keep sql recovery tool handy to deal with contingencies.
Victor Simon is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including mdb fix and sql recovery software products. For more information visit https://www.datanumen.com/