Questions tagged [azure]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
29 views

In ADF, are copy data activities wrapped in transactions?

I have a copy data activity that is moving data from a managed instance to a sql database. The flow of the process is: truncate a staging table on the sql database as a distinct activity call a ...
user avatar
  • 101
-1 votes
0 answers
11 views

Data replication from prod to read replicate in Azure SQL MI

I am in middle of finalizing database for our company. Though I have gone through multiple readings but there are couple of questions which i am still confused at. We are planning to go ahead with ...
user avatar
  • 99
-2 votes
1 answer
43 views

What are the features that Azure VM based SQL server supports and the managed instance doesn't support?

I'm deciding on whether to install SQL server on azure VM versus configuring a managed instance. I understand that the following features are not supported by managed instance: SSIS SSAS SSRS Manual ...
user avatar
  • 2,076
0 votes
0 answers
17 views

Azure Key Vault Backup/Restore Across Subscriptions

I have 2 Azure SQL Managed Instances, each on a separate subscription. I am trying to see if I can take an Azure Key Vault Key used for TDE in one subscription and back it up to then restore to a Key ...
user avatar
0 votes
1 answer
102 views

Azure SQL - Hyperscale service tier - are table partitions supported

In the Azure SQL DB, running in the Hyperscale service tier, are table level partitions supported? It does not seem to be called out in the known limitations page. While trying to create a filegroup ...
user avatar
2 votes
0 answers
42 views

How to create logins in sql server based on the Azure Active Directory?

In my Azure environment I have many resources, and I have a virtual machine that contains my sql server database This is my virtual machine: What I would like to achieve is to create logins inside my ...
user avatar
0 votes
1 answer
57 views

Reclaim unused allocated space in Azure Elastic pool data storage (sql)

In Azure I have SQL Database elastic pool on a DTU based purchasing model (Standard). In the Pool I have 7 SQL databases These are my storage stats: Used Space 50GB Allocated Space 105GB Maximum ...
user avatar
0 votes
0 answers
12 views

MySQL Data encryption - Azure portal setting not working

I am having a Azure - MySQL database, which we created with Basic configuration. Later client ask to have a Data encryption policy in place. Azure not support data encryption policy for the Basic ...
user avatar
-1 votes
1 answer
86 views

ola hallengren on Azure SQL

I'm new to the use of the Ola Hallengren optimize index scripts on Azure SQL, but with out of the box settings I notice that some indices with 80-90% defrag % en > 80.000 page counts are simply ...
user avatar
0 votes
1 answer
57 views

SqlPackage Import - How to chose vCore purchase model?

I read the following documentation. Properties specific to the Import action Looking at the switch description for DatabaseEdition, I do not see a choice for vCore Azure SQL Database purchase model. ...
user avatar
  • 12.2k
3 votes
1 answer
310 views

Azure postgresql really slow compared to VM

I work with postgresql (and Postgis) for years now on a VM with dockers, and I start to be used to tweak servers parameters and optimize request, and I never had the kind of problems I have with Azure ...
user avatar
0 votes
1 answer
39 views

understanding Azure Sql Databse Billed VCores

trying to migrate from sql server on-prem to azure sql database and i cant understand Duration and CPU Used and Memory Used of Billed vCores
user avatar
0 votes
0 answers
247 views

How to connect to SQL managed instance on private endpoint on different VNET

I can't connect to SQL managed instance from Azure VM in different VNET. VM network VNET address space:10.0.0.0/16 VM subnet: 10.0.1.0/24 SQL instance VNET address space:10.0.0.0/16 SQL instance ...
user avatar
0 votes
0 answers
47 views

When querying a SQL Server using Invoke-Sqlcmd, the first attempt fails, and subsequent attempts fail as well until some time has passed. Why?

I am invoking a Sqlcmd to query a SQL Server in Azure. The first several requests fail, and then after waiting about 30 seconds the same command will work. Is this an issue with the database needing ...
user avatar
3 votes
0 answers
80 views

Azure SQL Managed Instance - Reboots - places to look?

We have been seeing what appears to be reboots on our SQL Managed Instances (Standard, Failover Group). One node (the current primary, USEast) has been apparently rebooting for the last 24 hours, ...
user avatar
1 vote
1 answer
47 views

Azure SQL Managed Backup

I have a SQL 2017 on-prem database server that the client wants to back up to Azure storage directly; instead of using local storage. The largest database backup is 4-5TB. I read the MS documentation ...
user avatar
  • 11
2 votes
1 answer
80 views

What is the correct configuration for the SQL Server listener with 2 nodes on-prem and 1 node in Azure?

I am setting up a 3-node Availability Group with 2 nodes on-premises and the 3rd on a VM in Azure. All nodes are SQL Server 2019 Enterprise with CU14. The Availability Group is fine and the listener ...
user avatar
0 votes
1 answer
172 views

