SQL Server 2017 and Azure SQL Managed Instance

Views: 508
Reading Time: 5 minutes

Hello people,
All right with you?

SQL Server 2017

Once again, Microsoft surprises us with its innovations in the SQL Server product. Less than a year after the launch of SQL Server 2016, Microsoft is already preparing to launch a new version of the product, which is SQL Server 2017. If we think about the previous versions (2000> 2005> 2008> 2012> 2014> 2016), we saw that the intervals started very long between the versions, and from the 2012 version Microsoft started to release new versions every 2 years. What the vast majority of SQL Server professionals expected, was SQL Server 2018, but Microsoft anticipated and will release a version full of new features (again).

While its competitors innovate at a slow pace in slow motion, Microsoft is increasingly coming, bringing a range of new features, improvements and impressive news in a short period of time, as we saw in the post SQL Server 2016 - News and Features List.

During the event Microsoft Data Amp, held on 19 / 04, SQL Server 2017 was introduced to the public (SQL Server 2017 Community Technology Preview 2.0), available for Windows and Linux.

Among the new features available so far, we can highlight:

  • Using Python for Advanced Analytics (previously only possible with R)
  • Official SQL Server Support on Linux, Including Documentation on MSDN
  • Use of Graph extensions, which allow you to create relationships between data for better analysis and insights important to your business, very useful in scenarios such as fraud analysis, social networking, risk management, predictive analysis, etc.
  • Adaptive Query Processing improvements, which will lead to workload improvements in many situations where classic Performance Tuning methodologies are not effective
  • Resumable online indexing, an innovative feature that allows you to REBUILD an online index and PAUSE it as you wish, whether to free up resources on the server to perform some urgent process or any other need, and CONTINUE where you left off.
  • It just runs faster. Several performance enhancements have been applied to SQL Server 2017, making your applications run faster with minimal (or no) effort.

To check out the official announcement of SQL Server 2017, visit this link. Also follow the SQL Server Developer Blog to stay always connected with the news that is coming out.

See also the official videos of the new SQL Server 2017 features presented at the Microsoft Data Amp event:

Want to download and start testing SQL Server 2017 now?

Azure SQL Managed Instance

As if the SQL Server 2017 news wasn't enough, Microsoft decided to innovate in the cloud as well. If a lot of people couldn't / wanted to migrate their SQL Server On Premises instances to Azure SQL Database due to lack of features like CLR, SQL Agent, cross-database usage, among others, this will no longer be an excuse, because Microsoft has announced that it will support SQL Server instances as a service, operating in a manner very similar to what we use today in our local instances.

This makes migrations to Azure easier than ever! In addition, responsibility for managing the VM, operating system, and configurations of SQL Server will remain in the hands of the DBA, but all cloud advancements are also present, such as Elastic Pool, Patching routines and automatic backups, facilities for add discs, etc.

This creates a compromise between a local SQL Server instance and the Single Database Model instances that currently work on Azure, allowing you to have more control and resources using the Managed Instance model or greater isolation using the Azure model. Single Database as shown below:

To learn more about this news, be sure to visit this link.

That's it folks!
A lot of news is coming to SQL Server.

Follow the blog to stay on top of all the news!
Hug.