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.
Azure Data Studio - Can we do online migratation of same db on prem sql to two different target(sql manged insance)
Hi Azure Data Studio - Can we do online migratation same db (on prem sql) to two different target(sql manged instance) wiht azure migration extension in azure data studio I am wondering what does the tool do as part of cutover.What activities are done…
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…
I am encountering an error when trying to debug a data flow in Azure Data Factory that connects to an Azure SQL Database. My linked service and dataset connections to the Azure SQL Database are working fine, and I can preview data without any issues.
I am encountering an error when trying to debug a data flow in Azure Data Factory that connects to an Azure SQL Database. My linked service and dataset connections to the Azure SQL Database are working fine, and I can preview data without any issues.…
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…
Azure Elastic Job execution failing
I have created an Azure Elastic Job following the example here: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tsql-create-manage?view=azuresql However, the job execution if failing with the following: Failed to determine members…
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…
Microsoft SQL Server Studio - Dark Mode
Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?
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…
Could not open a connection to SQL Server After publishing an ASP.NET Web project to azure using VS2022
There is a bug in the publishing code because I used the UI to publish my on premise app from visual studio 2022 and it didn't set the App service or the Sql Server correctly because The app service can't access the database and I get the follwing…
How to establish connections of azure data factory connectivity with AWS dynamo DB
How to establish connections of azure data factory connectivity with AWS dynamo DB - provide a Micrsoft Documentation so that we can follow that to establish the connectivity in between the Azure as well as the AWS platform.
Connection Error Between Azure SQL DB with the codebase.
I have created a SQL DB in the azure portal, setup it's server and crate a database table using the azure Data studio. Now I setup a Microsoft Entra ID and add my IP for the smooth connection. Now when I want to make a connection with my DB, I am…