Username or Email Address
“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, was in charge of these announcements. Here’s a summary:
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.
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.
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.
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.
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.
Microsoft, Services by Augusto Alvarez