Row-Level Security with Azure AD Groups on Azure SQL Managed Instance

I have an Azure SQL Managed Instance on which I need to implement Row-Level Security on some tables to filter the data queried by some users. All my users authenticate with Azure Active Directory ...
user avatar
1 vote
1 answer
547 views

How to call python file in repo in databricks from data factory outside DBFS?

In Azure Databricks I have I have a repo cloned which contains python files, not notebooks. In Azure Data Factory I want to configure a step to run a Databricks Python file. However when I enter the /...
user avatar
0 votes
1 answer
84 views

How to diagnose connection limits in Azure Database for PostgreSQL

Today, we had some issues with applications not being able to connect an Azure Database for PostgreSQL instance. The error was: 53300: remaining connection slots are reserved for non-replication ...
user avatar
  • 21
0 votes
0 answers
43 views

how to manage concurrency in Microsoft azure dedicated SQL pool?

system configuration- user count- 1200 Data warehouse Units- 1000dWU current maximum concurrency- 128 resource class used most- staticrc20(90%) , staticrc30(8%), smallrc(2%) DB size- 500 TB Problem ...
user avatar
0 votes
1 answer
35 views

Does Azure MySQL 8 service with region HA support XA transactions?

I need to configure a MySQL cluster in Azure with region HA that supports XA transactions. MySQL does not support XA transactions when replication is in place for our current setup with Percona XTradb ...
user avatar
1 vote
1 answer
71 views

Is there a way to migrate data from one server to another after running SQL Server Database Deploy in Azure DevOps?

Is there a way to automate the task of copying all the data from a database on one server to an identical database on another server using Azure DevOps? All our web application and desktop application ...
user avatar
  • 111
1 vote
0 answers
74 views

Enable SQL Server managed backup to Azure

I was trying to Enable SQL Server managed Backup to Azure. Using SAS token to create the Credentials in SQL. CREATE CREDENTIAL [Container_name] WITH IDENTITY = 'Shared Access Signature', SECRET = ...
user avatar
0 votes
0 answers
39 views

Alter an existing partition in a table

The table definition of existing table is: CREATE TABLE [TEST].[TEST1] ( [ProductId] [nvarchar](256) NULL, [Date] [date] NULL, ) WITH ( DISTRIBUTION = HASH ( [ProductId] ), CLUSTERED ...
user avatar
0 votes
1 answer
24 views

Azure blob storage - Access tier change

We currently have a legacy blob storage account of 600TB configured as Standard\Hot tier which has archived backups. As part of cost optimization, we want to change the access tier to Cool on the blob ...
user avatar
  • 99
0 votes
0 answers
108 views

Validation error while trying to migrate on-prem SQL Database to Azure SQL managed instance using Azure DMS

I have successfully created Azure Database Migration Project under Azure Database Migration Service during the last phase of the project I am getting validation error No valid full backup found for ...
user avatar
0 votes
1 answer
59 views

On-premises SQL to Azure SQL MI Migration

We have a requirement to migrate around 800 GB of data from on-premises SQL Server (2012 and 2017) spread across multiple databases to Azure SQL MI. We have run the DMA on the source data and have got ...
user avatar
0 votes
1 answer
90 views

Can I try SQL Server BIG Data Cluster for free?

I can not find information about test SQL Server Big Data Cluster in a development environment. We have some AKSes and would like to try installing SQL Server Big Data Cluster. Is it possible to do it ...
user avatar
  • 45
0 votes
0 answers
11 views

azure cli - Metrics (hostname, CPU, sockets..) for server with DB2 instances

for license purposes I need a table / list with Metrics like hostname, OS, CPU, sockets, cores ..) for virtual or dedicated azure server with DB2 instances. I started with the cli az vm list -d ...
user avatar
0 votes
0 answers
29 views

Azure data factory - ON CONFLICT DO NOTHING

I am building a data pipeline with Azure data factory with source from Azure storage account where the data is in json files and sink as a postgresql database. My json files will contain data that ...
user avatar
1 vote
0 answers
20 views

Azure VM SQL Server Automated Backup doing log backups only

We have an Azure VM running our own copy of SQL Server 2019, and we have just configured the Automated Backup functionality. I have it configured like this: Everything seems to be fine, except for ...
user avatar
0 votes
1 answer
24 views

Save changes of records of products in Azure DB in way that we can see historical data

I am curious about "best" model for my purpose of storage of data (include historical changes) in Azure DB that I will be able to see timeline of that changes. Example: We have some company ...
user avatar
1 vote
1 answer
16 views

Does Azure Mariadb/Mysql data-in replication support certificate chains?

