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.79 votesneed-feedback · AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded
As this is a very wide area to consider, need more customers to chime in on possible scenarios please in terms of Managed Instance and what other database systems? Thank you.
It would be idea to be able to pause or suspend the Managed instance during off hours to save on cost54 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.
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 votesneed-feedback · AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded
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.
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.4 votes
Can you please provide more feedback, as Dimitri asked in a comment below:
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?