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.
350
questions
0
votes
0
answers
5
views
+50
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,351
0
votes
0
answers
7
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
19
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
32
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
50
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
50
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
67
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
26
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
50
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
108
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
23
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
4
votes
1
answer
152
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 ...
- 41
0
votes
1
answer
30
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
68
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
26
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
68
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
55
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 (
'employee@corporatemail.com',
...
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
18
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,721
0
votes
1
answer
108
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,721
0
votes
1
answer
61
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
101
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 ...
- 945
2
votes
1
answer
73
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
117
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
115
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
91
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
167
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
1
vote
0
answers
125
views
Create a new user on a read only Azure SQL Server geo replica
I'm looking at creating a read only geo replica of a production Azure SQL Server database on a new azure db server in a different resource group. The idea is offload reporting queries to the replica ...
- 111
0
votes
0
answers
19
views
Best way to have a snapshot of cosmosdb (MongoDB API) database running in production to use in development purpose
We need to create an snapshot from the production database, which is under cosmos dB (MongoDb API), to be used in a development purpose.
To do so, we have create a backup using continuous mode, and ...
- 1
0
votes
0
answers
33
views
Azure SQL MI audit logging
Would like to list out all users logging in to a SQL MI instance.
Is this possible right out of the box or do I need to set up an Audit job?
Seems SQL MI is quite different than SQL DB when it comes ...
- 1
0
votes
0
answers
32
views
Automatically killed Mysql database restoration
I have 9 databases in AWS RDS aurora mysql. it's size around 500GB so I want to migrate all databases to azure MYSQL. The database aren't in use so no need to live replication or anything. I just dump ...
Aravind rajamani
0
votes
0
answers
97
views
Copy data from Data Lakes to Dedicated SQL Pool - Data Type overflow error
We have a synapse pipeline that copies data from Data Lakes (Parquet Files) to the Dedicated SQL Pool in Azure. The problem is that some of the Copy Data tasks fail with a "Arithmetic overflow ...
- 11
0
votes
0
answers
87
views
track all users access to database" vulnerability in azure sql database giving no result
I am getting "track all users access to database" vulnerability in azure sql database but after clicking on it the result page shows message that "query yield no result" and both ...
- 1
0
votes
0
answers
26
views
Restore issue with Server size in Azure SQL managed Instance
How SQL database restore work in Azure managed Instance where I have 1TB max storage.
My database size is 580GB. When We request a point-in-time restore ,It will create new database with 580GB size ...
0
votes
2
answers
381
views
Azure Postgres "flexible server" could not write to file pg_tblspc: "No space left on device"
I just created a new instance of PostgreSQL Flexible Server, version 14, on Azure (Memory Optimized, E8ds_v4, 8 vCores, 64 GiB RAM, 512 GiB storage). I took a backup of a "single" server, ...
- 47
0
votes
1
answer
102
views
MariaDB / MySQL performance optimization Azure disk access
We have a lot of MariaDB's that we have recently moved to "Azure Database for MariaDB server". Most of the time it works OK, but we sometimes experience some snags with slow queries compared ...
- 101
0
votes
0
answers
128
views
Encrypting data by OPEN SYMMETRIC KEY by ASYMMETRIC KEY created with Azure provider in SQL server takes more than 2 min
Have created a SYMMETRIC KEY for decryption by ASYMMETRIC KEY and the ASYMMETRIC KEY is created with Azure keyvault based key provider. Have used the details provided from Here and Here
Have used the '...
- 103
0
votes
0
answers
34
views
Local to Azure backup errors and question
I am wanting to back up a local SQL Server 2016 database to Azure.
When I first started looking into it, I found this quote from the Azure usage calculator.
When I tried to set it up, all the ...
- 193
0
votes
0
answers
74
views
Recommended way for multiple domain names to Azure PostgreSQL flexible server
I have a data warehouse in PostgreSQL hosted on Azure, which needs to be accessed via different usernames for different marts (schemas) from PowerBI. PowerBI does not support having multiple users ...
- 101
4
votes
1
answer
503
views
'SUSER_SNAME' cannot be invoked with parameters in this version of SQL Server
I was reading this blog post which contains a query that can allow you to find when a DROP was fired. I changed LIKE 'DROPOBJ%' to NOT LIKE 'DROPOBJ%' so I can return more rows:
SELECT [Current LSN]
...
- 1,351
0
votes
0
answers
36
views
Azure equivalent of Ask Tom for Oracle
We are in the process of moving our Oracle infrastructure to Azure and attempting to implement their suggested HA solution. Not surprising, that throws up some specialised questions. In the Oracle ...
- 71
0
votes
1
answer
81
views
How do I enable MSSQL Transparent Data Encryption (TDE) with Azure Keyvault (Bring Your Own Key - BYOK) after importing a .pfx certificate?
In an Azure Keyvault,
I manually create a 2048 bit RSA key called "Encrypt".
I then import a .pfx 2048 bit RSA key called "Import".
Back in MSSQL, I can use the "Encrypt" ...
- 103
0
votes
1
answer
382
views
super user tasks within Azure Database for PostgreSQL
I am new to Azure, and I needed to do some tasks that I generally do with the standard superuser in localhost or on premises postgresql installations.
1. Backup case
For tests/debug purposes, I need ...
- 123
0
votes
0
answers
52
views
Synapse SQL: How to replicate "Query Activity" pane?
How can I replicate the Query Activity result window on Azure for my dedicated SQL pool on Azure Synapse?
https://i.stack.imgur.com/7vgu2.png
sys.dm_pdw_exec_requests only contains a small number of ...
- 101
0
votes
1
answer
584
views
SQL Server - Access denied when reading a file from Azure Blob Storage container using SAS key
I have a requirement to read CSV files from an Azure blob storage. So far, this is throwing access denied errors every time I run my query:
CREATE DATABASE SCOPED CREDENTIAL <myScopedCredential> ...
- 109
0
votes
1
answer
321
views
Azure Data Factory - copy data activity into a Postgresql database (on an IaaS Windows Azure vm, not Azure Database for Postgresql (PaaS))
I have a Postgresql database on a Windows vm (not a PaaS Azure Database), and I need to import csv files into it daily. ADF seems like a perfect fit, but I see that a standard Postgresql db is not a ...
- 71
0
votes
1
answer
430
views
Invoke-AzVMRunCommand on Azure VM using domain user
I am working on ARM template to setup SQL server VM on Azure with Always on High availibility setup using Win server 2019 and SQL Server 2019 Enterprise image. I am trying to automate everything using ...
Nirav B
0
votes
1
answer
303
views
DBATools :: how to query Azure SQL Databases with MFA
I'm following the official DBATools guide regarding how to query Azure SQL Databases.
This code is working:
$azureCredential = Get-Credential -Message 'Azure Credential'
$azureAccount = Connect-...
- 1,351
0
votes
0
answers
37
views
SQL Server 2016 TDE and Encryption at Host compatibility
As part of a SQL migration to Azure (SQL Server on Azure VMs), the decision was made to implement Azure Disk Encryption (ADE) along with Transparent Disk Encryption (TDE) - a double-whammy setup of ...
- 1
0
votes
1
answer
46
views
Implement sp_wait_for_database_copy_sync for syncing primary and secondary azure database
I want to implement sp_wait_for_database_copy_sync for each transaction to avoid the dataloss when failover happens from primary to secondary.
What is the best design ? Do we need to implement in the ...
