Questions tagged [azure-sql-server]
548 questions
2
votes
1 answer
Optimize my Azure SQL PaaS Table and/or query to increase performance
I am designing a table with a very specialized use pattern.
The table will be logged to continously with limited traffic - ~25 records per second, and then every night I run one single big query to extract a lot of data.
My table creation script…
WPFUser
- 403
- 4
- 16
2
votes
1 answer
Create database with filegroups in Azure SQL Server (Logical Server)
I want to create a database within Azure SQL server I have gone through the following link :
https://learn.microsoft.com/en-us/sql/relational-databases/databases/sql-server-data-files-in-microsoft-azure
but this didn't solve my problem and it took…
Sracanis
- 490
- 5
- 25
2
votes
2 answers
how to find if replication role of Azure SQL database
I am trying to find the replication role of Azure SQL DB (Primary or Secondary).
I used : Get-AzureRmSqlDatabase command but could not find the replication information.
Is there a different powershell command to find replication role ?
K.Pil
- 786
- 2
- 10
- 24
2
votes
1 answer
How to use Azure Applications appRoles (defined in application manifest) as Roles in Azure SQL
Our team would like to use application roles defined inside the Application manifest when registering an Application inside of the Azure Portal. Here's a sample from our TestApp's manifest.
"appRoles": [
{ "allowedMemberTypes": [
…
Greg Grater
- 2,001
- 5
- 18
- 24
2
votes
2 answers
"Unknown property PrimaryFilePath" error when connecting to Azure SQL Data Warehouse database
I've tried to make a new data Connection From Microsoft Visual Studio Entity Framework Data Model Wizard to Azure SQL Data Warehouse , but got an error:
Failed to retrieve data for this request. unknown property
PrimaryFilePath
I can…
Michael Freidgeim
- 26,542
- 16
- 152
- 170
1
vote
1 answer
Terraform - Add tags to failover SQL databases
I am trying to figure out a way to add tags to the failover DBs created with the help of terraform registry - azurerm_mssql_failover_group.
if I use the tags field mentioned as part of terraform documentation, it adds tags to the failover group but…
Tarun Bhatt
- 727
- 2
- 8
- 28
1
vote
1 answer
Connecting C# Azure Function with Azure SQL using User-Managed Identity. Authentication Failed
I am Currently working on Azure Function with Azure SQL connection. The Azure SQL Server was mapped with User Managed Identity. When I connecting the Azure SQL server with Azure Functions in C# I am facing Authentication Issues.
Please find the…
Vinoth
- 13
- 4
1
vote
1 answer
Delete data from all tables except master tables with foreign key contraints in SQL Azure
I have 70+ tables in my azure sql database. I want to delete data from all these tables except some by bypassing the foriegn keys. Is there any script available to do the same because some table may have complex and long foreign key relationships.
I…
user3501613
- 596
- 7
- 28
1
vote
1 answer
Determine if a database is an azure database
Is it ok to assume that if the server name ends with "database.windows.net" that the database is hosted on azure?
I tried executing this code on my azure db:
SELECT CASE ServerProperty('EngineEdition')
WHEN 1 THEN 'Personal'
WHEN 2…
the1.9gpaProgrammer
- 95
- 1
- 10
1
vote
0 answers
Is there any way to migrate delta changes of Azure SQL database from lower environment to higher environment
I am using Azure SQL DB as a database in one of the project. I have set up a CI/CD pipeline to migrate the SQL changes from Dev to QA environments (Also to other higher environments)
Currently I am using Azure SQL deployment task to move all changes…
Maheswara Reddy Yarramreddy
- 89
- 2
- 9
1
vote
1 answer
PowerShell :: Microsoft.Azure.Commands.Sql.Database.Model.AzureSqlDatabaseModel.DatabaseName
I wrote a script that allows me to query the whole Azure database park:
#$ErrorActionPreference = 'SilentlyContinue'
# Connect to Azure
$azureAccount = Connect-AzAccount
# Get Azure Access Token (we will use this to query the…
Francesco Mantovani
- 10,216
- 13
- 73
- 113
1
vote
1 answer
Where to put common stored procedures in Azure SQL Server
I have a couple of stored procedures that will be used only for maintenance tasks (facilitating truncation of tables, rebuilding indexes etc). In my mind the natural location for these would be the master DB (or any other central DB) so that other…
FinneVirta
- 374
- 1
- 4
- 14
1
vote
1 answer
Restore database on another server in azure with terraform
How do you restore an azure sql database using terraform on another server from a backup?
Terraform docs talk about a create mode "RestoreExternalBackup". How could one use…
user1842278
- 1,039
- 1
- 12
- 25
1
vote
1 answer
Azure SQL Failover through T-SQL
I am conducting some tests, therefore I have two instances each in a specific region, the database has been configured with a geo-replica and added to a failover group.
While trying to trigger a failover through SQL commands, it looks like it…
Călimanu Loredan
- 53
- 7
1
vote
2 answers
SQL Configure Distribution Connection Issue
I am trying to configure the distribution of SQL Server (2016). This is an Azure SQL VM. However, when doing so I get the following error:
TITLE: Configure Distribution Wizard
------------------------------
SQL Server is unable to connect to server…
a.powell
- 1,572
- 4
- 28
- 39