Questions tagged [azure]

Microsoft Azure is a Platform as a Service and Infrastructure as a Service cloud computing platform. Use this tag for database administration questions involving Azure. General server help can be obtained at Super User or Server Fault.

Filter by
Sorted by
Tagged with
0 votes
0 answers
21 views

Mounting mysql /var/lib/mysql on Azure File Share

With Azure Container Apps, I'm trying to mount mysql on Azure file share, and the container shows running status but as soon as I enable ingress on TCP 3306, the container fails. InnoDB ...
user avatar
0 votes
0 answers
9 views

Trying to speed up production build using Gradle with Azure Devops

https://docs.microsoft.com/azure/devops/pipelines/ecosystems/android pool: vmImage: 'macos-latest steps: -task: Bash@3 - displayName: Check for skippable builds inputs: targetType: 'inline' ...
DarraghM's user avatar
-1 votes
0 answers
22 views

Managed Instance Failover Group Not Replicating New Databases

I have setup a managed instance failover group in Azure, but when I restore my databases onto it (small databases) they don't replicate across to the secondary. I did the restores yesterday and they ...
Matthew's user avatar
  • 31
1 vote
1 answer
33 views

Azure SQL Database Elastic Pool Resource Limit Exceeded - How to Resolve?

I'm encountering an issue with my Azure SQL Database where I'm receiving the following error: System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command ...
Jef's user avatar
  • 111
0 votes
0 answers
40 views

Failed to connect to Azure SQL Database using ODBC Driver 17 with Authentication=ActiveDirectoryMsi

I was trying to connect the Azure Container Instance to my Azure SQL Database using Azure Active DIrectory User Managed Identity. But I can't establish a connection using ODBC Driver 17. Error Message:...
xbai15's user avatar
  • 1
0 votes
0 answers
21 views

Whitelist Azure Databricks SQL Warehouse access to selected tables

Is there an option to allow a service principal (SP) that accesses Azure Databricks SQL Warehouse using a personal access token (PAT) to restrict access only to selecting data from present tables and ...
Talos's user avatar
  • 101
0 votes
0 answers
14 views

Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave

I have a requirement Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave . On Master & slave host ssl is enabled . also i have followed ...
Uday Raj Gupta's user avatar
1 vote
1 answer
40 views

Download certificate from Key Vault w/ private key for use in SQL Server (TDE) via powershell

I need to download an x509 Certificate from Azure Key Vault and import it in SQL Server to use for TDE. Note: I'm not referring to EKM providers/ASYMMETRIC KEYs, where SQL accesses key vault to pull ...
StrayCatDBA's user avatar
  • 2,073
0 votes
1 answer
46 views

Configuring SQL Server 2019 Always ON between 2 Azure reqions

I have SQL Server on Azure VM which I want to replicate across a separate region. I will only be using 2 servers, each in a separate region. I have the following questions as I need to clear all ...
dennis's user avatar
  • 1
0 votes
1 answer
32 views

What is the benefit of multiple subnet (FCI/AG) in a virtualized setup?

In a virtualized setup, for example on-prem VMware based virtualized setup or Azure based VMs, what exactly is the benefit of placing the SQL FCI or AG nodes in separate subnet?
variable's user avatar
  • 3,430
0 votes
2 answers
46 views

Azure Disk performance optimizaton in SQL VM

