Unable to create ADF Linked Service to Azure SQL database using Self-Hosted Integrated Runtime
Hi all, I am having trouble creating a Linked Service that connects to one of our Azure SQL databases. After entering all required Linked Service fields and testing the connection using our self-hosted integration runtime, I received the following error…
Azure SQL Database not supporting DBCC SHRINKFILE
Hey guys, I have recently tried to shrink a database file in Azure SQL Database, but am getting a message saying this function is not supported in this version of SQL Server. Anybody know when this support was removed? What is the replacement in Azure…
![](https://techprofile.blob.core.windows.net/images/neG8Nq6HgkGdFp4wZMqp4w.png?8D8679)
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)
How to identify it is one update operation for table which has enable cdc
We know that we can use change data capture to monitor the data change on sql database table. I tried to run UPDATE TABLENAME SET PKColumn=NewValue where PKColumn=OldValue We can see that there will be one row marking the delete operation and one row…
![](https://techprofile.blob.core.windows.net/images/UVyLn-Xlr0apNce5TRX1RA.png?8DBA3B)
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…
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)
Azure Entra ID Authentication fails on Azure APP Services
On Local applicaitons we are able to validate connection Server=tcp:XXXXX.database.windows.net,1433;Initial Catalog=demo;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication=Active Directory Default; Once deployed in azure same…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
How to solve problem Microsoft ODBC Driver 17 for SQL Server cannot be found
Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068052310 Start time: 2021-05-06 08:17:41 End time: 2021-05-06 08:22:57 Requested…
Invalid value specified for connection string attribute 'Authentication' (0) (SQLDriverConnect)
I am trying to connect to Azure SQL Database using user assigned managed identity. While configuring the Azure functions I have added the db_reader permission to it. But when I am connecting to the database using the pyodbc driver I am getting…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Azure SQL database S4 pricing tier, what storage type using (HDD or SSD)
Azure SQL database S4 pricing tier, what storage type using (HDD or SSD)
![](https://techprofile.blob.core.windows.net/images/dvtSEeSdTEKYuGmKbAh5Eg.png?8D8858)
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…
Azure Data Factory Copy Geometry data from Azure SQL to Azure Cosmos DB
Hi Team, I am trying to copy over data from a table in Azure SQL database containing geometry type columns. When i created a linked service and preview data get the error message 'Type=Newtonsoft.Json.JsonSerializationException,Message=Error getting…
Why is the data IO percentage for my elastic pool around 50% while a database in the pool is hitting the 100%?
I switched from dtu pricing model to the vCore model (seems to have higher IOPS limit). But it looks like every DB in the pool can only use part of this IO operations limit? Here there are 2 dbs in the pool and only the one shown has any usage. The per…
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…
Upload and restore .bak file to Azure SQL Database from Local Machine
I have a .bak file on my machine I am trying to restore into an azure database. I then created an Azure storage/blob account to hold this file, to restore via ssms but unfortunately, the file is large (about 35GB) and crashes my machine multiple times.…
![](https://techprofile.blob.core.windows.net/images/fiUoM8m-k0yK8yxLkJMC2g.png?8DBC4E)
![](https://techprofile.blob.core.windows.net/images/fiUoM8m-k0yK8yxLkJMC2g.png?8DBC4E)
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"…
![](https://techprofile.blob.core.windows.net/images/lvNaBJBqh0eurOu4q2bQSQ.png?8DA4E8)
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…
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…