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.
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.
More in Uncategorized
M365 Changelog: Plus addressing: New disable setting and on by default
Mar 16, 2022 | Petri Staff
M365 Changelog: Reminder: IE11 desktop application retires in 3 months on June 15, 2022 – Set up IE mode today (non-LTSC, non-Server)
Mar 15, 2022 | Petri Staff
M365 Changelog: Introducing monthly active users for the Microsoft 365 service change
Feb 24, 2022 | Petri Staff
M365 Changelog: Microsoft OneDrive & SharePoint Library dropdown menu
Feb 3, 2022 | Petri Staff
M365 Changelog: People centric search rollout update (SharePoint, Office.com)
Feb 1, 2022 | Petri Staff
Microsoft Teams Rolls Out CART Captioning Support For Meetings To GCC Customers
Dec 17, 2021 | Rabia Noureen
Most popular on petri