Questions tagged [azure]
The azure tag has no usage guidance.
272
questions
0
votes
1answer
28 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
1answer
43 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 ...
0
votes
0answers
9 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
0answers
12 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 ...
0
votes
0answers
25 views
Azure SQL Server DTU Percentage degrades over time with API Throttling
I've been facing a weird DB behavior when trying to post records to my api. I have a function that throttles requests at a request rate of 10-15 req/s, each request results in a lookup and an insert (...
1
vote
0answers
18 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 ...
0
votes
1answer
5 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 ...
1
vote
1answer
11 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 ...
1
vote
1answer
58 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 ...
1
vote
1answer
42 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
0answers
45 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 ...
0
votes
0answers
19 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 ...
0
votes
0answers
8 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 ...
2
votes
0answers
44 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 (...
0
votes
1answer
34 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 ...
1
vote
0answers
16 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 ...
0
votes
1answer
16 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 ...
0
votes
2answers
70 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 ...
-1
votes
1answer
57 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
vote
0answers
444 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). ...
0
votes
1answer
85 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 ...
0
votes
0answers
46 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 ...
2
votes
1answer
60 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?
2
votes
1answer
184 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 ...
0
votes
1answer
21 views
Tables with the same name in the same DB (very strange bug)
Have you ever seen something similar to this (picture)?
A table appears multiple times!!
I don't know exactly how this began.
Whenever I make a change (alter) to a table, a new instance appears
I've ...
0
votes
2answers
30 views
How do I update azure SQL baseline to remove certain db owners?
I need to update the baseline to reflect only the approved list of owners and remove others.
Can anyone tell me how do I do that?
Here is what I see:
How do I remove the owners from baseline marked ...
0
votes
1answer
79 views
Why Azure site recovery may not meet RPO?
While Azure Site Recovery may meet RTO, it may not meet RPO since it
is not accounting for where data is inside SQL Server.
I am looking for an example for what it means by "is not accounting ...
0
votes
0answers
10 views
How can I customize vertices in Azure CosmosDB?
I'm currently working with CosmosDB and I want to personalize my vertices. In the Data Explorer there a menu in the upper toolbar called 'Style'. The uppermost dropdown called 'Show vertex (node) as' ...
0
votes
1answer
104 views
Memory Optimized Azure Postgres
I am trying to make sense of the "memory optimized" setting for Azure Database for PostgreSQL. Main memory data management can be viewed as quite different from secondary storage data ...
0
votes
0answers
48 views
Azure Data Factory pipeline accessing MariaDB
I have MariaDB running in a virtual machine in Azure. I need to move data from a file (in Azure storage) to a table in MariaDB using Azure Data Factory (ADF).
There's no connector in ADF to write to ...
1
vote
2answers
264 views
Maintenance Plan folder missing in SQL Managed Instance (via VM)
Accessing our new SQL Managed Instance via an Azure VM/SSMS, the Maintenance Plan folder is missing from the Object Explorer pane. Reading other posts (that all relate to other versions of SQL Server)...
0
votes
1answer
40 views
Is Azure Managed Disks enough to ensure high-durability for a database?
I want to set up a database in a high durability set-up on Azure. I've previously relied on DB-as-a-service offerings, but can't do that in this case, so I'd like your feedback on the plan below. Is ...
0
votes
1answer
48 views
sqlcmd is running but database shown no running query
We are facing this weird issue on our Azure setup. The database is SQLServer and client is CentOS.
We fire queries using sqlcmd. Sometimes it happens that you see the sqlcmd running, but there is no ...
0
votes
2answers
29 views
Azure SQL Elastic Pools - When to Create a new one versus upping the eDTU?
I've tried to Google looking for others with the same question for about an hour now and can't find anything close, so hoping someone here might be able to offer some insight!
I'm a many-hat admin ...
2
votes
1answer
98 views
Azure SQL Database - dedicated administrator connection (DAC)
If you check the setting in any of your Azure SQL databases, you will see that the value_in_use column value is zero for Remote admin connections. Meaning ‘Remote admin connections’ are not allowed ...
2
votes
1answer
185 views
How do I convert a TIMESTAMP to a BIGINT in Azure Synapse
What's the best way to convert a TIMESTAMP to a BIGINT In Azure Synapse. I tried this (which works) but seems clumsy. Is there a better, more concise and efficient way of doing the same thing?
SELECT ...
0
votes
0answers
13 views
SQL Azure VM Usecase for each backup type
It seems that within the Virtual Machine category in Azure the solutions for backups become increasingly complex when compared to the PaaS options.
What is the use case for each backup solution, and ...
0
votes
0answers
239 views
Error = [Microsoft][ODBC Driver 17 for SQL Server]Unable to open BCP host data-file
I have a table in my Azure SQL database named "tablex". I want to bulk insert the content of a csv file in that table (the csv file has the same columns as tablex in the Azure DB)
This is ...
0
votes
0answers
29 views
Automated flow of creating user in Azure AD to MySQL that runs in K8s cluster in Azure
My ASP.net core application runs on Azure K8s cluster, the app uses authentication that is configured in Azure (the app is registered in Azure AD and some accounts are created there to use it).
The ...
2
votes
2answers
340 views
How can I query on-premise SQL Server database from Azure SQL database using stored procedure?
I have a Azure SQL database and it has a stored procedure from where I am trying to join a table which resides in on-premise SQL server database.
Essentially, I am trying to query a table which sits ...
2
votes
1answer
171 views
Can't restore database with (apparently) same version
I'm trying to restore a SQL Server database instance in my local machine I've backed up from an Azure Cloud environment but I'm getting the following message:
System.Data.SqlClient.SqlError: The ...
-2
votes
1answer
76 views
Exception Message: Unable to connect to the remote server
I am trying to backup a database in azure storage and I keep getting the below messages
Msg 3271, Level 16, State 1, Line 1
A nonrecoverable I/O error occurred on file "azure storage backup ...
0
votes
1answer
123 views
Issues deploying SSIS package to SQL Server in Azure AD Domain Services (AADDS) environment
We use Azure Active Directory (Azure AD) in my organisation, and we recently deployed Azure AD Domain Services AADDS) to handle a SQL Server 2019 we use internally.
My Azure AD domain is (fictitiously)...
2
votes
0answers
150 views
Confounding NUMA configuration in SQL Server for 24 vcore system in Azure
I need some help understanding how SQL Server takes a 24 core VM and displays it as 11 NUMA nodes under properties.
At startup, this is the key message about hardware SQL Server found:
SQL Server ...
0
votes
0answers
43 views
azure mysql database replication with on-prem mysql master is failing with 2003 error
I have setup azure mysql master database and I would like to do data-in replication with an on-prem mysql database but the replication is failing. Can someone tell me the reason ?
I am able to connect ...
0
votes
2answers
52 views
Vertical Elastic Query is not identifying Object
I did create an External Datasource, identical to the guide described here https://www.sqlservercentral.com/articles/cross-database-queries-in-azure-sql-database .The process is pretty simple, so just ...
-1
votes
1answer
42 views
sqlserver on linux Azure performance [duplicate]
Im new to sqlserver, we have a sqlserver running on linux and we are encountering performance issues
i see sometimes SUSPENDED on the queries / selects etc
If i change the max degree of parallelism ...
1
vote
3answers
81 views
I have a bunch of SQL databases. How should I put these into Azure? [closed]
I have a bunch of on-premise SQL databases that contain data related to HR. One database could be pure employee data, such as staff records, leaver records or recruitment records. Another database ...
1
vote
0answers
53 views
Deploying MariaDB Columnstore Docker image in Azure
I deployed the MariaDB Columnstore Docker container in Windows with the following command:
docker container run --name cont_mariadb -e MYSQL_ROOT_PASSWORD=xxxxxxx
-p 3306:3306 -v ...
0
votes
1answer
199 views
Bulk SQL INSERT into Azure SQL Database using spark causes blocking/contention?
I am running the following code using microsoft's sql sparkconnector to write a 1-2 Billion dataframe into Azure SQL Database.
df.write \
.format("com.microsoft.sqlserver.jdbc.spark") \
....