Questions tagged [azure]
The azure tag has no usage guidance.
240
questions
2
votes
2answers
59 views
How can I query on-premise SQL Server database from Azure SQL database using stored procedure?
I have a Azure SQL database and it has a stored procedure from where I am trying to join a table which resides in on-premise SQL server database.
Essentially, I am trying to query a table which sits ...
2
votes
1answer
104 views
Can't restore database with (apparently) same version
I'm trying to restore a SQL Server database instance in my local machine I've backed up from an Azure Cloud environment but I'm getting the following message:
System.Data.SqlClient.SqlError: The ...
-2
votes
1answer
28 views
Exception Message: Unable to connect to the remote server
I am trying to backup a database in azure storage and I keep getting the below messages
Msg 3271, Level 16, State 1, Line 1
A nonrecoverable I/O error occurred on file "azure storage backup ...
0
votes
1answer
28 views
Issues deploying SSIS package to SQL Server in Azure AD Domain Services (AADDS) environment
We use Azure Active Directory (Azure AD) in my organisation, and we recently deployed Azure AD Domain Services AADDS) to handle a SQL Server 2019 we use internally.
My Azure AD domain is (fictitiously)...
2
votes
0answers
52 views
Confounding NUMA configuration in SQL Server for 24 vcore system in Azure
I need some help understanding how SQL Server takes a 24 core VM and displays it as 11 NUMA nodes under properties.
At startup, this is the key message about hardware SQL Server found:
SQL Server ...
0
votes
0answers
24 views
azure mysql database replication with on-prem mysql master is failing with 2003 error
I have setup azure mysql master database and I would like to do data-in replication with an on-prem mysql database but the replication is failing. Can someone tell me the reason ?
I am able to connect ...
0
votes
2answers
24 views
Vertical Elastic Query is not identifying Object
I did create an External Datasource, identical to the guide described here https://www.sqlservercentral.com/articles/cross-database-queries-in-azure-sql-database .The process is pretty simple, so just ...
-1
votes
1answer
33 views
sqlserver on linux Azure performance [duplicate]
Im new to sqlserver, we have a sqlserver running on linux and we are encountering performance issues
i see sometimes SUSPENDED on the queries / selects etc
If i change the max degree of parallelism ...
0
votes
2answers
61 views
Cannot insert duplicate key row in object 'tablename' with unique index
From yesterday our Data Warehouse running on Azure SQL Server getting the error:
Cannot insert duplicate key row in object 'odl.Dim_TraceBackFinishedProduct' with unique index.
Error details:
SQL - ...
1
vote
3answers
70 views
I have a bunch of SQL databases. How should I put these into Azure? [closed]
I have a bunch of on-premise SQL databases that contain data related to HR. One database could be pure employee data, such as staff records, leaver records or recruitment records. Another database ...
1
vote
0answers
17 views
Deploying MariaDB Columnstore Docker image in Azure
I deployed the MariaDB Columnstore Docker container in Windows with the following command:
docker container run --name cont_mariadb -e MYSQL_ROOT_PASSWORD=xxxxxxx
-p 3306:3306 -v ...
0
votes
1answer
32 views
Bulk SQL INSERT into Azure SQL Database using spark causes blocking/contention?
I am running the following code using microsoft's sql sparkconnector to write a 1-2 Billion dataframe into Azure SQL Database.
df.write \
.format("com.microsoft.sqlserver.jdbc.spark") \
....
0
votes
1answer
273 views
azure db export to blob storage failed
i am trying to simply export BACPAC file from azure db to azure blob storage
as mentioned here : https://docs.microsoft.com/en-us/azure/azure-sql/database/database-export
but it is failed with error :
...
0
votes
0answers
11 views
Error while setting up Master Slave Replication on Ubuntu
I am trying to setup a Master slave Replication on Ubuntu. I have 2 VM's one master and one slave. I have connected to Ubuntu via Putty.
I am Following this link to configure : https://www....
0
votes
0answers
13 views
How to restore and overwrite an existing database on Azure SQL MI [duplicate]
We are trying to restore a backup file in Azure SQL MI using SSMS. the issue is we are trying to overwrite an existing database and we notice this feature is not present in SSMS for Azure SQL MI but ...
1
vote
1answer
21 views
Can I use Azure Data Lake in place of Data Warehouse to separate Compute and Storage of RDBMS analytics [closed]
I am from a telemetry data engineering background and am looking for some help on a use-case I am not familiar with as to whether my proposed architecture is practically feasible in Azure. The use-...
0
votes
2answers
57 views
Can I use SQL Server Standard Edition as Primary and Enterprise SQL Server as Secondary node?
I have Software Assurance for SQL Server Enterprise Edition and I need to setup High Availability on it.
The issue is my primary SQL Server has a Standard license.
Could I add SQL Server Enterprise ...
0
votes
0answers
16 views
How can Azure PostgreSQL authenticate against Azure AD with username & password instead of a token?
I have used the documentation at https://docs.microsoft.com/en-us/azure/postgresql/howto-configure-sign-in-aad-authentication to enable users in Azure AD to authenticate to an Azure PostgreSQL ...
1
vote
1answer
92 views
Azure Elastic Pool - is it supported for MySQL?
I know that Elastic Pool in Azure is supported for SQL Server.
But I could not find any information if it is supported for MySQL.
I could not find any information in documentation at all what types of ...
-1
votes
1answer
25 views
Azure SQL ports - expect on 1433 - but finding more
Our security department has questioned why we have multiple ports open to our Azure SQL instance.
Ports highlighted as LISTENING are 443, 3006, 5002, 5432, 7443 and a few in the 16000 to 16018 area.
...
0
votes
0answers
19 views
Azure Recovery services vault for sql server machine off
Does azure recovery service vault creates backups of the databases if the machine is off?. Normally the machine is on from the 6am to 8pm from monday to friday, but the idea is to do a full backup at ...
1
vote
2answers
109 views
Does binlog_group_commit_sync_delay affect existing binary logging in MySQL
We want to tune the setting binlog_group_commit_sync_delay to increase replication performance. Our slave is currently two days behind. Does changing this setting affect the current backlog or will we ...
3
votes
1answer
43 views
Azure Readable Secondary - How to: Different Access Policy to Primary?
We have primary databases. They are in a mix of elastic pool, and standalone.
We have successfully created active geo replicated secondaries. (Our use for these is solely workload isolation.)
We want ...
0
votes
1answer
58 views
Decrease Data IO operation on query to lower the DTU cost on Azure
We have a FunctionApp in Azure that triggers on a timer and does some DB operations every 5 minutes. These operation are taking a very long time to complete. When I run the same query on my computer ...
1
vote
0answers
19 views
Choose Right Azure SQL [closed]
I'm new to Azure and now trying to migrate the On-premises SQL databases on azure.
I have chosen VM SQL for migration because I just want to lift and shift architecture and need to restore backup file ...
0
votes
1answer
17 views
Unable to create Functions/Store Procedure Azure mySQL
I have just set up a MySQL database with Azure and I am using Navicat to connect to it and everything is working fine. I am now trying to create some Functions and Store Procs but I am getting a Super ...
1
vote
1answer
83 views
Deploying dacpac through sqlpackage.exe with NETWORK SERVICE user
I have a database release pipeline in Azure DevOps Server which deploys our dacpac files through Powershell commands that run the sqlpackage.exe commands to publish the database. I am using the ...
0
votes
1answer
54 views
Azure SQL database DTU compute utilization maxing out
I have an Azure SQL database that has gone from a low DUT baseline between 0-3% (avg) to now maxing out at 100% utilization.
This is for a LOB application and we need to understand what is causing ...
0
votes
0answers
28 views
in SSMS, different result sets for a same query in Azure
I have a complex stored procedure that calls different other stored procedures.
I've never seen this behaviour in over 20 years of dba work (since Sql 7).
When I call the stored procedure with about ...
0
votes
1answer
19 views
Not able to restore a database with multiple backup files from Azure blob storage (block blobs)
I was testing the backup with multiple backup files (6) and I was able to successfully take backup for one of my large database (3TB) to my azure storage account by using MAXTRANSFERSIZE, BLOCKSIZE ...
1
vote
2answers
86 views
Best practices for providing PHI/PII data to users in organization
I am looking for best practices for how to share data from a SQL Server database that contains PHI/PII to individuals that cannot view PHI/PII. In short, we maintain a SQL server database that ...
1
vote
0answers
29 views
Synapse: bulk copy from STAGE to DATAMART
I've fact table with rows count ~1 billions/year (~3 millions/day). ETL loads data into STAGE layer/schema with help of Polybase or COPY INTO. Then I'm copying data from STAGE to DATAMART table with ...
-1
votes
1answer
45 views
How does sql server agent access the azure storage blob [duplicate]
Good morning all ,
I must configure an automated backup to an azure blob storage
in the backup script I have correctly configured the credential
now what right is needed for the sql server agent ...
0
votes
0answers
39 views
How does Differential backups knows about full backup
In my environment we have SQL Servers in Azure IAAS. We use netbackup as backuptool. we have an issue where differential backups were failing with the error saying that.
cannot find the Full backup.
...
0
votes
0answers
33 views
Syntax error in adding a job step in Azure SQL Job Agent
I am inserting a job step in Azure Elastic job agent. This is my code:
EXEC jobs.sp_add_jobstep @job_name='Sample T-SQL',
@command=N' declare @columns varchar(max)
select @columns = stuff(( select '],[...
0
votes
0answers
56 views
How many tempdb data files required for this
you have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.you scale up the virtual machine has 16 vCPUSs and 64 GB of ...
1
vote
1answer
52 views
Execution plan of on-premises sql server and Azure sql server is not the same
I've been having some problems with moving databases from on-premises (2014 sql server) to Azure sql server. It's using the exact same database structure and data, but for some reason the query uses a ...
0
votes
0answers
23 views
Revoke privileges on an object a role doesn't own in Postgres
Context
I created a fresh Azure Database for Postgres and here is how it looks like at first:
postgres> \l
+-------------------+-----------------+------------+----------------------------+----------...
1
vote
1answer
69 views
How to start Neo4j on Azure
I'm running Neo4j v4.x on an Azure VM (Linux Ubunto 16.04). Everything was running fine until my project required a resizing for more storage. This seemingly went well as I proceeded to load data, but ...
1
vote
1answer
75 views
Azure tempdb filling up while trying to convert a large table to columnstore… how to mitigate?
I have a large reporting table (approx 6B rows) taking up roughly 400GB of storage on an azure sql db. I've been trying to convert it to a columnstore table using the following commands:
insert Logs(...
0
votes
1answer
68 views
Azure PostgreSQL archiver exited with exit code 1
I'm using Azure PostgreSQL server to store data in my application hosted on Azure App Service.
Yesterday, at some point application started to throw exceptions with connection closed and broken pipes.
...
1
vote
1answer
117 views
What would cause an elastic pool to exhibit high “Sql Server process core percent” metricsj, but low DTU / CPU
Backstory:
We have an azure sql elastic pool with several databases in it and around 750GB of data.
We've been having some sporadic outages which correlate with the metric "Sql Server process ...
1
vote
1answer
50 views
Azure Pipelines: MySQL Exiting and No Longer Available with --initialize or --initialize-insecure (No Clear Errors)
Background (Aka the "Why")
I'm attempting to automate a build of a static website based on a Wordpress site utilizing Azure DevOps Pipelines. As part of that process I need to get MySQL ...
1
vote
2answers
142 views
SQL Server on azure virtual machines default instance
We have two ways of provisioning SQL Server on an Azure virtual machine, one is creating the VM and then upload the binaries of SQL server and do the installation manually, the second one is using SQL ...
0
votes
0answers
46 views
Can't connect to Azure Database for MySQL server
I created a resource in azure: "Azure Database for MySQL server".
I added the firewall rule to connect from my ip. It is a fixed IP.
When I try to check if the socket open it works:
When I ...
3
votes
1answer
54 views
how to mirror an azure storage account to a non-paired zone to enable fast file_snapshot backup/restore and database file access?
Wow, that title was a mouthful.
Scenario
My dev server is restoring a copy of production data daily, anonymizing it, and creating a dev-grade backup for my developers to restore locally. We're running ...
0
votes
1answer
21 views
manage backups azure sql option
This may be a silly question but I recently created an azure sql database and I need to check the backup policy but I cannot find the option manage backups that the documentation shows as you can see ...
0
votes
1answer
41 views
Automated backups sql server IaaS
We have installed sql server on a virtual machine and we have registered the machine so that way SQL Server IaaS Agent Extension (SQLIaaSAgent) gets enable and runs on Azure virtual machines to ...
0
votes
0answers
19 views
Planning Azure SQL Server
I've been tasked to prepare Azure SQL database deployment plan and I am struggling with it...
I've been given following information:
2 million transactions will arrive to database daily throughout ...
0
votes
2answers
327 views
SQL Server 2019 Always On using Distributed Network Name
We're running a couple SQL servers in Azure that are set up with an Always On availability group and Windows Failover Clustering. The servers are Windows 2019 and we're running SQL Server 2019. When ...
