Questions tagged [azure]
The azure tag has no usage guidance.
2
votes
1answer
32 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
14 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
29 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
16 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
11 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
19 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
1answer
129 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
22 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
23 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
18 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
26 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
64 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
71 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
60 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
23 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
23 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
32 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
49 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
51 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
102 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
25 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
160 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
71 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
120 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
2answers
72 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
56 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
22 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
211 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
1k 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
85 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
224 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
2answers
162 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
53 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
37 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
473 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
159 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
44 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
798 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 ...
2
votes
0answers
49 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
289 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
175 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
494 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
277 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
33 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
23 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
68 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 ...
