Questions tagged [azure]
The azure tag has no usage guidance.
141
questions
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 ...
