As of May 31, 2023, we have updated our Code of Conduct.

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
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 ...
Francesco Mantovani's user avatar
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/...
VitalicJJ's user avatar
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 ...
Chris Ward's user avatar
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 ...
Imtiyaz Thange's user avatar
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 ...
user avatar
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, ...
user avatar
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 ...
user avatar
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 ...
realnsleo's user avatar
  • 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 ...
Bishal Basyal's user avatar
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 ...
Greg Gum's user avatar
  • 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 ...
Patrick's user avatar
  • 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 ...
ArUnio's user avatar
  • 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 ...
Ben Greene's user avatar
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... ...
Lorenzo De Francesco's user avatar
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 ...
user avatar
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 ...
Fedeco's user avatar
  • 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', ...
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
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 ...
gotqn's user avatar
  • 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 ...
gotqn's user avatar
  • 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 ...
AutomeShane's user avatar
-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 ...
Fajela Tajkiya's user avatar
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 ...
David Rogers's user avatar
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....
user avatar
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 ...
user avatar
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 ...
Stephen Graham's user avatar
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 ...
Uri Shapira's user avatar
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 ...
infocyde's user avatar
  • 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 ...
ahmed's user avatar
  • 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 ...
mac's user avatar
  • 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 ...
user avatar
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 ...
xmlapi's user avatar
  • 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 ...
Emma's user avatar
  • 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 ...
Rick Patel's user avatar
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, ...
David Krider's user avatar
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 ...
runholen's user avatar
  • 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 '...
ARV's user avatar
  • 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 ...
AndyD273's user avatar
  • 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 ...
Henrik Lindberg's user avatar
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] ...
Francesco Mantovani's user avatar
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 ...
Tony's user avatar
  • 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" ...
Brain2000's user avatar
  • 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 ...
chrisdot's user avatar
  • 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 ...
John Stud's user avatar
  • 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> ...
Dustine Tolete's user avatar
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 ...
Bobogator's user avatar
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 ...
user avatar
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-...
Francesco Mantovani's user avatar
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 ...
G82PPY's user avatar
  • 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 ...
Sajit Gangadharan's user avatar

1
2 3 4 5
7