TrustRadius: an HG Insights company

Azure SQL Managed Instance

Score9 out of 10

6 Reviews and Ratings

Get a Demo

What is Azure SQL Managed Instance?

Azure SQL Managed Instance is a scalable cloud database service that combines SQL Server database engine compatibility with a fully managed and evergreen platform as a service.

Categories & Use Cases

Key Features

Learn about the best (and worst!) features Azure SQL Managed Instance has to offer, as determined by TrustRadius' reviewers.
Based on 6 ratings of Azure SQL Managed Instance's features
View all features

Top Performing Features

  • Ease of building user interfaces

    Ability to build flexible user interfaces using drag-and-drop tools

    Category average: 7.9

  • Platform access control

    Rules controlling what data different user categories can access

    Category average: 7.8

  • Issue monitoring and notification

    Integrated monitoring and notification of issues and problems

    Category average: 7.3

Areas for Improvement

  • Development environment replication

    Ease of replicating new development environments

    Category average: 7.7

  • Upgrades and platform fixes

    Ease of deployment of major upgrades or problem fixes

    Category average: 7.7

  • Services-enabled integration

    Ability to integrate with cloud applications and data via APIs and pre-built connectors

    Category average: 8

Reviews

What users are saying about Azure SQL Managed Instance.
View all reviews

Azure_SQL a good rdbms for cloud

Incentivized
Verified User
Analyst in Information Technology (10,001+ employees employees)

Use Cases and Deployment Scope

Run our supply chain applications using Azure*SQL developed in micro-services architecture.

Pros

  • executes the queries efficiently
  • has tools/dashboards to show where the query problems lie
  • alerting for problems

Cons

  • be able to find situation where it uses a bad query plan due to lack of right stats
  • auto scale the CPU when load requires it
  • auto update stats has opportunities in it. so people still have to restart to stopping auto update stats for some situations

Return on Investment

  • it had a positive impact to my business and allowed me to be able to move my workload from on-premise to cloud.

Usability

Alternatives Considered

IBM Informix

Azure SQL great for our data

Incentivized
Stuart RatliffView profile
IT Solutions Architect in Information Technology at V2X Inc (10,001+ employees employees)

Use Cases and Deployment Scope

This handles our database instances for web based applications. Azure SQL Instances are a better use of our web based data than any other instance, and we can use it amongst other Microsoft products to create dynamic data driven content for leadership to make quick, decisive decisions that can benefit our customer base.

Pros

  • ease of use with microsoft products
  • data management
  • GUI interfacing

Cons

  • hard to use without Microsoft knowledge
  • Intimidating CLI
  • Commands are not intuitive

Return on Investment

  • Decision Driven decisions have been quicker
  • Negatively cumbersome at start when training
  • Positive use of PaaS services instead of devoting VMs

Alternatives Considered

MySQL

Other Software Used

Microsoft 365, Azure Virtual Machines, Microsoft IIS