Microsoft was in attendance at the PASS Summit 2017 today. The company had some important announcements regarding Azure data Services and SQL Server 2017. Discussing improvements to SQL Server, the company showed how the platform performed on SUSE Enterprise Linux Server on HPE ProLiant DL380 Gen 10 Server.
The test showed how SQL Server 2017 with scalable persistent memory could run queries more than five times faster than a fast SSD drive array, but at 50% the cost.
Microsoft says this makes the service the world's first enterprise-grade diskless database server. The company also debuted a tool called Microsoft SQL Operations Studio. With the features, developers and admins improve their database development and operations.
SQL Operations Studio is available for dev's working on Windows, Mac, and Linux machines. It also works on SQL Server, Azure SQL Database, and Azure SQL Data Warehouse. Developers can take advantage of T-SQL code snippets and call upon favored command line tools like PowerShell, Bach, ssh, and sqlcmd.
Also at PASS Summit 2017, Microsoft announced a new version of Power BI Report Server. This means customers can now maintain Power BI reports on-premises across any data. Support in Report Server includes data refresh, REST API, and Direct Query.
Microsoft announced the new Scale Out feature for Azure Analysis Services:
“The same enterprise-grade SQL Server Analysis Services you've used on-premises is also available as a fully managed service in Azure. With today's announcement of the Scale Out feature for Azure Analysis Services, you can easily set the number of replicas for your Azure Analysis Services instances to support large numbers of concurrent users with blazing fast query performance.”
Lastly, the company has made it simpler for organizations to migrate to Microsoft Data Platform. Customers currently on Oracle, Amazon Redshuft, and PostgreSQL database can now move more easily.