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 votesneed-feedback · AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded
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.
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
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.
It would be idea to be able to pause or suspend the Managed instance during off hours to save on cost64 votesneed-feedback · AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded
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.
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
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
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 votesneed-feedback · AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded
Can you please provide more feedback, as Dimitri asked in a comment below:
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
Importing a BACPAC to Managed Instance is already supported. Please try it using the latest SSMS/SSDT/SQLPackage and let us know if something is still missing.
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 tier3 votes
Thank you for your votes regarding PowerBI connecting to read-only replica of Managed Instance in Business Critical service tier.
We wonder what is the functional gap here? PowerBI supports connections to MI readable replica by checking “Enable SQL Server Failover support” in Advanced options of PowerBI’s connection settings dialog.
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
Updating SSMS will most likely solve this issue. Which SSMS version are you using?
- Don't see your idea?