How to back up Azure SQL DB into BAK file?
I am trying to create a Bak file format from Azure SQL DB into Azure Storage (like Blob storage) on a daily basis for an external client. Previously, I had an external client to log into that Azure SQL DB to perform query, but it appears that it is too…
Azure SQL Database
I have a Postgres 11 server (Single server) that does not show up in portal, but is still billed
I have a postgres server gaver11.postgres.database.azure.com that should probably have been migrated from Single to Flexible server earlier, but the web app still works and can connect to the server. However, I can no longer see the server in the portal…
Azure SQL Database
SSMS 22 Azure validation and weird email address
I installed SSMS 22 today, and when I try to connect to an Azure SQL Database and server, I get the following prompt with some weird email address. I have NO idea where it is pulling that from. I have ZERO issue with SSMS 21, but with SSMS 22 this is an…
Azure SQL Database
Can't find what is preventing auto-pause from working
I have a General Purpose - Serverless database set-up. Auto-pause was initially working, but as of sometime yesterday, it will not pause. I initially found that I had SSMS open and suspected that was the issue. However, it has been closed for hours…
Azure SQL Database
I have deleted a SQL server that needs to be recovered
I have deleted a SQL Server because of redeployment. Before doing the redeployment I have exported the databases to BACPAC files in a storage account, but now it turns out there's no data in these bacpac files.
Azure SQL Database
Download database data
Hello, we have already cancelled our account, but we would like to download our data to keep it safe. We have already downloaded the WordPress data, but we are unable to download the database data; we receive an error message, see also attachment. How…
Azure SQL Database
Cannot establish ODBC 18 Connection via Interactive authentication
I have been unable to create an ODBC interactive connection to an Azure database. The credentials work fine in SSMS and using the SQLCMD. The browser window opens and allows me to authenticate. I have tried using the ODBC manager (32-bit) as well as…
Azure SQL Database
SQL export job stuck
I'm trying to export an SQL-database hosted in Azure, but it gets stuck on 1% and does not seem possible to cancel the export and start again? How do I proceed?
Azure SQL Database
Azure SQL Database Hyperscale Serverless
I have a database in Azure. It's an SQL Database that runs only one process per day, just one in 24 hours. When this process runs, it consumes a lot of DTUs and CPU, requiring approximately 4 to 6 vcores. Therefore, I configured this database with a…
Azure SQL Database
Unexpected billing for the Azure SQL Database Service tier Basic
Hi, I have been using the Azure SQL Server Database with the Basic level service tier for many months now. But just for the last month I got the bill of around 200 Euros and the bill was for the SQL Database Single/Elastic Pool General Purpose - SQL…
Azure SQL Database
Issue while importing bacpac file into sql server database
I’m trying to import a BACPAC file into a new SQL Server database. My BACPAC file is stored in an Azure Storage account. When I use the “Import Database” option on SQL Server, I select my storage account and provide the necessary credentials (username,…
Azure SQL Database
Impact of increasing Azure SQL DB size from 500 GB to 1 TB
Dear Experts, I am planning to increase my Azure SQL DB from 500 GB to 1 TB (S4 compute tier) Would there be a performance impact during this time? Or any possibility of an outage? Could you please advise? I saw this link…
Azure SQL Database
How do you connect to a read-only replica created by Read Scale-Out through an endpoint rather than using ApplicationIntent=ReadOnly
I am trying to connect to and Azure SQL Database Read-Only replica using Power BI, but have run into the issue of it not consistently connecting to the RO Replica. There seems to be no tools to solve this in Power BI so i am left with the only other…
Azure SQL Database
I need some help with getting data from my SQL MI into my Azure VM
Good day, We are busy moving from on prem solution into Azure. A big issue I have run into is, currently we have automated jobs that takes data from SQL, runs a PowerShell script, creates a CSV where it then gets dropped onto my VM where it can be…
Azure SQL Database
oracle api connection is generating error of
Hi, I m trying to create oracle api connection from terraform with pipeline , but it is creating error. im giving all values and keys , as per azurerm terraform format. resource "azurerm_api_connection" "oracle_connection" { …
Azure SQL Database
We no longer have access to view our tables in our DB
Hi, So we have a database in our account called "bayer-server-test." After a bit of turnover in our agency, we seem to have misplaced the actual admin credentials to this DB. We do have a user that can connect to the DB, but we can't view our…
Azure SQL Database
When trying to create a SQL Managed Instance link, we keep receiving a "Create Failed for 'New Certificate'." error.
When trying to create a SQL Managed Instance link, we keep receiving a "Create Failed for 'New Certificate'." error. We have tried every instruction in documents we were able to find online. We've created master keys, we've verified…
Azure SQL Database
Convert Julian dates in Normal date
How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates
Azure SQL Database
SQL Server Integration Services
Developer technologies | Transact-SQL
SQL Server | Other
Is it possible to set up SQL Server cross database queries from Azure SQL dbaas to Azure SQL Managed Instance
I have successfully created cross database queries between databases on the same Azure dbaas instance but is it possible to create cross database queries from a database hosted in our Azure SQL dbaas instance to a database in our Azure SQL Managed…
Azure SQL Database
Elastic Pool Limit Reached
We are having an issue where we are exceeding the request limit of an elastic pool and we have no idea why because when we perform the same task in a test environment the problem does not occur. What we are trying to do is upgrade a database by running…