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…
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…
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…
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 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…
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…
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)
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.…
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 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.…
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…