SQL Managed Instance

  1. Enable Polybase on SQL Managed Instance

    Please enable Polybase on SQL Managed Instance. This will allow us to integrate data from our other IoT Analytic environments (Databrick, and Snowflake) with our corporate data warehouse (SQL MI). Polybase will improve data availability between systems by setting up external tables over Azure Storage Blobs that are shared between systems.

    106 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Flag idea as inappropriate…  ·  Admin →

    We are exploring product improvement opportunities in an area of combined relational and non-relational data querying including integration with data lakes and data virtualization from Azure SQL database/Managed Instance to data stored in various formats.
    We are seeking for the customers interested in these new functionalities to participate in the survey below and help us improve our customer experience and product functionalities in Azure SQL DB/MI. If that’s you we are looking for, please fill out this survey: https://aka.ms/sqldbmi-datalake-integration.

  2. Make backups portable to on-premise SQL

    Get this message when attempting to restore an SMI backup to on-premise SQL:

    The database was backed up on a server running version 15.00.0700. That version is incompatible with this server, which is running version xx.xx.xxxx. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

    Lock in is risky for customers for a number of reasons. A workaround is using BACPAC but getting an established database into a state where BACPAC doesn't spew errors is difficult in our experience.

    95 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all and thank you for your feedback. While this will not directly address backup and restore from MI to back on-premises SQL (this is also being considered and some updates might follow), we are considering a replication technology which might help support this scenario. We are exploring product improvement opportunities in the area of hybrid link using distributed availability groups (AG) replication technology between SQL Server and MI. This will enable near real time data replication between SQL Server and MI. We are also considering failover scenarios both ways. If this might interest you, we invite you to provide your feedback to the engineering team through this online survey: https://aka.ms/mipg-chimera-survey. Thank you.

  3. 64 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Flag idea as inappropriate…  ·  Admin →

    This is a difficult one to handle technically. However the main theme is cost savings. Are there other cost-saving options (other than pausing) that could address this concern? For example, smaller vCore Managed Instances etc.? On the other hand, implementing pausable Managed Instance can also mean that resuming them will take several hours each time. Is this a concern? Thank you.

  4. Enable Stretch DB on SQL Managed Instance

    Regulators require data to be on-line and query-able for x number of years. However, business value is traditionally gained from data closer to present day. Please enable Stretch DB on SQL MI in order for us to archive old data to a lower performance/high capacity Azure SQL DB. this will allow us to meet regulatory requirements and lower admin overhead for our high value data (that which remains in SQL MI).

    18 votes
    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 →

    We are exploring product improvement opportunities in the area of hybrid link between SQL Server (on-premises and VM) and Managed Instance which will enable near real-time data replication. This will not be a stretch DB, but a replication technology based on distributed availability groups (AG). If this might interest you, we invite you to provide your feedback to the engineering team through this online form: https://aka.ms/mipg-chimera-survey

  5. xp_logininfo alternative for Azure SQLDBMI with AzureAD

    How can I request login info about Azure AD ( synced) authorities on my Azure SQLDB Managed Instance ?

    EXEC master..xp_logininfo @acctname = 'mydomain\theAccount', @option = 'all'

    We need to figure this out from within the SQLInstance and not as a reaction on the Azure Portal or Powershell AD info.

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

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Restore a bacpac to Managed instance

    Hi,

    We are currently trying to restore a bacpac from a database on Azure SQL Server (within an elastic pool) to a SQK Managed Instance. It would be great to do so.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Enabling an option such that Power BI only connects to the read-only instance of SQL Managed Instance for Business tier

    Enabling an option such that Power BI only connects to the read-only instance of SQL Managed Instance for Business tier

    3 votes
    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. Sql Server Agent SSMS Error in Job Creation Managed Instance

    although I can create a job, if you lose context and come back in SSMS the job upon creation says already created, Appears to have a update problem.

    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 →
  • Don't see your idea?

SQL Managed Instance

Categories

Feedback and Knowledge Base