I would like to migrate from AWS RDS Mysql to Azure Mariadb managed database. For this purpose, I would set up data-in replication using TLS, roughly following the provided guide. AWS provides ...
user avatar
  • 111
1 vote
1 answer
181 views

TimescaleDB on Azure Postgres error when creating continuous aggregation

I am getting the following error SQL Error [0A000]: ERROR: functionality not supported under the current license "ApacheOnly", license¶ Hint: Upgrade to a Timescale-licensed binary to ...
user avatar
1 vote
1 answer
79 views

Alternatives to AzureSQL temporal tables

I have recently been learning about temporal tables in AzureSQL and am considering implementing this into my codebase. However, columnstore indexes are only available for Azure SQL databases of tier ...
user avatar
2 votes
0 answers
147 views

Troubleshoting slow running queries/jobs in Azure Databricks

I have Azure Databricks workspace with cluster configured to run Standard 6.4 runtime (Apache Spark 2.4.5, Scala 2.11). Cluster uses shared metastore (Azure MySQL). I'm trying to figure out possible ...
user avatar
  • 707
0 votes
0 answers
45 views

Azure SQL MI Alert setup

-- Azure SQL MI Alert setup -- We can setup alerts for our on-premise SQL instance according to https://www.brentozar.com/blitz/configure-sql-server-alerts/ -- In this document from Brent Ozar, it ...
user avatar
0 votes
0 answers
15 views

Using Google Sheets to show Azure Analysis Services data

We normally show data from Analysis Services and Tabulars in Excel. I have been doing this for years. However, I am currently in a situation where the spreadsheet of choice is Google Sheets, and the ...
user avatar
  • 325
2 votes
0 answers
66 views

Exactly-once FIFO queue in Synapse

Creating a queue table in SQL Server is a much-studied problem. However, I would like to implement one in Azure Synapse where many of the building blocks do not exists. Specifically no table hints (...
user avatar
0 votes
1 answer
48 views

How do you make structural changes to Azure SQL Server DBs when you don't have access via SSMS?

We're no longer allowed to have access to UAT/PROD environments via SSMS at my organization. The way our deployment process works is tied to git pushes. So when you push to the DEV branch, the DEV web ...
user avatar
  • 103
1 vote
0 answers
20 views

"Friendly" role name since Azure PostgreSQL connection via AD security group role requires the AD group name as the username@pgservername?

With PostgreSQL's use of the rolename@pgservername and AD auth requiring the security group name as the role name, any user connecting via AD must know their AD security group name. I'd like to user ...
user avatar
0 votes
1 answer
58 views

Azure PostgreSQL Active Directory Admin - works as my AD user but not as an AD group I'm in

I have an Azure PostgreSQL server that is giving different connection results in Azure Data Studio (with the PG extension) depending on how the resource's AD Admin setting is configured. With the AD ...
user avatar
0 votes
2 answers
106 views

Database corruption on VM shutdown

We moved a SQL Server database to a virtual machine in Azure. Since the database only contains historical data and does not have transactions anymore we want to turn off and turn on the VM on a ...
user avatar
-1 votes
1 answer
65 views

Performance monitoring [closed]

I need to get the performance metrics like CPU usage in sql server using sql query and store it in a history table , where I will keep on adding the old records . And a current table to maintain the ...
user avatar
  • 1
1 vote
0 answers
1k views

SQL connection error in python webapp: "pandas.io.sql.DatabaseError: Execution failed on sql"

I have built a Webapp with python flask, that reads and writes to SQL tables. Typically in the morning, I receive an error regarding SQL query execution that looks like this (see logs snippet below). ...
user avatar
  • 11
0 votes
1 answer
210 views

Azure Read Replica in Elastic pool performance

We have a Azure Database with a read replica. However the read replica seems to be effected by the load of the primary database. The primary database is in an elastic pool. Does the read replica make ...
user avatar
  • 101
0 votes
0 answers
51 views

Super complex Schema will not migrate to PaaS

Using a Dedicated 2016 datacentre SQL Server 2 vcpus, 14 GiB memory for testing. We have currently found a migration issue with the database Migration SQL 2016 to Azure PaaS. The transfer of schema ...
user avatar
2 votes
1 answer
96 views

How are tasks assigned to ForEach iterations

The Lookup-ForEach pattern is common in Azure Data Factory (ADF). How are items produced by the Lookup allocated to the ForEach's workers, the number of which is controlled by Batch Count?
user avatar
2 votes
1 answer
377 views

Error while querying 'Always encrypted' column

I have set up 'Always encrypted' on one of the column in Azure SQL DB. Everything worked well except when a user is trying to access he is getting below error. ' I have tried some of the rememdies as ...
user avatar

1
2 3 4 5 6