How do I access my Azure SQL Database using my managed identity?
Hi all; I have a managed identity created. How do I (step by step please as I remember this as being complicated): Set the database to allow access via managed identity? What is the connection string I then provide to the production server? How do I…
![](https://techprofile.blob.core.windows.net/images/FA0ALqN_QU6SmYMGhVsijw.png?8D97DB)
![](https://techprofile.blob.core.windows.net/images/FA0ALqN_QU6SmYMGhVsijw.png?8D97DB)
System Database Backups for Azure SQL Managed Instance
I don't see the ability to backup system databases for Azure SQL Managed Instance. If the server was lost I would lose server logins, backup information. Is there any documentation regarding why we don't have to backup these databases, and the steps we…
price in restore DB + where the restore happened
Hi, I have two questions regarding the backup of the DB: regarding the price written estimated cost per month, does it mean that one restore will cost me this price per month? Regarding the second question, where did the restore go ? Does it…
Azure SQL End of Life Notification
I received a notification from my cloud team that mentions Azure DB for MySQL Single Server, PostgreSQL Single Server, and Maria DB are being retired. I am new to Azure and would like to know if Azure SQL DB and server will be retired as well, so i can…
Creating Certifcate Or Symmetric key Over Azure Managed Instance with Entra Service principal
Hi Team, We are connecting a database over Azure SQL Managed Instance from our C# application. We need to create Symmetric-Key/Asymmetric-Key/Certificate with TSQL statement.
Server Password change on Mac
Does anyone know how to change password inside azure data studio on a MacBook m1?
DataSource.Error: Microsoft SQL - Power BI
Good day, I have a problem with Power BI, when I try to import a database it generates the following error: DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process.…
SQL Server deployment DEV to UAT to Prod
Hi, I would like to know about different deployment options for azure SQL server from dev to higher environments. We are doing ETL in ADF and loading data into Azure SQL server. How do we move the tables/views/sps etc to other environments? Is there an…
unique column in table
HI, merging table1 in table2 merge into table2 using table1 on table.col1=table2.col1 when not match then insert how to add unique column with auto increament number and not null in table like uniquenumner; Name;' 001 Test1 003 …
OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
Hi, I am encountering an issue while trying to connect to an SQL database using a Python script in my Jupyter notebook. The connection attempt results in the following error message: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL…
Azure wont let me crate free data base offer
I'm unable to redeem the free data base offer, I get the follwing error "status": "Failed", "error": { "code": "ProvisioningDisabled", "message": "Provisioning of…
Unable to send message from Azure SQL to Service Bus
The goal is to send messages to Service Bus from Azure SQL Server. I have added the Managed Identity to the queue with the Azure Service Bus Data Owner permission. When I run the code to set up the credential, there is no error. OPEN MASTER KEY…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Cannot create and start Extended Events session in Azure SQL Managed Instance
Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…
Get the full list of Defender sub assessments given an assessment?
We have multiple subscriptions with hundreds of different Azure resource types. I would like to work to remediate the assessments and sub assessments found on the sql server, Azure SQL and Azure SQL MI. The portal shows about 2K sub assessments on the…
Azure SQL Ongoing operations cancel
I tried to export Azure SQL database and that got stuck for several hours in 1%. After that I cancelled export process with Powershell and now it's stuck for cancel in progress... I have tried to scale database but that didn’t do anything. What…
CosmosDB Analytical store delete changes in sql sink
Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
Table performance in azure SQL database
We have a azure DWH table of around 60TB, with daily load of around 1GB of data, what would be the best approach to apply data retention policy on the table and improve performance of table at the same time.
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
ACI needs MS SQL access which is on an azure VM, how do I achieve this?
Hi, I have deployed a container instance which has a connection string which points to a SQL database which is hosted on an azure virtual machine. The virtual machine has its own public IP address. However, the container instance cannot "see"…
Azure Application Gateway Preview feature (TCP/TLS Proxy) and Azure SQL
Hello I was just wondering if anyone has attempted to use the preview feature for Azure Application Gateway to support layer 4 proxying. (https://video2.skills-academy.com/en-us/azure/application-gateway/tcp-tls-proxy-overview) with an Azure SQL instance as…
![](https://techprofile.blob.core.windows.net/images/Nd_pi7-IHkuDC3BVgl0RFQ.png?8D81F2)