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
pg_repack log file keeps growing after plugin removed
We added pg_repack to deal with busy tables. A repack went rogue for some reason and the log file grew WAY beyond 2x the size of the table being repacked. We reconfigured to allow more space but the log file just kept growing. We then disabled the plugin…
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…
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
Microsoft SQL Server Studio - Dark Mode
Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?
Azure SQL Database
Developer technologies | Transact-SQL
Developer technologies | Visual Studio | Other
SQL Server | Other
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
Cannot execute SQL cursor in Azure Query Editor (Preview)
Hi, I am trying to run a simple cursor in Azure Query Editor (Preview). In Azure Query Editor, it does not run and shows no output. But the same code works in SSMS 21. Is this a limit in Query Editor? Do I need special permission? Thanks.
Azure SQL Database
Get-AzMaintenancePublicConfiguration timeout
Hello, I have some problems with Get-AzMaintenancePublicConfiguration. Sometimes it works perfectly fine, but often it times out. Do you have any advice? Code: $MaintenanceConfiguration = "SQL_NorwayEast_MI_2" $MaintenanceConfig =…
Azure SQL Database
Regarding Root CA Changes for Azure SQL Database and Azure Database for MySQL
Hi Support, The following two links contain the main content of this question: Azure SQL: https://learn.microsoft.com/en-us/azure/azure-sql/updates/ssl-root-certificate-expiring?view=azuresql Azure Database for MySQL:…
Azure SQL Database
Stop/start schedule Azure SQL Managed Instance
Hello, I have a managed instance currently configured with 4 vCores, 64 GB storage, and local backups. I have configured the instance with a nightly stop/start schedule (from 11:00 pm to 06:00 am each day). I would like to estimate the actual…
Azure SQL Database
SQL Arc to Azure SQL MI migration through MI Link - Failed
Link creation has failed because of the following reason(s): Failed to join distributed availability group DAG_Northwind.Join DAG operation on…
Azure SQL Database
Sync Azure SQL Database across Tenants
Hi A customer wants to access some table that we host for them, we don't want then to have access to our database, so we have proposed looking into Sync Azure SQL Database is this available across Tenants (mine and theirs)? Also i need to cost this for…
Azure SQL Database
Data is not sync from Member to Hub db.
I already configured column and table in sync group but data is only updating when I execute SQL query manually but If I performed scenario from .NET application then sync is not working (.NET Framework with EF). I checked that azure sql trace and found…
Azure SQL Database
Data load to the managed sql instance is taking forever, DB server is not responding and there is time out error also
Failure happened on 'Sink' side. 'Type=Microsoft.Data.SqlClient.SqlException,Message=Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.,Source=Framework Microsoft SqlClient Data…