Learn What IT Pros Need to Know About Windows 11 - August 26th at 1 PM ET! Learn What IT Pros Need to Know About Windows 11 - August 26th at 1 PM ET!

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.

Sponsored Content

Read the Best Personal and Business Tech without Ads

Staying updated on what is happening in the technology sector is important to your career and your personal life but ads can make reading news, distracting. With Thurrott Premium, you can enjoy the best coverage in tech without the annoying ads.

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.

Related Topics:


Don't have a login but want to join the conversation? Sign up for a Petri Account

Comments (0)

Leave a Reply

Brad Sams has more than a decade of writing and publishing experience under his belt including helping to establish new and seasoned publications From breaking news about upcoming Microsoft products to telling the story of how a billion dollar brand was birthed in his book, Beneath a Surface, Brad is a well-rounded journalist who has established himself as a trusted name in the industry.

Register for Advanced Microsoft 365 Day!

GET-IT: Advanced Microsoft 365 1-Day Virtual Conference - Live August 24th!

Join us on Tuesday, August 24th and hear from Microsoft MVPs and industry experts about how to take advantage of Microsoft 365 at a technical level and dive deep into the features and functionality that will make your environment more secure and compliant.


Sponsored By