I am using Azure SQL Database with 10gb of storage (Standard S2: 50 DTUs). I am running a process where I am deleting all rows in a table every 6 hours and recreating and loading table from our business system.…
I was able to blob test connection and it's successful, but when I attempt to look for the storage path it shows this error. screenshot Full error: Failed to load Blob operation failed for: Blob Storage on container '' and…
I have created an azure SQL single database "w3s_singledb" with no elastic pool and SQL server named "singledb2022dec". After logging into "singledb2022dec.database.windows.net" I executed "create database w3s_seconddb" and it was created. Next, I created Azure Elastic Pool "elasticpool2022dec" and SQL…
I have a sqlproj XML for Azure SQL Database. I want to deploy database with several tables into specific schema which is also created using this build. How to specify what user should be used for CREATE SCHEMA [schema-name] AUTHORIZATION…
I'm using Azure Data Factory and I have Json files in azure Datalake. Each Json file contain an array of Jsons. I want to copy each Jsons of the array into Azure SQL row. I tried to do it with…
I am trying to set up a connection between Azure MySQL flexible server and Azure SQL database mainly to read data from MySQL and store it in the SQL Server periodically (multiple times a day). I was thinking of creating…
I want to use a azure SQL Database and want connect to it via ip-adress. My current setup: Azure Database e.g. "example.database.windows.net" Private Link in Azure Subnet connected with the database (10.231.1.5) Azure Win VM (10.231.1.4) When I open SSMS…
When I run Invoke-Sqlcmd with a -Query that contains a password retrieved via Read-Host with the -AsSecureString parameter, and the value entered is too simple, it will fail without returning an exception. When I run Invoke-Sqlcmd with a -Query that…
I have created azure sql server machine in azure portal. While creating the machine I for got to add sql server authintication. So Now When I try to login,Only azure active direcoty authintication is enabled. How Can I fix that…
I've created an azure **serverless ** sql database. It seems there is no way to backup/restore this type of databases. I know there is restore to a point in time feature, But I what to download and save database backups…