How to move the Azure sql database across the Azure subscription
Use case-How i can move the azure sql database (or Azure sql server) across the azure subscription ensuring the private link of that database a, vnet of the azure sql database and all the other attributes of the Azure sql database remains AS-IS after the…
[ADO NET Source [2]] Error: ADO NET Source has failed to acquire the connection {xxx} with the following error message: "Could not create a managed connection manager.".
I am attempting to connect to an Azure database. I am able to connect using SSMS. However when attempting to run at tasks in SSIS i get the above error The test connection returns successfully and I can see the preview of the data in the ADO NET Source…
How to read excel document from sharepoint directly dump it in Azure SQL using Azure data factory ?
I want to access excel document from SharePoint and without downloading that to data lake or blob storage, use data factory to read the content of it and directly dump it in Azure SQL.
Azure SQL Server Database serverless or Elastic pool
I'm just getting started with Azure SQL Database and have some questions about pricing. I currently have about 7 databases in use with a free student subscription plan for a development environment. Most of the databases are only used occasionally when…
Azure SQL elastic pool pausing feature
Hello, There are 5 databases I need to host on Azure SQL. They will only be used during week day work hours (i.e. 10 hours a day), so it would be great if they can be paused during the night so that we can save cost. I was wondering if an elastic pool…
How to generate alert for Azure SQL DB
Hi Team, Could you please suggest how to generate an alert in below scenarios in Azure SQL via Azure Monitor? Query running longer than 1 hour (long running query) Session running longer than 24 hours (long running session) Table Space --> do we…
Handling different date formats in Azure SQL
I need help with writing a stored procedure in Azure SQL that updates datetime values stored as varchar columns with different date formats to a consistent format of 'MM/dd/yyyy hh:mm:ss'. Specifically, the columns whose names end with 'DP' need to be…
Hi , I have created one Azure SQL database with Basic pricing tier. I am not able to take it offline or pause the database.
when i go to Settings -> Properties, I can see an option Status ->online for that database but I can not change it to Offline/Pause. Please help since this effect my billing.
ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…
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 view SQL Azure Business Critical Tier - Qurom, replics, etc.
We just scaled from General Purpose Tier to Business Critical in our main production Azure SQL Database (not Managed Instance). Everything is running fine, and I can connect to the read only replica successfully. Besides initiated a manual failover, I…
How to split rows and columns by using ADF?
How can I retrieve data from the following table by using ADF lookup activity and want to get the result as below? Thanks
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…
Topic Learn: Create a dataset for .NET Framework application using the Dataset Designer
I wanted to follow this help: This walkthrough uses SQL Server Express LocalDB and the Northwind sample database. (All steps followed) Create a New Windows Forms Application Project (All steps followed) Add a New Dataset to the Application Name the…
Understanding Active-Passive Disaster Recovery and Transition Steps for Azure API Management and App Service
When setting up an active-passive disaster recovery (DR) setup, does it mean that the secondary (passive) environment is not actively processing requests or transactions? Is it essentially a standby environment that's ready to take over in case the…
Deployment of App service
I am creating an Azure SQL database and after clicking on review and create. But for hours I am getting deployment in progress and I don't know why. Any help?
Synapse can't transfer data from parquet file to Azure SQL Database table
Hi! The pipeline in Synapse (workspace) transfers data from parquet files to a database using a copy activity. Everything has been working fine for months, but today it simply times out without a specific error. It seems the problem lies in…
How does Intune license verification work?
Hello, I have a few questions that I haven't found an answer to. Intune license is per user. However, a user may have multiple devices. What's stopping you from using one account to add devices to Intune and transferring those devices to users who don't…
Connecting Azure Data Factory to Azure SQL Managed Instance
I am trying to connect Azure Data Factory to Azure SQL Managed Instance, but I cannot get it to work. The MI is on a private endpoint, and the Data Factor is on a private endpoint. I created the Linked Service with a private endpoint: When I create…
If I stop the database will it cost me in Azure?
If I stop the database will it cost me in Azure?