All Questions
Tagged with azure-sql-managed-instance azure-sql-database
80 questions
0
votes
2
answers
87
views
How to Get SQL VM High Availability Replica Role (Primary/Secondary) in Azure via CLI?
I am unable to find the specific command that would return the local replica role(i.e. Primary or Secondary) for a SQL Virtual Machine.
I am able to view this role using azure portal in two ways:
Via ...
- 41
0
votes
1
answer
80
views
Creating an Azure Policy to automatically give any SQL Managed Instance Databases a LTR instead of manually assigning them to each database
I wanted to create a policy that automatically gives databases a long term retention instead of doing it manually every time so I created this code but for some reason the database does not get any ...
- 1
0
votes
1
answer
54
views
Azure SQL Partition existing table with an integer field as partition field
I am using Azure SQL database to store data. As the dataset is really huge and it keeps growing day by day, I am looking out a way to partition the existing table based on a integer field. Below is ...
- 499
0
votes
1
answer
63
views
Azure SQL analysts can create views from forbidden cross database data
TLDR Problem
User can view forbidden data by creating a view to the forbidden data in his own personal schema where he has CONTROL permissions.
Introduction
I have a Azure SQL (Managed Instance) ...
- 77
0
votes
1
answer
188
views
Query a database inside Azure managed instance from Powershell
My initial code queries database in my Azure SQL server:
$sql = @{
Server = "$($sqlServer.ServerName).$($dbURI)"
Database = $db....
0
votes
0
answers
132
views
How can I make my code retry when Azure SQL goes down for maintenance?
I am currently trying to do a bugfix on a large piece of existing software. The issue occurs when the application is running a long process overnight and loses connection due to Azure SQL managed ...
- 71
0
votes
0
answers
90
views
SQL query hangs when trying to run any R code
So I am trying to run some R code as part of a SQL query, but it hangs no matter what I put in the R script.
See the below screenshot as an example (this script should list installed R packages, as ...
0
votes
2
answers
153
views
Power BI integration with Signal database has multi tenant
I have one Azure Managed stance database which has multiple tenant stored in it. Now one of my customer is asking for data source to run report using power BI. I am looking for best approach how do i ...
- 2,464
0
votes
1
answer
953
views
Resolve performance problem in recursive CTE
I have a dimensional (star schema) data model that supports BI on labor data. It includes an employee dimension table. This table is a type 2 slowly-changing dimension table, i.e., it stores history ...
- 2,113
-1
votes
1
answer
141
views
How to create custom Azure SQL alerts on T-SQL for bulk updates in Azure SQL DB and Azure SQL MI
How to create custom alerts on T-SQL for bulk updates in azure SQL db and Azure SQL MI.
Currently we can create Alerts in Azure Databade only on Metrics.
My requirement is to create alert on bulk data ...
0
votes
1
answer
274
views
PowerShell to check available free space in Azure SQL Managed Instance
I am working on a PowerShell script to restore databases dynamically from the Azure storage account to Managed instance. To add additional functionality I am looking for a PowerShell module that can ...
- 169
0
votes
1
answer
2k
views
How to use Azure Data Factory to restore an Azure SQL Database from Azure Blob Storage
I have a vendor who dumps a .bak of our database to their SFTP server each night. I'm using ADF to copy that file each day to Azure Blob Storage. I'd like to be able to restore that database from the ...
- 11
0
votes
1
answer
463
views
How can I copy a database in Azure SQL Server to Azure SQL Manged Instance in different Azure Subscription
I created an Azure SQL managed instance using terraform in Azure Subscription A.
I am trying to copy the databases in an existing Azure SQL Server in Subscription B to the SQL Managed Instances I ...
- 1
3
votes
1
answer
5k
views
Importing .bak file into Azure SQL Database
I have received a .bak file that contains a database backup, and I need to import it into an Azure SQL Database. I have tried using the "Restore" feature in Azure portal, but it seems that ...
0
votes
1
answer
292
views
how to set bulk_options in openrowset to read PDF files from Azure blob storage?
I have an Azure SQL managed instance and would like to read pdf files(images) from Azure blob storage with openrowset. I'm able to read single file when I specify pdf file names but to read multiple ...
- 21