Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [azure]

The tag has no usage guidance.

1
vote
0answers
8 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
24 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
9 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
13 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
21 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
15 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
12 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
114 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
70 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
39 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
27 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
86 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
41 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
29 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
21 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
581 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
61 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
29 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
42 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
184 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
171 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
171 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
26 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
27 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
36 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
119 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 ...
0
votes
1answer
58 views

How to Backup to Azure Storage?

A day before I tried to back up our ddbb log file to azure storage. So, the transact is simple backup [log|database] <name> To URL = <Azure_Storage_url> Credentials are defined apart, ...
1
vote
2answers
195 views

How to Disable Windows Authentication in SQL Server

I would like to say that as per my Organization requirement they want to Disable Windows Authentication in SQL Server. My Environment is as follows:- 1) Microsoft Azure 2) Windows Server 2016 3) ...
0
votes
0answers
36 views

Mongodb default setup on Azure - default connect string from local shell

I have a new Azure VM (Ubuntu 18.04.1 LTS) which has docker. dragam@USDockerVM:~$ IRE> docker --version Docker version 18.09.0, build 4d60db4 Issued the command docker pull mongo this ran ...
5
votes
1answer
327 views

Service Principal as SQL Active Directory Admin, does it use Graph API?

I'm looking to use a service principal as the server admin, so it can be used in a release pipeline to create further active directory users. I'm successfully able to make the service principal the ...
4
votes
1answer
78 views

Why is my database restore being aborted?

I'm trying to restore a SQL Server 2016 database into a SQL Server 2017 docker instance (microsoft/mssql-server-linux:latest). The process seems to be: Create docker container: docker run -e ‘...
2
votes
0answers
180 views

Should Azure host write-caching be enabled when using MongoDB's WiredTiger storage engine

I have several virtual machines on Azure running a mongoDB replicaSet with the WiredTiger storage engine. I'm not sure about the proper host caching option to set on the disks that contain the MongoDB ...
1
vote
2answers
95 views

Azure SQL Database finding latest available restore point

From reading books online it is clear that there are two types of retention for Azure SQL Database. Backups for point-in-time restore Backups for long-term retention When it comes to restore there ...
1
vote
0answers
24 views

Online migration using Database Migration Services

I wanted to test online migration to azure sql db using azure database migration services. I am following the below link. https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-...
0
votes
1answer
57 views

Availability groups

I'm trying to learn and implement availability groups clustering in Azure. How secondary replica knows that the primary replica is down? In FCI, heartbeat links are there right? like that what we have ...
2
votes
1answer
23 views

Azure server names vs Azure database names

Let's say I have one Azure subscription and 2 Azure instances: Dev-instance.database.windows.net for developer testing, and Prod-instance.windows.net for production work. I want to create a new ...
0
votes
1answer
307 views

Can't overwrite an existing Azure SQL Managed Instance database during restore

We're working on migrating some SQL Server VMs to Azure SQL Managed Instances. We did an initial backup/restore without a problem: RESTORE DATABASE [xxx] FROM URL = 'https://<account-name>...
4
votes
1answer
2k views

Azure SQL DB vs Azure managed instance [closed]

We are in the early stages of planning to move some of our on-premise database to cloud and wanted to go the PaaS way. I understand that managed instance is in preview. From what I have read, ...
1
vote
2answers
186 views

Running remote stored procedure with DDL locally

Sorry if my question is redundant, I searched Stack Exchange and the internet for hours but do not have a definitive answer to my question. Database: SQL Server 2017 + Azure The goal is to build a ...
1
vote
1answer
314 views

Azure SQL Server External Data Sources

Let me preface this what what I'd like to accomplish and see if this is inline with the expectation of using Azure SQL DB. Currently I use a couple Virtual Machines in Azure that use a linked server ...
1
vote
2answers
230 views

Not able to Create Database or Restore Database on the Azure SQL Managed Instance

I am trying to restore database on the Azure SQL Managed Instance using Azure blob container URL. Reference CREATE CREDENTIAL [https://zzdevbackup.blob.core.windows.net/dbbackup] WITH IDENTITY = '...
1
vote
1answer
55 views

Any Reason to have AlwaysOn Failover Clustering in Azure Cloud?

Is there a reason to have AlwaysOn Failover Clustering when a database is in Azure Cloud? I understand the benefits having AlwaysOn Availability Groups in Azure Cloud for Database-Level protection. ...
0
votes
0answers
10 views

Data storage for the CosmosDB SQL and MongoDB types?

I've been researching CosmosDB as a possible db technology - specifically the SQL and MongoDB APIs. I created a sample database for both and it seemed like data was stored the same for both - ...
1
vote
0answers
77 views

Designing a globally distributed database

We are trying to design a globally distributed Azure Cosmos DB and we’re not sure how to best do that: There is data that should be replicated in every region to improve read performance. This data ...
4
votes
1answer
504 views

How can I clear buffer for a SQL Server DB Hosted On Azure?

I am trying to fine tune my queries and Stored Procedures. The Issue that I am facing is that there is no way to clear the Database buffers in Azure. Which means that I cannot use DBCC ...
0
votes
1answer
220 views

How to copy data from Azure SQL DB into Azure SQL DW

I need to copy some data from an azure SQl DB instance into my azure data warehouse. The most obvious way to do this is to use Elastic Query, similar to the below: CREATE EXTERNAL DATA SOURCE SqlDb ...
0
votes
0answers
49 views

Unable to configure Alerts on Metrics for Azure SQL DB

I am trying to configure Alerts(not classic alerts) on Metrics for an Azure SQL DB. I have navigated to the "Create rule" blade under Monitor The problem is when I select a SQL database target the ...
1
vote
1answer
1k views

Parameter value in Data Factory Triggered pipeline

I have a pipeline configured in azure data factory which basically does create a backup file (JSON) from a cosmosDB dataset and it's saved in a blob storage, my problem comes when I want to schedule ...