Major Announcements for Microsoft SQL: GetToSQL Migration Service in Preview and GA for Azure Analysis Services

Posted by Augusto Alvarez on April 25, 2017

“Data is everything,” says Microsoft as their statement in the Data Amp conference, where they introduced several announcements for the SQL community. These revelations cover a great diversity of features regarding the SQL, for on-prem and cloud.

Scott Guthrie, executive vice president of Cloud and Enterprise at Microsoft

Scott Guthrie, executive vice president of Cloud and Enterprise at Microsoft, was in charge of these announcements. Here’s a summary:

  • SQL Server 2017 CTP (Community Technical Preview) release.
  • Microsoft R Server 9.1. SQL analytics server version with Big Data focus.
  • Azure Analysis Services in General Availability (GA).
  • GetToSQL Migration Server in a limited Technical Preview.
  • Several Microsoft Cognitive Services reaching General Availability (GA).
  • Cortana Intelligence Solution Templates.


Azure Analysis Services in GA

Azure Analysis Services was announced in Preview in October 2016, allowing Azure users to integrate data from a variety of sources: Azure Data Lake, Azure SQL DW, and a variety of databases on-premises and in the cloud; transforming them into actionable insights.variety of databases on-premises and in the cloud

With this announcement, Azure Analysis Services has reached General Availability (GA). Therefore, Microsoft is guaranteeing the declared Service Level Agreements (SLAs), warranties and offering a full support for customers using this service.

GetToSQL Migration Service Preview

This new service, with a limited preview (you can subscribe here), will offer customers to migrate databases to new SQL Server or Azure SQL database service with a simplified tool.

GetToSQL will allow customers to migrate on-premise database platforms like SQL Server, Oracle, and MySQL databases to Azure SQL Database or SQL Server on Azure virtual machines.

SQL Server 2017

The SQL Server v.Next version was released as a Community Technology Preview (CTP) and Microsoft also confirmed this version will be called SQL Server 2017. This new version generated great anticipation since will be the first SQL Server to fully support Linux as a supported OS for installation.SQL Server 2017

During the Data Amp event, there was even a demo running SQL Server on Linux via Docker from an Apple Mac. In the event, Microsoft also revealed a record TPC-H data warehousing benchmark conducted with SQL Server 2017 on Red Hat Enterprise Linux (RHEL).

The supported Linux OS for SQL Server installation will be RHEL 7.3, SUSE Linux Enterprise Server v12 SP2, and Ubuntu 16.04 and 16.10. As shown in the demo, SQL Server 2017 is also available as a Docker image, which can run on Linux, Windows or Mac.

Related materials:

Views All Time
Views Today
Return to all posts

Big Data and Machine Learning: Introducing Cortana Intelligence Solution Templates to Accelerate Adoption