Stack Exchange Network

Stack Exchange network consists of 174 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
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [azure]

The tag has no usage guidance.

0
votes
0answers
18 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
31 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
31 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
19 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
19 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
17 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
29 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
34 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
47 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
42 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
21 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 ...
1
vote
0answers
85 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
66 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
75 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 ...
0
votes
0answers
39 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
21 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
34 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
20 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
108 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>...
1
vote
1answer
557 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
56 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
107 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 ...
0
votes
1answer
110 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
51 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
21 views

Process to Archive off DB Backups in Azure Blob Storage

I'm looking for ideas on how to start on Archiving some of our SQL Server Database Backups that are on the Azure Blob Storage. It's getting to an unmanageable state. I'd like to drive this using ...
0
votes
0answers
9 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
31 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 ...
0
votes
0answers
7 views

Azure Site recovery with Site to Site VPN having DNS service

i wanted to understand how the Azure site recovery service will work with disaster recovery where the DR site is connected over a site-site VPN and the DNS Name is bound to one of the primary server. ...
0
votes
0answers
15 views

Perfmon like statistics from Azure with quotas

What is the easiest way to extract statistics from Azure SQL databases to on-prem for analysis and graphing, and to be able to accumulate history and do reporting across all Azure databases and ...
4
votes
1answer
447 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
100 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
40 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
540 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 ...
1
vote
0answers
28 views

Can I remove some of our disk allocation?

I've started work for a new company who are using Azure for their SQL Databases. As one of my first tasks, they've asked me if they have too much storage (expensive storage), and would like to remove ...
1
vote
0answers
69 views

Microsoft Azure - Azure Database for MySQL Server - Connection Security & Server Parameters not showing in Azure Portal and Azure CLI [closed]

I deployed one Memory Optimized instance with 2vCores CPU, 600GB Premium SSD and it is locally redundant. I restored almost 250GB of SQL dumps into the new instance. I noticed halfway through, the ...
2
votes
0answers
40 views

Enable compression for SQL Server Managed Backup to Microsoft Azure

I am using SQL Server Managed Backup to Microsoft Azure for multiple databases on my SQL Server 2017. I am trying to figure out how to enable compression on some of the databases. It seems from this ...
2
votes
2answers
229 views

How to Limit DTU Percentage Consumption for a Given Session in Azure SQL Database?

We have an Azure SQL Database tier S4 (200 DTU), and there is one big table inside When I run a "alter index rebuild..." statement, it takes about 18 mins to complete This particular nonclustered ...
0
votes
1answer
121 views

Grant access to only one key in azure keyvault

There are multiple keys and secrets in azure key vault . I need to grant a user access to only one key and secret in azure portal. Is that possible?
0
votes
1answer
359 views

Statistics update on Azure SQL DB

New to Azure SQL DB. I was wondering what is the best practices for scheduling jobs like update statistics in Azure SQL DB. Googling got a couple of blogs that uses Azure automation. https://blogs....
0
votes
1answer
230 views

Local Cosmos DB service unavailable

I've installed the azure cosmos db in my local machine but is not loading the explorer pages as shown below: Explicit error: Failed to get authorization headers for offers: {"readyState":4,"...
0
votes
1answer
26 views

MySQL database cannot accept SSL connections (Certs are UTD)

Not sure if this is the right place for this kind of question, but I have a MySQL Database running on an Azure VM. Everything was working great, until last week it seemingly randomly stopped allowing ...
0
votes
0answers
19 views

Azure SQL database upgrade

Im wondering something regarding this article: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-application-rolling-upgrade We would like to perform a database upgrade ...
3
votes
1answer
51 views

Has anyone had luck sending dbmail via relay to an external server on an Azure VM (which appears to block SMTP outbound regardless of rules)?

Typically the servers we manage we handle a lot of the alerting for the SQL noise via operators/profiles/DBMail which gives us the most raw information about any issues that crop up on the server. It ...
3
votes
0answers
126 views

Restore from Azure blob storage failing after backup overwrite

I'm attempting to backup a database (full backup, in simple recovery) to Azure storage, replacing a bak file that already exists, then restoring the new backup. Doing a regular backup and restore ...
3
votes
1answer
382 views

Why do these foreign key constraints cause problems? (Azure SQL Server 12)

Here is a simplified version of the database I am attempting to create: create table Worker ( ID int, constraint PKW primary key (ID) ) create table Business ( ID int, W int, ...
5
votes
1answer
247 views

Azure Postgresql hitting 100% memory usage without easy way to restart the server

I have recently noticed an issue when using Azure Database for PostgreSQL where my memory usage keeps growing, and upon hitting 100%, the server will stop responding. This database server is used ...
2
votes
0answers
167 views

On-prem Availability Group secondary replica for Azure SQL Managed Instance

I am investigating migrating an on-premises SQL Server availability group to an Azure SQL Managed Instance (2 databases, 600 tables, 3TB, of which 2TB is blobs). A significant amount of on-premises ...
2
votes
2answers
2k views

The transaction log for database is full due to 'OLDEST_PAGE'

We have a database hosted on azure. It is part of an azure elastic pool. From yesterday all our database operation are consistently failing with following error. The transaction log for database is ...
1
vote
1answer
209 views

Restore Latest Copy of Full and Differential database From Azure Blob Container

I'm trying to work out how to Restore the Latest Backup of a Database that is held on Azure Storage Blobs. This container contains other backups from different databases on a server but I'm only ...
1
vote
1answer
45 views

Transfer data from the cloud to a local database

I have an SQL Server 2016 Azure database in the cloud called XCLOUD, with many tables big and small, and a local SQL Server 2016 database with the same tables and data called XLOCAL. In all databases ...