AZ305 - Digital badge or certificate not received
MSFT Cert Team, I passed the AZ305 Designing Microsoft Azure Infrastructure Solutions exam. I can ONLY see exam passed and got Microsoft certification ID but not able to see transcript or badge or digital cert copy. Note: I know this to become AZ…
Error with ODBC Driver - pyodbc.InterfaceError: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found and no default driver specified (0) (SQLDriverConnect)')
Hello, I set up a CICD pipeline to handle deploying python code to the App Service but get this screen In the console it says "Failed to load resource: the server responded with a status of 503 (Service Unavailable)" When I look in the logs,…
Azure SQL Database Free Tier Plan
Hello, Why is it that I pick the Free - General Purpose - Serverless: Gen5, 2 vCores which indicates that: First 32 GB storage free **First 100,000 vCore seconds free Yet I have received a bill of USD 250 on my card**
convert pay as you go instance into reserved instance
Hi, I have nearly 12 instances and databases in different regions and I want to change them to Reserved Instances and databases. What is the procedure to implement them as Reserved Instances and databases? Can anybody help me? Do I need to purchase…
Copy activity throwing an error, when a auto incremented column is there on the Sink side
Hello Team, I am trying to copy data from Amazon S3 to Azure SQL database. On Azure SQL side I have set an autoincrement column(Row_Index) in a table, however the copy activity throws an error that "Column 'Row_Index' does not allow…
How do I give a user access to a single App Server, SQL Database, & Azure Storage
Hi; I want to have my QA team do some load testing of the dev slot of our web app. I want to give them full administrative access to the dev slot app service and its associated SQL Database and BLOB Storage. I do not want them to have any administrative…
Query to identify queries executed in a specific Azure SQL DB
Hi All, I am trying to monitor queries running on Azure SQL Databases on a Premium tier Elastic Pool with ReadScale replication enabled. We redirect reporting for our OLTP system against the replicas (using ApplicationIntent = ReadOnly) which means Query…
From Synapse notebook, trouble connecting to Azure SQL using system managed identity
I can create a Linked Service to my Database using my Synapse system-managed identity. This works fine, and the "test connection" shows success. But for the life of me, I can't figure out how to do it in a Python notebook. Here is the…
Azure SQL Database and Azure SQL Managed Instance
can anyone explain me the dff btween the "Azure SQL Database" and "Azure SQL Managed Instance"? Are they the same, or am I missing someything.
How to use mTLS to secure a sql database
Hi, I'm trying to an managed sql database in Azure using either a managed sql instance or cosmosdb with the postgres interface. However I would like to secure the communication towards it using mTLS since all of the communication will come from…
Data Sync Offline
I have seen this error from last night's data sync log,however the Data Sync Service was not offline. Can anyone advise what can cause the Sync Agent to be offline. Sync failed with the exception "Sync Agent 'DataSyncAgent-Prod' is offline.
Bidirectional replication between on prem SQL server and Azure sql with no primary key exist
Can you suggest possible solution for bidirectional real time sync between on prem SQL (2016) and Azure SQL with no primary key exist
How can I find help validating a certificate?
Indeed, I am a student in cloud computing in Morocco and I do not have enough means to obtain the AZ 900 certification and my family also does not have enough financial means. Could someone help me validate this certificate please?
How to access Azure SQL Database which is connected with Azure Static Web apps from Next.js?
Hello, I deployed a Next.js app to Azure Static Web apps, and connected to Azure SQL Server via Azure Portal. and I tried to use it as explained at…
403 Forbidden Error When Running SSRS Reports from Azure Web App within VNet
Hello everyone, I’m facing an issue with accessing SSRS reports hosted on a virtual machine from an Azure Web App with the database on a separate managed instance and the SSRS on a VM with access done via URL. Here’s the situation: The reports execute…
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…
"Sync to other databases" is missing
Under Data management, select Sync to other databases is missing, I'm the Global Admin / Owner of the Database and Subscription so I think this can't be an access Issue.
How to trigger an alert in azure monitor when the particular condition is met continuously for a specific period(say 15 mins)?
Hi Team, I am trying to set up DB metric alerts in azure monitor for a SQL DB. For Ex. Considering the CPU percentage metric, I want to trigger an alert only when the CPU percentage (Max) is breaching the threshold (90%) for 15 mins continuously. In…
Azure Data Studio - Data Migration Extension
Hi We used the data migration extension in Azure data studio to migrate sql server db to SQL MI We stored all the backups to hte azure blob container We started the migration Once all the backups showed restored. We marked the db as read only. We…