
The UI
Social lounge
Customer support
Scalability
Audience engagement Review collected by and hosted on G2.com.
It has limited facilities with other database
Learning curve for new user
Non user friendly for recent user Review collected by and hosted on G2.com.
Easy integration with various tools and an easy to use UI Review collected by and hosted on G2.com.
Any alternatives and Azure doesn't provide any distinctive features to stand out from the crowd Review collected by and hosted on G2.com.
Very Lightweight. We can code in Transact SQLCode. Review collected by and hosted on G2.com.
Sometimes, it feels prolonged or gets hanged. Also, it takes time after using SSMS for longer. Review collected by and hosted on G2.com.
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 Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
Its a light weight application. Great thing i found this allows to run the poweshell command in query editor.
As well as i can write all the Transact Sql code in this. Like create new table or alter the existing one, write new Stored Procedure etc.
Its integrated terminal functionality is awesome.
Next to this its backup feature with encryption - preety secure, we used this functionality with authorized certificate. Review collected by and hosted on G2.com.
When my query editor is open and my system is idle for several minutes then sometime this lost connection with Azure. Review collected by and hosted on G2.com.
Sql Operations Studio is a Microsoft product used for managing Sql server. Its related to the DevOps .
Its a new product and provide unique features like widgets, terminal window for proper and easy functionality of the product.
Widgets are free to move around the product with edit properties.
Command Line Tools like Integrated Terminal Window are easily accessible and powershell can also be executed. Review collected by and hosted on G2.com.
User settings are editable with Json file.
Its easy but sometimes make trouble for new users. Review collected by and hosted on G2.com.
It's very light weight application. I Can write all the Transact Sql code in. Its pretty secured and we use it functionally. The tools and visual interface are very good as compared to other sql tools. Easy to check the data definitions. Review collected by and hosted on G2.com.
After using ssms for a long time, it's takes time to get used to it. And sometimes it's also seems a quite inactive or slow moving. Review collected by and hosted on G2.com.
Visual interface of this software is best d compared to the old sql tools. We can have backup of database efficiently. It's works very good when we are in server sites. Number of admin tasks that can be done here though. Easy to check the data definitions by single clicking also we can paste query scripts. It's lightweight easy to install. Review collected by and hosted on G2.com.
Finding the tables is time consuming sometime hard to find require matter. But it's good for backup of large amount database.
To coming from ssms world it take some time to use it. Review collected by and hosted on G2.com.