Questions tagged [azure]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...

1
2 3 4 5