Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM 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

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.

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.
Live Webinar: Active Directory Security: What Needs Immediate Priority!Live on Tuesday, October 12th at 1 PM ET

Attacks on Active Directory are at an all-time high. Companies that are not taking heed are being punished, both monetarily and with loss of production.

In this webinar, you will learn:

  • How to prioritize vulnerability management
  • What attackers are leveraging to breach organizations
  • Where Active Directory security needs immediate attention
  • Overall strategy to secure your environment and keep it secured

Sponsored by: