Questions tagged [azure]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
25 views

SQL User vs AAD for Azure SQL Managed instance

It appears the app response is much slower when it uses the AAD account to access the Managed instance compared to using a SQL user (SQL Auth). Can anyone please shed some light on whether this is ...
0
votes
0answers
22 views

Read performance of SQL Server data files data from Azure BLOB

I have a setup where there is SQL Server on premises (MS SQL Server 2016 13.0.5366.0) but database files (log and data) are stored in cloud storage account. Setup described here. The interesting ...
0
votes
0answers
8 views

Azure ARM template SQL backup deployment intermediate failure

I am having an intermittent error when trying to deploy a backup solution during provisioning. The error I get sometimes is: Deployment failed. Correlation ID: bb100978-3c7b-46f4-bcca-8b9abb490a98. {...
0
votes
0answers
18 views

Azure VM Security

With the move to Azure Cloud things are moving fast! I have a question based on Azure VM with a shared SQL Server containing multiple instances. For example if a Azure VM has 5 instances on there ...
0
votes
0answers
28 views

Restoring database created with Ola's tools from Azure blob

I'm exploring using Ola Hallengren's excellent backup tools to backup to an azure blob. Is there a simple way to do a restore of the latest backups on a fresh MSSQL 2017 database directly from azure ...
1
vote
1answer
27 views

Setting up sp_AllNightLog using Azure Blob Storage [closed]

Has anyone setup Brent Ozar's sp_AllNightLog using Azure Blob Storage? Trying to start incorporating both but not sure of the steps or how to get started. Any tips or links to similar operations?
0
votes
1answer
38 views

TRY .. CATCH sometimes fails to catch PRIMARY KEY VIOLATION

I wrote code to upsert records to the database. The database is Azure DB, S4 tier. Updates and inserts are sometimes are highly concurrent since it's coming from the application that doing too many ...
0
votes
1answer
25 views

Load data from a temporal table to another temporal table in Azure

Currently we have only a Live Database where all our data resides. I have created a separate Azure server and DB for development. The DEV DB should be some what up to date with the Live DB for ...
2
votes
1answer
35 views

Recommendation on changing Azure SQL Database tier weekly [closed]

We have an Azure SQL Database of size 50GB in the S6 tier. On weekends, the usage is very minimal. Is it okay to change the tier to S0 every weekend for cost savings, and change back to S6 on Monday? ...
0
votes
0answers
16 views

Importing dbatools module into Azure Automation Account

Has anyone managed to import dbatools module into Azure Automation Account? I tried to do it in several ways, but every time the installation fails: different versions checked from 0.9.* to the ...
1
vote
1answer
27 views

Transactional replication of Date column from Sql Server 2012 SP4 to Azure Sql Database

We have a Sql Server 2012 SP4 where we are trying to setup transactional replication to Azure Sql Database. When starting replication is says Column mycolumn in object mytable contains type Date, ...
0
votes
0answers
11 views

Azure Managed Instance MSOLAP OLE DB connector

We have a managed Azure SQL instance, and trying to leverage it for some Azure AS documentation. Managed Azure supports OPENROWSET which was going to be used to access DMVs in the SSAS tabular model, ...
0
votes
2answers
30 views

Auto scaling MongoDB as a service in Microsoft Azure

I see a MongoDB service in Microsoft Azure but that deploys a VM and installs MongoDB in that. I am guessing this will not auto scale and also charge me for the entire VM and MongoDB management (not ...
1
vote
0answers
47 views

SQL Server Database auditing not working

I'm setting up auditing on a SQL Server Managed Instance in Azure (Version = Microsoft SQL Azure (RTM) - 12.0.2000.8). Following the instructions in the link, everything worked for server-level ...
0
votes
0answers
9 views

Azure Storage Account access

What is the difference between SAS token and access keys (internally)? Which is the better way of accessing the storage? SAS keys do have expiration so admins do have control for how long it will ...
0
votes
0answers
9 views

Enabling Advanced Data Security (ADS) on Azure

Can somebody please let me know if ADS is turned on, would it have any negative effect on Azure SQL database performance?
0
votes
0answers
10 views

MABS - Synchronization frequency for New Protection Group is not showing up for a user database

I am trying to create a user database policy that does incremental 15 min log backup, however when I get to "Specify Short-Term Goals" in the "Create New Protection Group" wizard, the "Synchronization ...
0
votes
0answers
18 views

SSMA Migration data failed from Oracle to Azure Database

I'm having an issue with the migration between an Oracle database and an Azure Database using SSMA v7.10.0. I can connect, convert the schema and synchronize with the Azure database with no problem. ...
0
votes
0answers
22 views

Azure Database Encryption (ERROR ON WEB APP)

Currently I have an azure subscription which has a server and database. I already encrypt a column in a table. i am using "always encrypted" method. Now I want to generate a .pfx file after I ...
0
votes
0answers
16 views

Postgres INSERT slows down over time until server is restarted

I have a Rails app backed by an Azure-managed Postgres database and I use NewRelic for monitoring. What I've noticed is that the INSERT performance degrades almost linearly over time - what started ...
0
votes
0answers
5 views

Changing of Azure domain to another location

I would like to ask few items on transferring our azure domain. Below are the items for confirmation. Steps on how to transfer domain? What is the risk in transferring our domain? What will be the ...
0
votes
0answers
20 views

Azure sql database backup and exporting data-tier application

Currently i have an azure subscription in it has a server and a database. How could i setup azure SQL database backups that will run automatically for example every 15 mins? is there a way? if yes ...
1
vote
0answers
10 views

SQL Server 2016 query Azure AD

I need to query our (Azure) AD to get a user username based on on an email address I am being passed and then write it to a table ideally via an SP. From my brief bit of reading, Azure AD supports ...
2
votes
1answer
26 views

SQL Azure “hot” table query slowdown over time

I have an Azure SQL Database table that is acting as a "prioritized queue". As such, it gets heavily written to and deleted from over time. What's happening is that after a week or two, the DB size ...
0
votes
0answers
13 views

How to use sendgrid smtp in azure DB

When I tried to configure DBMail using SendGrid SMTP, the below error occurs: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2019-...
0
votes
0answers
20 views

Azure SQL Database encryption

Currently i have an azure subscription in it has a server and a database. How could i encrypt an SQL azure table and when the encryption is done i can still insert some data on the table? I already ...
0
votes
0answers
22 views

Database Administrator

If I want to be the only person/department in my organization that can create and administer databases in Azure. What privileges do I need have and make sure no one else has? I will need to give ...
0
votes
0answers
23 views

How to use the Percona Toolkit to connect to Azure Database for MySQL when SSL is enabled

I am attempting to use the pt-show-grants to connected to a MySQL instance with SSL enabled. $ pt-show-grants --version pt-show-grants 3.0.9 If I attempt to connect to my database without any ...
0
votes
1answer
17 views

Access control on Azure SQL Data warehouse

Access Control setup on Tables inside dbo schema. We are Denying select permission on some tables inside dbo schema as these tables have some critical data. Issue: Even when Select query fails on ...
3
votes
1answer
194 views

How to handle failed Index Optimization (Ola Hallengren) step in SQL Azure Elastic Job Agent?

I have created a SQL maintenance job using Azure Elastic Job Agent with the following step: EXEC jobs.sp_add_jobstep @job_name = @jobName, @step_name = 'Optimize indexes and statistics', @command=N' ...
0
votes
1answer
110 views

Ola Hallengren for Managed instance

How can we configure Ola Hallengren's solution on a managed instance? (We want output file for each run, storing it is an issue) If we want backup retention longer than 35 days for the database in ...
2
votes
1answer
48 views

Only 'master' inside the system databases in Azure Managed instance

During our POC we saw the system databases(model,msdb and tempdb) lying outside the system databases group. Any specific reason behind it?
0
votes
0answers
35 views

Any way to get a key stored in the Azure Key Vault when retrieving Always Encrypted data through SSRS?

If you are using Always Encrypted and the key is stored in the Azure key vault, is there any way to use on-prem SSRS to view the encrypted data? Obviously with the client application this can be coded....
2
votes
1answer
191 views

what is the maximum capacity allowed for SQL managed Instance?

I am looking in option to migrate to SQL Managed Instance but found on MSDN that it supports max of 8 TB in General tier and 4 TB Business critical. what are option for databases greater than 8 TB? ...
0
votes
0answers
52 views

Azure MariaDB log_bin_trust_function_creators

I'm testing AzureDB for MariaDB and for my DB to work properly I must change log_bin_trust_function_creators variabl. However, it isn't available in Azure Portal Server Parameters. I've checked and ...
0
votes
1answer
41 views

Ephemeral disk on Azure LS series

I am little confused about the ephemeral disk on LS series Azure VM.I want to suggest L32s_v2 series vm for a customer due to high iops and throughput that the nvme disks provide but there is a catch....
0
votes
0answers
23 views

Move from SSIS to Azure

I have an ETL solution which we have been doing in conventional SSIS. The job of SSIS is just to create star schema from the application database to dimension and fact tables. There is very little ...
1
vote
2answers
929 views

A transport-level error has occurred when receiving results from the server. Error 10054

I have been using SQL Server & Azure for almost two years with Zero problems. Now for some reason I am getting the following error when I try to connect to my Azure database from SSMS. I have ...
1
vote
2answers
109 views

How to import Azure blob file into Sql Server 2008

Is there a way to import Blob files into sql server 2008 other than using CLR ? The file size is around 300MB so CLR isn't efficient enough. Is there a possibility to use BULK INSERT or OPENROWSET in ...
0
votes
1answer
49 views

Transaction Replication on Azure MI servers

I'm struggling to verify whether an Azure Managed Instance of SQL Server can both subscribe to Transactional Replication, and Publish, at the same time - I've been googling like a demon and ...
1
vote
1answer
20 views

Azure DBaaS storage

Does Azure Database for PostgreSQL has its storage auto-expandable? Say, we have allocated 100G of space for the DB instance. Would it expand on its own. Where can we see the server log storage ...
0
votes
0answers
91 views

Mysql performance lagging in Azure VM

I've been having a big mysql performance problem for a while now after a migration from a dedicated server to a cloud VM. The issue ultimately requires production load to test, so it has been ...
0
votes
0answers
21 views

Disk recovery for Azure VM to host SQL Server

As per the Azure VM Creation of the storage pool best practice document, Simple Recovery option is what Microsoft recommend. For recovery purpose shouldn't this be at least Mirror. What is ...
0
votes
2answers
452 views

Azure sql database grant select on certain tables

I have created a user in a Azure sql database in SSMS. Now trying to give select permission to certain tables in a db to this user. The security control options seems quite different than on premise ...
1
vote
1answer
298 views

“Keyword not supported: Server” error when using ADO.NET connection string to connect to Azure DB

I have an ASP.Net project that I am running. I have added a database to Azure, and Azure generated a connection string for the database. When running the application I however get an error stating ...
0
votes
0answers
254 views

How to increase the max_locks_per_transaction value for a PostgreSQL instance on Azure?

I am receiving this error, but the max_locks_per_transaction setting is not an option in Azure. Reason: SQL Error [53200]: ERROR: out of shared memory Hint: You might need to increase ...
0
votes
1answer
33 views

What type of data ingestion does Azure Data Factory use?

This article data-ingestion says that there are two types of data ingestion Data can be streamed in real time or ingested in batches. What type of data ingestion does Azure Data Factory's ...
1
vote
0answers
35 views

Azure Database for PostgreSQL and Event Triggers

I am using Microsoft Azure Database for PostgreSQL with PostgreSQL 10 installed. As I'm trying to work on future tables together with other users I want to enable the other users to alter my tables as ...
0
votes
1answer
38 views

Azure automatic fail-over vs always on availability groups clarification

I am trying to understand automatic failover vs always on availability groups in Azure hybrid and geo-region situations: Is it possible to have on-premises SQL databases, VM SQL databases and Azure ...
1
vote
1answer
283 views

How to change owner of a table within a PostgreSQL Database on Azure?

I attempting to restore a database into a PostgreSQL instance on Azure. I am issuing these statements as postgres and attempting to change owner to another role that was a superuser. My restore ...