SQL Managed Instance

How can we improve SQL Managed Instance?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Make smaller instance sizes available

    It wouldd be great to have smaller instance sizes available - or even a 'basic' tier. this is blocking the route to PaaS at the moment. Most of our customers run on 4/6 cpu cores at most, so cost-wise managed instance is way beyond what is justifiable. Also, its expensive to test. A basic tier would be really useful for POC;s.

    100 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Support regional settings to fix GetDate() function

    GetDate still on UTC all the time. For the promised value of MI to be the destination for lift&shift without code changes, this breaks it. Now developers have to review their code and update it for MI and if decided to move the database to their IaaS environment, they have to change it back again.

    59 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    15 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Azure Managed Instance must suport all Collations

    Azure Managed Instance must suport all Collations, not just SQL_Latin1_General_CP1_CI_AS Collation

    40 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Allow for a Managed Instance to have a public endpoint

    It'd be great if this could happen. The idea of integrating an MI with other Azure services via additional virtual machines using on-prem data gateways and self-hosted integration runtimes is not ideal.

    29 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. I want to rename DB

    I want to change the DB name after restoring the DB and restoring the DB name in order to use the restored DB as the production database.
    If the DB name can not be changed, there is a possibility that it is necessary to change the connection string after the DB restore.

    5 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. "ALTER DATABASE <db name> ADD FILE <logical file name>" doesn't work under specific condition in Managed Instance

    I restored to Managed Instance via ".bak" file. this source DB configured some database file.

    After restored, I executed
    "ALTER DATABASE <db name> ADD FILE <logical file name>",
    following error occured.

    -----
    Unable to open the physical file "https://wasd2p*****.blob.core.windows.net/managedserver-********071/data/829f3544-******_3.ndf". Operating system error 80: "80(The file exists.)".
    -----

    (if source DB's database file is single, work correctly.)

    execute this T-SQL with changing "logical file name",
    physical file name's seq number in error message incremented
    and finally, it worked.

    is this bug ?

    2 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Approval time for Managed Instance preview

    How long should we expect to wait for approval to participate in the preview. I accepted preview terms two weeks ago and requested an April start. Now we're anxious to kick the tires.

    2 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. 1 vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  9. Why not autocreate route tables when creating a virtual network?

    The page https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-vnet-configuration describes a 4 step process

    First. Create a Virtual Network Instance

    Second. Create a routing table

    Third. Add an 0.0.0.0/0 Next Hop Internet route to the table

    Fourth: Associate this route with the Virtual Network

    That is a *lot* of friction - why not offer the ability to have steps 2-4 automatically occur?

    1 vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Managed Instance

Feedback and Knowledge Base