Lead Image © Fet, Fotolia.com
What's new in SQL Server 2017
Ready for the Future
Microsoft SQL Server 2017 has been available since October. The new version opens a new chapter in the history of the database server in several respects. Microsoft is looking to make its relational database fit for the Internet of Things (IoT), big data, and machine learning, and when it comes to performance, SQL Server now acts much more intelligently.
Much like other Microsoft server products, SQL Server development is strongly driven by the Azure Cloud, big data, and IoT. The SQL Server landscape is now identical to version 2016: Enterprise, Standard, and Express. Hardware limitations and supported features, as they existed in 2016, remain the same.
SQL Server on Linux
SQL Server on Linux has become a reality with SQL Server 2017. It is currently supported on Red Hat Enterprise Linux (RHEL) 7.3 and 7.4 (see also the "Migration Discount" box), SUSE Linux Enterprise Server v12 SP2, and Ubuntu 16.04. As expected, the RPM package for RHEL can also be installed and executed on CentOS 7 without problems (Figure 1). You will not find the installation packages for Linux on the SQL Server image; you must download them. The easiest way to do this is to include the corresponding Microsoft repositories, as described online (Figure 2) [2]. The size of the download is 150 to 200MB, and after calling a configuration script, your SQL instance is ready for use.
Migration Discount
With the release of SQL Server 2017, Microsoft and Red Hat launched a joint discount campaign for migrating users that runs until June 30, 2018 [1]. You can save 30 percent on the cost of both
Buy this article as PDF
(incl. VAT)
Buy ADMIN Magazine
US / Canada
UK / Australia
Related content
- Microsoft SQL Server 2017 RC Comes with Full Support for Linux
-
SQL Server 2022 and Azure
SQL Server 2022 focuses on even closer collaboration between on-premises SQL servers and SQL functions in Azure, including availability and data analysis. We highlight the innovations of the database server and the interaction with versatile and powerful Azure services. -
High availability with SQL Server 2012 and 2014
As availability requirements continue to grow, Microsoft intends to do away with database mirroring in its SQL Server product. We show you some alternative options in SQL Server 2012 and 2014. -
Tune your databases
Release 2 of Percona Monitoring and Management for open source databases helps reign in inefficient queries and ensure you are making the best use of the available hardware. -
Monitor Windows systems and Linux servers
The Microsoft Operations Management Suite provides a comprehensive monitoring solution in the cloud that offers a high degree of flexibility and scalability.