SQL Server Operations Studio for Developers and DBA

I have been a DBA for years now, and I have been using SQL Server Management Studio aka SSMS and believe me it is a great tool to work with while writing a TSQL or performing routine DBA tasks. Apart from SSMS, sometimes I use Notepad++ ( I have written about this tool in my previous post ). I have never had any issue with these tools as just worked as expected and Microsoft has announced a new tool to help us #SQLFamily. This tool is called SQL Server Operations Studio – it really looks good from what I have found so far, however, I can talk more about it when I will explore the functionality and the tool as-a-whole, and extensively while supporting client.

The list of feature I like so far:

Grouping of servers is possible and you can color code them
The Dashboard gives you good information about the server itself
Integration with GitHub
Also, can integrate it with PowerShell, Bash, SQLCMD etc.
There are many other widgets (insight widgets) that can be downloaded and used
The most interesting – Performance Monitoring Widget, this is going to be most popular widget
.Net Studio like Code Snippet features i.e. Definitions etc.

I have downloaded this tool and installed it on my system to explore it. So far, I have tested the features that I have listed above. And believe me, it really looks great. However, what I have noticed is that it is missing SQL Server Agent, or maybe I overlooked it. But all-in-all, great tool. I have posted my feedback to SQL Server Team about SQL Server Agent. I can only expect that SQL Server Agent will be available in next release.

And yes, here are some screen captures about the SQL Server Operations Studio.

Hemantgiri Goswami

Throughout my extensive 24-year tenure in the IT industry, I have honed my expertise in SQL Server and cloud technologies. My qualifications include certifications in ITIL, Azure, and Google Cloud, and my professional journey boasts a consistent record of delivering top-notch, dependable, and efficient solutions across diverse clients and domains. In recognition of my dedication and impact, I am honored to have received the Microsoft MVP award for SQL Server on six occasions. Additionally, I actively contribute to various online forums and blogs, acting as a moderator and facilitator of meaningful discussions. My ultimate mission revolves around empowering organizations to enhance the reliability and efficiency of their SQL Server implementations while fostering a culture of continuous learning and growth within the SQL Server community.