We are using Azure SQL VM and we have multiple data files of multiple databases stored on same drive (let's say Drive E: of size 3 TB) which is created from 4 * 512 GB disks + 4 * 256 GB disks. I was ...
Bishal Basyal's user avatar
0 votes
1 answer
21 views

How to add information about two same named databases on different hosts in PgBouncer config file?

I want to add details for databases in a config file of pgbouncer. I have two same database names but their hosts are different, as there is no information about server endpoints in the config file, ...
pratiksha ratnaparkhi's user avatar
0 votes
0 answers
18 views

Move data between DBaaS with Azure pipeline

I need to move data from tst DBaaS to acc DBaaS, DBaaS are not connected as azure resource or something like that. Im trying to select some data from DBaaS A and insert it in DBaaS B using Linux Agent....
user avatar
0 votes
0 answers
28 views

Azure Hybrid Benefit-Self-Installed SQL Server on Azure VM

The Microsoft documentation says if you self-install SQL Server on Azure VM, you need to manually register with the SQL IaaS Agent Extension and activate Azure Hybrid Benefit. https://learn.microsoft....
steve's user avatar
  • 47
1 vote
0 answers
18 views

New WS install win11 Pro and O365: Connection to DB fails due to change in ownership from SQL to Azure. Is it a Permissions issue?

Security System: Unable to connect to Local Database Template. Error Message: The remote computer that you are trying to connect to requires Network Level Authentication (NLA), but your Windows domain ...
Dragonfly's user avatar
1 vote
0 answers
116 views

[error]Script failed with error: Error: Unable to locate executable file: 'powershell'. Please verify either the file path exists or the file

Functionality: Copy Data to Azure PostgreSQL Server through CI/CD Pipelines I have the SQL Script file of local PostgreSQL DB in the Azure DevOps Repository: Using Classic Editor, I have added few ...
user avatar
0 votes
0 answers
25 views

MariaDB in Azure Converted to Read-only mode

We have a MariaDB instance in Azure following the specs General Purpose, 2 vCore(s) Auto Scale in Size No Read-Replicas Previously It was in 10GB, after adding a couple of queries, the storage ...
user avatar
1 vote
0 answers
22 views

REINDEX not using all available resources, running forever

I have an Azure Database for Postgresql Single server instance, which is running PostgreSQL v11. In it, I have a table responsible for gathering the metrics regarding user logins. The table definition ...
Marcel's user avatar
  • 111
1 vote
1 answer
44 views

Can I develop a Dashboard Report for Data Allocated vs Max Storage for my Azure Database?

I have an Azure SQL Server Database - Managed Instance I'd like to monitor. Here is the widget that Azure shows me on the database summary page. I'd like to put this widget, or at least the ...
Yossi Geretz's user avatar
0 votes
0 answers
54 views

Enable Azure SQL DAC (Dedicated Admin Connection)

This page claims that you can connect to Azure SQL with a Dedicated Admin Connection (DAC but not Data-tier Application): https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/...
Simon Norton's user avatar
-1 votes
1 answer
39 views

Azure SQL Database :: SHRINKDATABASE increase the unallocated space

I'm trying to squeeze as much Azure SQL Databases as possible in order to make them fir inside a SQL Elastic Pool. I'm using this query that allows me to compare the unallocated space before and after ...
Francesco Mantovani's user avatar
-1 votes
1 answer
216 views

SQL Elastic Pools: "The semaphore timeout period has expired" while REBUILD index

I'm shrinking databases that are already on a SQL Elastic Pool. The goal is to fit as much as possible databases in a unique Elastic Pool. In order to do so I've stubble upon a blog that suggest to ...
Francesco Mantovani's user avatar
-1 votes
1 answer
178 views

How should I handle index maintenance on partitioned tables in Azure SQL DB?

let's start saying that i have no experience with partitioned tables and i'm not quite sure how to handle index maintenance (periodically Rebuild / Reorganize, if needed, to reduce index fragmentation)...
Grasba's user avatar
  • 1
1 vote
3 answers
236 views

How to shrink databases and claim more storage

I have created a SQL elastic pool but I have no more storage: I run DBCC SHRINKDATABASE (N'db1') on every single database to claim space following this guide: Reduce Azure SQL Database Size but it ...
Francesco Mantovani's user avatar
0 votes
1 answer
60 views

Configuring a DNN listener for an availability group fails

I am running into problem when creating DNN listener on Azure VM. I am runnign the script provided in Microsoft article: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/...
VitalicJJ's user avatar
0 votes
0 answers
56 views

Azure Elastic Job running a stored procedure says it completes but is faster than in SSMS

I've set up an Azure Elastic Job to run a Stats Update on several Azure SQL Shards. When I run this SP on the shards from SSMS some are quick and some take over an hour. When I run the Elastic Job it ...
Chris Ward's user avatar
1 vote
0 answers
53 views

OPEN SYMMETRIC KEY from AKV takes too long randomly

This post is similar to another question listed here. Encrypting data by OPEN SYMMETRIC KEY by ASYMMETRIC KEY created with Azure provider in SQL server takes more than 2 min We are also facing the ...
Imtiyaz Thange's user avatar
0 votes
1 answer
76 views

How to archive a on-premise sql server database to azure

We have an on-premise database of about eight terabytes that we are trying to archive to Azure. How can we go about it? This archive needs to be accessible because we might need to pull data from it ...
user avatar
0 votes
0 answers
316 views

SQL*Net message from client too important

It is not easy to describe my problem but I will try. We noticed a slow processing problem with the database when migrating an application from a current VM named VM1 (RedHat 7.9, Java 8, Tomcat, ...
user avatar
0 votes
2 answers
500 views

Import data from on-premise SQL Server to Azure SQL

I need to copy data from an on-premise SQL Server to Azure SQL Server (on existing database). I've tried through a .bacpac file (no good, it create a new database) and with SQL Server Management ...
user avatar
0 votes
0 answers
110 views

Best way to proxy all PostgreSQL database requests through a single server

I am currently use AWS to host a number of EC2 instances and Container Services of which some connect to an RDS PostgreSQL database. We have recently been tasked to migrate all of our Database ...
realnsleo's user avatar
  • 115
1 vote
1 answer
74 views

Azure VM Drive size configuration for MS-SQL

I have run into a scenario for a production server where I was recommended to create a separate drive for each one of the bigger clients (based on database sizes) whereas all other smaller clients can ...
Bishal Basyal's user avatar
3 votes
1 answer
315 views

How to reclaim space on Sql Server Azure

I have an Azure Sql Server database (in the cloud, not on a VM)(Not a managed instance) which currently has 270 gigs of space allocated to it. However, the actual space used is 27% (81 gigs). I would ...
Greg Gum's user avatar
  • 133
1 vote
1 answer
51 views

Does Azure MariaDB support admin user authentication with Azure AD?

I did not find that is documented for MariaDB. I see no open MariaDB Jira issues about this either, but I'm wondering if the community knows if it works or if any MariaDB customizations are needed to ...
Patrick's user avatar
  • 111
5 votes
1 answer
621 views

MS Azure Mysql flexible server consumes all Memory

I have MS Azure MySQL Flexible server running in Azure with 4vCPU and 32GB of RAM. It consumes all memory it gets and definitely is choking at lower configurations than 32GB, which seems to be an ...
ArUnio's user avatar
  • 51
0 votes
1 answer
58 views

SQL code that runs on Azure via GUI fails silently via pyodbc

Background: I am building a complex data analysis tool, and part of the process is to run some pretty deep and complex SQL from python. I am using pyodbc to connect to a SQL server instance hosted on ...
Ben Greene's user avatar
0 votes
1 answer
224 views

Restore a .bak in azure managed Database SQL

I have a database in azure bucket (.bak) that comes daily from another system and I want to create a stored procedure to restore a database. I have seen many guides about the command BACKUP RESTORE... ...
Lorenzo De Francesco's user avatar
0 votes
0 answers
56 views

Get product version if an Azure SQL managed Instance

Our SQL Azure managed instance was SQL2019 (15), we took a Prod backup to restore to the DEV and it errors "The database was backed up on a server running version 16.00.4001" Yes, they ...
user avatar
0 votes
1 answer
341 views

Dedicated SQL Pool In Azure - Cannot use System Views to calculate size for tables

I know that it's a repeated question but I've tried all solution and workaround suggested from every possible question present on stackoverflow.com I have inherited a dedicated SQL Pool with a SQL ...
Fedeco's user avatar
  • 103
0 votes
1 answer
227 views

store password for pgcrypto

When encrypting a sensitive information for a field, we may encrypt the field with pgcrypto using something like this: INSERT INTO employees (email, password) VALUES ( '[email protected]', ...
troubleddev's user avatar
0 votes
0 answers
15 views

Backup SQL Server on a shared folder from Azure DevOps / Command line [duplicate]

I need to back up my database using a command line instruction. I launch the backup instruction from a Azure DevOps Release Pipeline to back up my SQL server database on a share folder on another ...
Bastien Vandamme's user avatar
0 votes
0 answers
23 views

Using SQL Server data files in Microsoft Azure for historical data?

It is possible to create new data file for database which is stored in Azure BLOB storage. In the documentation is said that: Always On availability groups are supported as long as you do not add new ...
gotqn's user avatar
  • 3,770
0 votes
1 answer
277 views

How transaction is matched with read and write operations in BLOB storage (azure)?

In Azure Monitor, for particular blob in storage account we have the following metrics: ingress (GiB) engress (GiB) transactions (count) It looks like: I have a database which data and log files ...
gotqn's user avatar
  • 3,770
0 votes
1 answer
156 views

Azure SQL Database Sync Login Issue

I wish to transfer data between two different databases on the same Azure SQL server (not managed instance). I have an admin account. When i goto setup Data Sync within the Azure portal i cannot see ...
AutomeShane's user avatar
-2 votes
1 answer
142 views

What does "edge" mean when talking about Azure SQL?

In this Azure SQL intro page, they state: A consistent SQL experience from edge to cloud Get a unified experience across your entire SQL portfolio and a full range of deployment options from edge to ...
Fajela Tajkiya's user avatar
2 votes
1 answer
91 views

AWS to Azure Degraded Performance With "Hash Match (Aggregate) Step"/"Temporary Disk" TempDB Performance Issue

Ok, so I have a series of AWS VM's, mostly using the z1d.3xlarge server class with built in SQL Server 2019, these servers each contain a NVMe of various size. (Not surprisingly) I've placed my SQL ...
David Rogers's user avatar
0 votes
1 answer
279 views

How to prevent deletion of Azure SQL db in SSMS

Is there a way to prevent deletion of Azure SQL database within SQL Server Management Studio using one account? Of course, this is on ONE admin account. We tried to follow this URL: https://www....
user avatar
0 votes
0 answers
274 views

Azure SQL performance is same with various vCore options

We are testing one feature in our enterprise application with Azure. It try to Insert / Update / Delete / Fetch around 110K rows , The Java Web App is deployed in local machine , And we tried Local On ...
user avatar
0 votes
1 answer
96 views

Recommendations for extracting and archiving rows from a fast growing table to keep overall database size within 1tb limit

We have an Azure SQL DB that we want to keep less than 1TB in size because making a DB more than 1TB in Azure also requires doubling the vcores and therefore doubling the cost. There is one table in ...
Stephen Graham's user avatar
0 votes
1 answer
646 views

Azure MySql - Adding AD User To MySQL DB

I am trying to add an Azure AD user to my Azure MySQL DB, so that he can authenticate using a token (instead of needing username / password). I am set as the Azure AD administrator of this DB. I am ...
Uri Shapira's user avatar

1
2 3 4 5
8