Questions tagged [azure-managed-database]
The azure-managed-database tag has no usage guidance.
azure-managed-database
37
questions
0
votes
1
answer
64
views
Azure Database Auditing not capturing login failures
I'm looking to capture login failures against our Azure Database. I've set up auditing on my Azure Database as such
After running some queries, I can see login successes for the principal in question,...
0
votes
0
answers
97
views
Azure Managed Instance - Slow Index Delete
I have a large table in Azure SQL Managed Instance. The table has ~ 550 million rows and is ~ 250 gb in size. The table has a clustered index on a surrogate key which is auto generated by the system ...
0
votes
1
answer
181
views
PowerShell to check available free space in Azure SQL Managed Instance
I am working on a PowerShell script to restore databases dynamically from the Azure storage account to Managed instance. To add additional functionality I am looking for a PowerShell module that can ...
0
votes
1
answer
958
views
Run SQL query against Azure SQL managed Instance using PowerShell
My task is to execute Azure MI database SP using Powershell.
I am using connection string. I believe I am able to login to the SQLMI database using the connection string with PowerShell.
However, I am ...
0
votes
3
answers
975
views
Unable to drop schema 'jobs_internal' because it is being referenced by object 'id_list' in Azure Managed SQL
I'm trying to export database from Azure and facing various issues.
One or more unsupported elements were found in the schema used as part of a data package. Error SQL71501: Error validating element [...
1
vote
0
answers
112
views
Unable to create Databases in Azure SQL Managed SQL
When running the create DB from the managed instance I get this message.
{
"status": "Failed",
"error": {
"code": "LinkedInvalidPropertyId&...
0
votes
1
answer
539
views
Elastic Job sp_add_jobstep returns "Cannot reference the credential because it does not exist or you do not have permission"
I'm pretty new to Azure (and SQL for that matter). I've been trying to configure Elastic Jobs Agent with a few specific jobs that would run queries against some of my databases on the server.
For ...
0
votes
1
answer
468
views
Index creation time is high on Azure Managed Instance
I am working with Azure Managed Instances for hosting a data warehouse. For the large table loads the indexes are removed and rebuilt instead of inserting with the indexes in place. The indexes are ...
0
votes
1
answer
1k
views
Azure SQL Managed Instance: RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
I'm trying to restore my database into Azure SQL Managed instance from blob storage URL. But I'm getting below error.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
...
1
vote
1
answer
2k
views
SQL Server - EXECUTE permission
In our Azure Managed Instance DB, a new user has been created and given db_datareader, db_datawritter and db_ddladmin. As per MS Documentation, db_ddladmin has CREATE PROCEDURE and ALTER ANY SCHEMA. ...
2
votes
3
answers
2k
views
Why can't I re-authenticate (MFA with mssql extension for VS Code)?
Here's an example of a connection configuration that has stopped working (it's for connecting to an Azure managed database):
{
"server": "sqldb.12345abcde.database.windows.net",
...
0
votes
1
answer
1k
views
Azure SQL MI: The requested server principal already exists on Managed Instance
In my SQL MI i have a ad group (called Group A) which was already assigned to the Active Directory Admin through Portal. I'm trying to update/replace that with a new group called Group B.
When I tried ...
1
vote
1
answer
1k
views
Azure SQL DB - Scale Up - vCore Hyperscale or Azure Managed Instance?
We are currently using Azure SQL DB for our data warehouse project. Though it is an OLAP application, it has partial OLTP functionality as well. Our DB's current configuration is Basic, DTU based. Now ...
2
votes
1
answer
218
views
Delete "orphaned" SSIS catalog
Not sure I am referring to this correctly, but we seem to have an "orphaned" or rogue Integrated Service Catalog, SSISDB, with a database SSISDB on an azure managed instance
We were testing ...
0
votes
1
answer
1k
views
Associate static FQDN with Azure Managed Instance
I have a Azure managed instance that has a host name as yourdb.<DNS-ZONE>.database.windows.net . I Whenever this managed instance is newly created I have to update this host name in every ...