Questions tagged [azure]
The azure tag has no usage guidance.
290
questions
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 ...
- 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 ...
- 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 ...
- 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 ...
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 ...
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 ...
- 14.8k
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 ...
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 ...
- 111
-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 ...
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.
...
- 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 ...
- 131
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
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 ...
- 101
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 ...
user13696433
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, ...
- 7,491
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 ...
- 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 ...
- 23
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 ...
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 /...
- 251
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 ...
- 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 ...
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 ...
- 101
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 ...
- 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 = ...
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 ...
Sharad R. Telkar
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 ...
- 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 ...
- 1
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 ...
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 ...
- 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
...
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 ...
- 38
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 ...
- 11
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 ...
user3132499
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 ...
- 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 ...
- 113
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 ...
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 ...
- 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 ...
- 417
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 ...
- 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 (...
- 22.8k
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 ...
- 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 ...
- 41
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 ...
- 41
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 ...
- 153
-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 ...
- 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). ...
- 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 ...
- 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 ...
- 299
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?
- 22.8k
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 ...
- 21