Questions tagged [azure]
The azure 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 ...
