Questions tagged [azure]
288 questions
7
votes
1 answer
Azure SQL DB vs Azure managed instance
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, ignoring the cost, is there any reason why not to go…
Azuremigration
- 71
- 1
- 2
6
votes
2 answers
AlwaysOn AG versus FCI
Throughout MS documentation for AlwaysOn Availability Groups (AG) and AlwaysOn Failover Cluster Instances (FCI) I see the following pattern:
FCI is for HA scenarios.
An AG synchronous secondary replica, co-located with the primary, is for HA…
Brent Arias
- 181
- 1
- 5
6
votes
3 answers
Azure SQL Database Restore after Server Failure - Where are the Backups?
According to this article, an Azure SQL backup can be used to "Restore a database to another geographical region. This allows you to recover from a geographic disaster when you cannot access your server and database. It creates a new database in any…
Randy Minder
- 1,942
- 4
- 19
- 33
6
votes
2 answers
IS_MEMBER() in Azure SQLDB not working for AD groups?
I am trying set up RLS and want to leverage AD groups.
DB is created in Azure, and I know AD is working as I can connect using AD acount with SSMS
First test Local Machine, is working as expected (img 1)
Now try Azure
The IS_MEMBER() appears to…
Mark West
- 61
- 3
5
votes
0 answers
Can Azure Backup Server backup databases participating in Log Shipping?
We have a number of log-shipped SQL 2017 databases which we wish to start backing up using Microsoft Azure Backup Server (locally and to the cloud) on a 15 minute schedule.
Does anyone know if it is possible for Azure Backup Server to hook into the…
Mark
- 799
- 1
- 6
- 17
5
votes
1 answer
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 server admin* and connect to the database using an…
Alex KeySmith
- 297
- 4
- 16
5
votes
1 answer
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 exclusively for development, so it has a lot of…
José Maia
- 53
- 5
5
votes
2 answers
Why is my UTF-8 document raising UTF-8 encoding errors in Azure Data Lake Analytics?
I have a document that was compressed in gunzip from a unknown source system. It was downloaded and decompressed using a 7zip console application. The document is a CSV file that appears to be encoded in UTF-8.
It's then uploaded to Azure Data Lake…
Fastidious
- 476
- 1
- 7
- 15
5
votes
3 answers
CREATE DATABASE AS COPY does not work with Azure
I'm new with T-SQL and MSSQL but need to copy Azure SQL database from one server to another.
As I googled here - it can be done with a CREATE DATABASE Database1_copy AS COPY OF server1.Database1; query, but in my Vusial Studio Code editor on the…
setevoy
- 229
- 2
- 10
5
votes
2 answers
Add Active Directory User For Azure-SQL-DB
I have an active directory user LDomain\LUser and I want that user to be able to connect to Azure-Sql-DB. The syntax MS uses is throwing an error.
T-SQL:
CREATE USER [LDomain\LUser] FROM EXTERNAL PROVIDER
Error:
Principal 'LDomain\LUser' could…
WhyAShortage
- 131
- 1
- 1
- 7
4
votes
1 answer
Power BI on-prem data gateway for Azure devops pipeline?
I'm building a POC for DB devops using redgate SCA and an azure devops pipeline. Need to connect to our SQL Servers that don't have public IPs. Was hoping power BI on-prem gateway would facilitate. Is there a way to make that work, or do I need…
PeterDaniels
- 131
- 6
4
votes
1 answer
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 ‘ACCEPT_EULA=Y’ -e ‘SA_PASSWORD=’ -p…
Brian Gradin
- 143
- 2
4
votes
1 answer
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 DROPCLEANBUFFERS on Azure.
Is there some workaround by which I…
Saurabh
- 53
- 5
4
votes
1 answer
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 appears that within Azure VMs, outbound via port…
A. Nelson
- 95
- 5
4
votes
3 answers
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 full due to 'OLDEST_PAGE'
We checked for all…
Ketan
- 457
- 3
- 6
- 13