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…
Azure Data Sync is taking longer than Expected for data sync.
Hi Team, I am doing POC for Bi-Directional data Sync using Azure Data Sync Approach. I am facing following Issues - The minimum time between each sync across databases is 5 seconds. Can this be minimized further. Assume we are bi-directionally…
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
bit null ,0
Hey Team, have column1 datatype (bit,null) so it only takes values like 0 and 1 but i want true , false as well...how to get that in same datatype or in different one
How do I copy all columns properties with copy activity in data factory
Hi, I'm copying data from one DB to another DB with copy activity and auto create table. I noticed that when the table is creating on the target side it is creating with the column size and type but all the other properties are lost, for example…
Connection failed
Spark job failed: { "text/plain":…
Should I update statistics immediately after migrating to Azure SQL Server Managed Instance
I am migrating my 4TB database of Microsoft SQL Server 2016 2 node AG cluster from on-premises to Azure SQL Managed Instance. I am using Azure Data Studio to migrate through full backup and continuously applying log backup. This backup will be ongoing…
im trying to reset password for my SQL in azure
Hi everyone, i think i hve forgot my password to my sql account. i im trying ways to reset it, by nithing helps, any idea on this?
How can I get more details on the costs of a database usage on azure?
I have an SQL database that seems rather costly for the usage that I make of it (1000$/mo for ~$4Gb storage + less than 30 of compute per day) but i can't figure out why exactly from the cost management interface. Is it possible to see a break down of…
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.
Date column in sink table is getting NULL values
Hi, I have two fields in my source .csv file which is Date1(format- YYYYMMDD) and Date2(format- YYYYMMDD), I have corresponding table in my SQL database with the same fields with data type as datetime2. Now I am trying to load the data from my source…
Azure SQL Database Varbinary data type
I am facing issues while retrieving varbinary data from sql server tables ,Performance is taking a toll , 4 lakh records are taking around 20 hrs to read and write into target db tables
Azure upgrade email broken link. How to upgrade?
Hi Everyone, I received an email from azure-noreply@microsoft.com stating, "Upgrade by June 23, 2024 to save your data and keep building in Azure". The email has an "Upgrade now >" link which goes…
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…
SQL Access Strategy
I would like a strategy for the use of Azure SQL with our cloud environment. The DB is in azure SQL. I would like to come up with a solution for giving access to developers and extended/other teams for dev/support needs. WE have to add users and give…
During database migration in online mode using Azure data studio status is restoring only on sqlmi.
During database migration in online mode using Azure data studio status is restoring only on sqlmi. it's not changing since long time. Though Azure data studio shows restored and Data migration service shows ready for cutover. Data is around 24 GB only.
syncdata db has this error "Database re-provisioning failed with the exception "
I have an Azure sql db that I have a data sync with an on prem db. The sync was working and all was good. 1/31 we added a column to a table in the on prem db. I added the same column to my Azure sql db and refreshed the schema for the data sync. The new…
what is best practice using Azure SQL Database ?
hi? My customer decided to use Azure SQL Database. In Azure, you can create and use multiple databases in one Azure SQL Database Server. Is there any problem if I use it like this? Or do I need to create a SQL Server for each database? The people who…
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…
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…