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.
363
questions
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 ...
user1930027
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'
...
- 1
-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 ...
- 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 ...
- 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:...
- 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 ...
- 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 ...
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 ...
- 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 ...
- 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?
- 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 ...
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, ...
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....
Bartek
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....
- 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 ...
- 11
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 ...
anon
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 ...
Abdul Hakeem
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 ...
- 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 ...
- 113
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/...
-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 ...
- 1,494
-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 ...
- 1,494
-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)...
- 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 ...
- 1,494
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/...
- 55
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 ...
- 101
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 ...
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 ...
David ONAJOBI
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, ...
dsea
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 ...
bit
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 ...
- 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 ...
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 ...
- 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 ...
- 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 ...
- 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 ...
- 29
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... ...
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 ...
user3284286
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 ...
- 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]',
...
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 ...
- 163
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 ...
- 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 ...
- 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 ...
-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 ...
- 1,157
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 ...
- 205
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....
ttest2727
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 ...
Chanky Mallick
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 ...
- 101
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 ...
- 103