SQL Managed Instance

  1. Share the List of Patches applied on the SQL MI

    It would be great if we have the list of patches applied on the OS level and SQL Level. It's more of informational message.

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Allow moving of Managed Instances to different subnet.

    If networking changes are requred the only option to get an MI under a new private address space is to delete and re-create the Managed Instance which takes a long time to deploy.

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  3. Allow setting azure ad admin on a sql instance similar to what’s available for sql server: Set-AzureRmSqlServerActiveDirectoryAdministrator

    Allow setting azure ad admin on a sql instance similar to what’s available for sql server: Set-AzureRmSqlServerActiveDirectoryAdministrator

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Allow specifying file size when creating database on managed instance

    Since performance (IOps) is determined by disk size the database file is on, we should be able to specify the file size so it will be on a disk which provides the performance required.

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. SQL Managed Instance and Azure Files storage

    Please make it possible for SQL Managed Instance to access files stored in Azure Files storage. This should apply to BACKUP, RESTORE and OPENROWSET. This would make it easier to port databases from on-premises as you would not be limited to using Azure blob storage.

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. SSMS 18.1 crash

    when pull an object from "object explorer" into "query window" hard crash - can only kill by task manager

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  7. Use Managed Identity (MSI) for backup/restore to storage account from Managed instance

    Backup / restore from storage to SMI require SAS token stored as credential. should be great to be able to use System Assign identity in order to control access to storage account without need of storing SAS token.

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Support DNS aliasing of an Azure SQL Managed Instance (at least for public endpoint)

    As it is already supported for Azure single SQL Database, it would be nice to be able to create an alias for the Managed Instance, especially for the public endpoint address. All clients connecting directly to the public endpoint would be able to use an alias instead of the real name of the instance. Switching instances, disaster recovery, migration scenarios would be a lot easier to handle.
    FYI, creating a public CNAME record redirecting to the public endpoint address of an MI (like instancename.public.***.database.windows.net) does NOT work : IP resolution is good, but no way to login to the instance…

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. vcore

    Provide more granular vCore sizes for managed instance

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  10. Fix public endpoint database rename issue

    It is known that the public endpoint currently has issue when you rename a database through it. Will there be a fix for this soon?

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Improve publicly available information on SQL Managed Instance Backup for intra and inter-region datacenter failures

    Could more SQL Managed Instance backup information be provided for the following scenarios:
    (a) are SQL MI backups in storage that will survive an availability zone level failure (ie. whole Data Centre goes down)
    (b) can a customer access those backups in order to restore the DB to a new MI created in a different AZ after disaster
    (c) Same points (a) and (b) but for an entire region failure

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Link to create a rule from the "create a listener dialog"

    I was wondering if you would consider adding a link to create a rule from the "create a listener dialog", if a rule is indeed required to make a listener useful.

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Email not delevered in Azure SQL Managed Instance (AzureManagedInstance_dbmail_profile)

    Hi,

    I have configured SQL DB Mail on SQL MI ( Used same configuration I use in On Prem except the profile Name, here I created the Profile Name called "AzureManagedInstancedbmailprofile"), But email are not delivering through SQL MI. SQl DB mail on MI required any additional Configurations ?

    FYI - I use the Mail relay server/SMTP server details That I use in On prem.

    Ref to following Link, But No Luck--> https://techcommunity.microsoft.com/t5/Azure-SQL-Database/Sending-emails-in-Azure-SQL-Managed-Instance/ba-p/386235

    Regards,
    krishna

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Enable switching VNets Of Managed instance

    Would be good if we were able switch Managed Instance between VNets.

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. needs to access all data source linked servers

    Access all data source linked servers

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  16. On premise SQL servers databases have File Stream locations/files to read thru SSIS packages, how to migrate these to SQL MI ?

    On premise SQL servers databases have File Stream locations/files to read thru SSIS packages, how to migrate these to SQL MI ? Any possible work arounds to move it to Azure MI?
    •Microsoft Ans: File stream data isn’t supported in Managed Instance. Please see https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-transact-sql-information#filestream-and-filetable

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Enhance Managed Service running the Restore process

    Currently when we are restoring the Backup on the SQL Managed Instance, the background process in the Managed Service is not easily visible or accessible to the operator of the backup.

    I suggest that the error message on canceling the restore process through T-SQL to be enhanced with the corresponding information and help for finding out and canceling Managed Service job.
    The regular users won't be able to find out the reason why they are getting a new database even though they canceled the original restore process.

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Focus on making it easier for Basic Azure usage (ASP.NET MVC, SQL Server, WebAPI)

    Focus on making it much easier to setup, upgrade, manage, get performance statistics from, get error logs from the most basic Azure setup.

    It's for Asp.net MVC front end, ASP.NET MVC WebAPI back end, MS SQL Server and ASP.NET Idenity/Owin security (not Azure or Active directory security).

    The above basic configuration should be easy to setup, run and administer.

    Corporate websites for external facing customers need to last well beyond 3 years in general and for financial systems need to last 7 or more years due to federal document retention regulations.

    Hooking our Azure hosted solution to Azure specific technologies…

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Support a DR (Disaster Recovery) solution with Azure Backup / Geo-Replication

    Currently I was only able to get SQL MI accepted by a client because for the DR scenario I was able to manually script client initiated backups that backup to geo-replicated blob storage.

    SQL MI does support replication to a secondary site but this makes it too expensive for most clients. But they must have a DR solution as the 7-day point-in-time locally redundant backup doesn't meet their security requrement.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Managed Instance

Categories

Feedback and Knowledge Base