Help with an architecture design
Hello, We have a European customer who wants their data to be located in Europe. We also want to upgrade our current on-prem SQL Server to an Azure Managed Instance (Azure SQL Database is out of scope). Our main database is located in the US, and we need…
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
Azure SQL MI Database Manual Backup & Retention Policy
why do we get such an error when we try to do manual backup for sql server managed instance? In this backup we redirect the backup to url (storage account), but it fails due to encryption error. when we also use command line it fails with the same…
Error accessing Azure sql from Azure databricks using jdbc authentication=ActiveDirectoryInteractive
Getting below error while accessing Azure sql using jdbc from Azure databricks notebook, com.microsoft.sqlserver.jdbc.SQLServerException: Failed to authenticate the user p***** in Active Directory (Authentication=ActiveDirectoryInteractive). Unable to…
Azure Data Flow Sink - Connection string is not valid or missing Server/User/Database properties
Could you please assist here to resolve this issue below ? We are trying to read Delta table and store it as table in Azure SQL Database as using ADF Data Flow. Source Delta table via inline dataset from ADLS Gen2 its working fine and slink is getting…
Why do I copy files to the container? docker cp Documents/sql/QuanLySP.bak azuresqledge:/var/opt/mssql/backup Successfully copied 2.87MB to azuresqledge:/var/opt/mssql/backup was successful. But when I go into
Why do I copy files to the container? docker cp Documents/sql/QuanLySP.bak azuresqledge:/var/opt/mssql/backup Successfully copied 2.87MB to azuresqledge:/var/opt/mssql/backup was successful. But when I go into…
Is it Azure Managed Instance storage having size limit to upload the backup file?
Hello, I am trying to upload the .bak files from my on-prem Sql Server database backup but it's not letting me to load it. I tried with smaller Database and that works but trying to even less then 300 MB database size but not working. Is it Database…
How to move/change Azure SQL Server from one region to another?
We have one Azure sql server hosted in the East US location in Azure and now we want to change its location to some other location. How can I do this? Appreciate it if you give a resolution for this.
Reclaiming free space from TempDB in azure sql managed instance
the TempDB on my azure sql managed has grown to 350 GB but 99% of that space shows as unused. i tried to shrink the database and individual files but the server is not freeing up the space. the space is still reserved for tempdb. Microsoft docs is…
Error Fix (Database engine service failed in sql server 2022 and 2019)
Hello i am having troubles installing sql server 2022. my error is sql database engine fails to starts steps taken to install the sql on my laptop, was that i changed the account name of database engine service ( i did this because i have tried…
On Premises and Azure SQL VM Always On Availability Groups
I am wondering if it is possible to create a SQL Always On Availability Group with on-premises servers and SQL Azure VMs. Please validate two scenarios below.
How can I use Microsoft Entra-only authentication for my nextjs application using mssql and Azure SQL Database
I'm building a fullstack application using NextJs and Azure SQL database. The database is Microsoft Entra-only authentication. I'm using NPM packages mssql for querying the database and @azure/msal-browser and @azure/msal-react for single sign on. The…
vadlidation failed -insuffisient quota cannot create / update/move resources
Hai team, im writting this beacuse I'm attempting to deploy the openAI resource, but an error message appears. stating that "vadlidation failed -insuffisient quota cannot create / update/move resources" Not sure what exactly is the issue and i…
How to copy the data from Amazon S3 to Azure SQL database incrementally.
Hello team, I wanted to wanted to copy data from Amazon S3(JSON format) to Azure SQL database. I wanted to learn the mechanism for incrementally updating the data from Amazon S3 to Azure SQL. Also, the environment has only SHIR deployed, so data flows…
"The multi-part identifier "sys.schemas.name" could not be bound.
Driver version 12.4.0.jre8 SQL Server version Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 2 2024 04:20:23 Copyright (C) 2022 Microsoft Corporation Problem description When we use jdbc to connect to the Azure sqlserver, if we invoke the mssql jdbc api…
When I installed Azure Data Studio connected to SQL version 2022 and wanted to restore advanturework 2022 for practice, there was no Restore data section when right-clicking on the Database, only Filter and Refresh sections. How to fix this error? SQL Se
When I installed Azure Data Studio connected to SQL version 2022 and wanted to restore advanturework 2022 for practice, there was no Restore data section when right-clicking on the Database, only Filter and Refresh sections. How to fix this error? SQL…
Can't able to connect the VM installed postgresql from ADF
Hi Team, We are unable to access the PostgreSQL from the ADF linked server. it's a azure PostgreSQL flexible server, and we have enabled the "Allow public services" setting within Azure for this server. However, we are still unable to create a…
how to accses azure free trial without credit card.
hello i am after al student waiting for my results. my parents dont allow me to get credit card. so how can i access azure trial. i want to learn cloud computing.
The best database in Azure to manage real time data operations.
Hello Experts, I have to manage some real time stock updates between more than 2 online portals and we are thinking to go with Azure Services. And also think to store data in Azure Database services. Hence, we are looking for the database that must be…