Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
2
votes
0 answers

Possible to impersonate user-assigned managed identity locally for SQL Server connection

I'm investigating using Azure user-assigned managed identities to access SQL Server from our application which uses EntityFramework 6. I have gotten it to work using this package: https://www.nuget.org/packages/ErikEJ.EntityFramework.SqlServer and…
Ian
  • 4,169
  • 3
  • 37
  • 62
2
votes
2 answers

What is the best practice for creating Azure SQL with ARM template and Key vault

When we create Azure SQL using ARM templates, we have to specify admin username and password using parameters. In the same ARM template, we can create Key Vaults and use key vault values as variables and use them in the server username and password.…
Avilon
  • 121
  • 10
2
votes
0 answers

Results of Azure SQL Vulnerability Assesment

I want to configure Security Baselines for Azure SQL Database via ARM Template. I am referring to the sample code: "resources": [ { "type": "Microsoft.Sql/servers/databases/vulnerabilityAssessments/rules/baselines", …
Manjunath Rao
  • 1,397
  • 4
  • 26
  • 42
2
votes
2 answers

Azure ARM Template - SQL Failover Group Error FailoverGroupCreateOrUpdateRequestReadOnlyPropertyModified

Successfully deployed from ARM template the primary and secondary Azure SQL servers with expected failover groups. Deploying the ARM template on subsequent deployments is returning the following error message: "error": { "code":…
adam
  • 307
  • 3
  • 10
2
votes
1 answer

Tricky partition in SQL

I have a table like this RID ID DTE FLAG AMT SUMAMT 1 1 2020-07-03 02:52:15.480 Y 10 NULL 2 1 2020-07-04 02:52:15.480 N 10 NULL 3 1 2020-07-05 02:52:15.480 N 10 NULL 4 1 2020-07-06 02:52:15.480 Y 10 NULL 5 1 …
Inc
  • 55
  • 4
2
votes
1 answer

TSQL: List all users in all databases attached to an Azure SQL Server

I know I can go to each individual database and run: SELECT name AS username FROM sys.sysusers And that gets me a list of users for that Azure SQL Database. And from the master DB on the Azure SQL Server, I can run: SELECT name AS databasename FROM…
Richard D Lawson
  • 325
  • 1
  • 9
2
votes
1 answer

How to delete all rows from all tables in Azure SQL Database?

I tried to use the answer given Here. But Azure SQL does not have 'sp_MSForEachTable'. Any help would be appreciated
deathrace
  • 908
  • 4
  • 22
  • 48
2
votes
1 answer

Can we remove Server Admin when we define Active Directory Admin for Azure SQL Server?

Lets say I am defining AD Admin for my Azure SQL Server instance -- then isn't 'Server Admin' redundant? Because if I have AD Admin defined , I don't see what is the use for having server admin. And we can have an azure group be specified as AD…
Dhiraj
  • 3,396
  • 4
  • 41
  • 80
2
votes
1 answer

Connect to Azure SQL Server from computer with dynamic external IP

I am trying to connect an on-premises laptop with dynamic external IP to our Azure SQL Server. To do this, I created a virtual network gateway and connected the laptop to the gateway. Also, I added a private endpoint to the SQL server. After this, I…
Oleksii Serik
  • 71
  • 8
2
votes
1 answer

Compare the rows value in a single column and update the flag accordingly in SQL-Server table

I have one table as below A B C D E 2471 D471 0 24.00 1 2471 D471 0 353.50 1 2471 D471 1 211.00 1 2471 E471 1 343.00 1 2471 E471 0 56.00 1 2471 E471 0 177.06 1 2471 E471 0 9.31 …
Inc
  • 55
  • 4
2
votes
1 answer

SQL Server Merge with two tables from different azure SQL Database from same Azure SQL SERVER

I need to merge with 2 different tables from 2 different azure SQL databases where as these two azure sql database are from same azure sql server. also for performance imporvement purpose, what I need to do is bulk insert and/or bulk update. also,…
Priyanka Mane
  • 517
  • 2
  • 9
  • 23
2
votes
0 answers

Local Visual Studio connected to Azure SQL DB - slow connection

I'm looking for some advice. I have been developing web apps over the past few years using Visual Studio on an Azure VM connected to an Azure SQL Database. I recently decided to move Visual Studio to a new local PC to improve VM connection latency…
Steven
  • 177
  • 1
  • 10
2
votes
4 answers

Power BI is converting date to datetime - DirectQuery (Advanced Option)

I have a PowerBI report connected to Azure SQL Direct Query Mode (Advanced Option - where we can write SQL Statements). I got date column in SQL DB (date type), but PowerBI is converting this to datetime, even it’s in date type in SQL DB. Now I…
Ruchita P
  • 359
  • 1
  • 4
  • 17
2
votes
1 answer

What is the naming convention prefix for Azure SQL Server

I found this url for best practices for Azure resource naming conventions. It has list of prefixes based on resource type. I don't find prefix for Azure SQL Server in it. It has prefix for Azure SQL Database but not Server. Is there a 'standard'…
Dhiraj
  • 3,396
  • 4
  • 41
  • 80
2
votes
2 answers

Azure SQL server Login failed for user 'NT AUTHORITY/ANONYMOUS LOGIN'

I'm trying to log into an Azure SQL server from SSMS using my Azure active directory account. I've followed this guide: Configure and manage Azure Active Directory authentication with SQL I've added my account as an admin: And my account also shows…
Bart van der Drift
  • 1,287
  • 12
  • 30
1 2 3
…
36 37