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.
More Announcements
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.”
