Microsoft Has A New (Free) Tool To Help Make Your SQL Databases Faster
This week in Seattle, Microsoft is making several announcements at the PASS summit that includes the new SQL Operations Studio. In addition, the company is making available a new version of Power BI Report Server and Scale Out feature for Azure.
In the coming weeks, Microsoft will be releasing a new (and free) tool to help develop modern databases. Called Microsoft SQL Operations Studio, which is coming to Windows, Linux and the Mac, this tool will help you identify bottlenecks in your on-premises or in Azure SQL databases.
Further, this lightweight tool will integrate with all of the popular command line interfaces like PowerShell, Bash, sqlcmd, bcp and ssh in the Integrated Terminal window. The tool will also help lower the learning curve for performing tasks like development, deployment, monitoring, and trouble-shooting.
Say Goodbye to Traditional PC Lifecycle Management
Traditional IT tools, including Microsoft SCCM, Ghost Solution Suite, and KACE, often require considerable custom configurations by T3 technicians (an expensive and often elusive IT resource) to enable management of a hybrid onsite + remote workforce. In many cases, even with the best resources, organizations are finding that these on-premise tools simply cannot support remote endpoints consistently and reliably due to infrastructure limitations.
SQL Operations Studio uses a perspective approach to performing these tasks and provides guidelines/best practices for making changes to your database.
As for product support, Initially, Microsoft SQL Operations Studio will support SQL Server 2017 anywhere, Azure SQL Database and Azure SQL Data Warehouse will be included with the first release.
For Azure fans, the company announced the ‘Scale Out’ feature of Azure Analysis. This feature makes it easier for users to replicate their Azure Analysis Service instances on-demand to increase performance when concurrent users reach critical mass.
Finally, Power BI Report server is getting a new release that enables the ability to keep Power BI reports on-premises that connect to any data. For more information, you can check out the blog post about the announcements, here.