SQL Operations Studio

What do you like best?

One of the most useful tools I use, especially when doing a bit of machine learning. The ability to split the editor and run SQL queries on one side and develop Python scripts on the other side is the best part for me. Python environment is easy to set up, in the settings you just point to the python .exe. Another great feature is the ability to create your own extensions. I've created my own extensions which run SQL code and produce a graph so that we can monitor certain BI systems. What's great about this is that you can then share these extensions between your team so everyone has it. They're also very easy to add to Op Studio

What do you dislike?

It is a lot easier to do certain things in SQL Management Studio than SQL Operations Studio. Things like the catalogs are just better viewed and used in SSMS than Op Studio. Viewing Jobs is also better in SSMS, although there is an extension in Operation Studio to view Jobs on the server, overall it's just easier to stick with the former. The custom Dashboards are annoying. If you don't make them an extension then the dashboard appears across all the servers homepage, so you get a lot of blank containers as most dashboards are server specific - It may be me being stupid but none of my team have figured a way to fix that other than making an extension.

Recommendations to others considering the product:

If you're doing Machine Learning like myself using Python and also need to query SQL databases, then its perfect. To split the console and run Python and SQL queries and easily save the SQL result into a csv to be then used in your Python language is easy.

What problems are you solving with the product? What benefits have you realized?

Monitoring various BI applications through the use of custom dashboards extensions. Instead of having to open scripts and running them, just opening SQL Operations Studio then connecting the required server and having a visual representation is just a lot easier. The ability to just come back refresh and glance at the dashboard to see everything is running as it should is just nice.