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…
Use managed identities to connect to a Azure SQL database
I have a question regarding the use of managed identities to connect to a SQL database. Do I need the ‘db_ddladmin’ role for this, or is it only necessary if I’m going to perform operations like CREATE, DROP, etc.? Additionally, if my managed identity is…
Apne job work me kya aur kaise khud ko invest karein
Hello Everyone This Side Rima Sharma
Trying to import On Prem sql server into azure managed instance but it's failing
Trying to import On Prem Sql server into azure managed instance but it's failing.What should I do?
Access Backend on VNet from public frontend
I need to deploy a frontend that will be publivly accessible but it needs to commuincate and write to a databse that must not be publicly accesible. The current setup i have is as follows: Deploy the Next JS site using Azure Static Web Apps Create a…
%%LOCKRES%% - SQL Server - Row identifier causing Deadlocks
Hi Team, Recently I came across an issue where I am facing deadlocks in SQL Server databases (19.2.56.2) due to the internal hashing mechanism of the Row identifier virtual column - %%LOCKRES%% On analysis I find that the row identifier - %%LOCKRES%%…
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**
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,…
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…
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