Stack Overflow
Stack Overflow

Questions tagged [azure-sql]

51 questions
65
votes
5 answers

How to view the roles and permissions granted to any database user in Azure SQL server instance?

Could you guide me on how to view the current roles/permissions granted to any database user in Azure SQL Database or in general for a MSSQL Server instance? I have this below query: SELECT r.name role_principal_name, m.name AS…
user3258784
  • 1,987
  • 6
  • 24
  • 28
7
votes
1 answer

Where does the DataIO in Azure Query Performance Insights come from, when single queries are fast

The following screenshot shows a day of SQL queries and the amount of resources they consume. As you can see, single queries, while there are many don't seem to consume much resources. The bar chart shows a load of 0.08% of Data IO load. The line…
David Flamme
  • 71
  • 2
5
votes
2 answers

What is the main difference between Active Geo Replication and Auto Failover Groups for Azure SQL DB

I would like to know what is the difference between Active Geo Replication and Auto Failover groups in Azure SQL DB ? I read that in Auto Failover groups, the secondary database is always created on a secondary region, but active geo-replication can…
Pallab
  • 1,915
  • 2
  • 19
  • 46
3
votes
3 answers

Azure SQL Convert "Time zone display name" to "Time zone ID"

I am working with the latest version of Azure SQL. I have a series of Time zone display name and want to convert those into Time zone ID. I know SQL server contains both the display name and the id. sys.time_zone_info has all the Time zone ID, but…
Jeff
  • 674
  • 1
  • 5
  • 17
3
votes
1 answer

Azure SQL Single DB (Serverless) Autopause vs SSMS (SQL Server Management Studio)

We're running Azure SQL Single Database (Serverless tier) and are having problems with our development environment SQL servers appearing not to pause despite the DBs being out of use and autopause being correctly configured. We've narrowed it down…
toadflakz
  • 7,764
  • 1
  • 27
  • 40
2
votes
2 answers

Cannot connect to SQL Server from logic app

I'm having trouble connecting to my SQL Server in an Azure Logic App. I've just created a fresh SQL Server and database and am now attempting to connect to it in my logic app. However, it doesn't appear to be showing when I enter my credentials.…
Greg
  • 476
  • 9
  • 23
2
votes
1 answer

Is it possible to inject DbContext with sharding info when using the Azure SQL Elastic Database Client in ASP.NET Core?

I would like to use the Azure SQL Elastic Database Client library to manage SQL Server sharding in my ASP.NET Core application. DbContext is currently injected into my services. I understand I need to add a constructor to my DbContext class that…
Assaf S.
  • 4,676
  • 2
  • 22
  • 18
2
votes
2 answers

Azure SQL authenticate as user via API with MS Identity Platform

I have an ASP.NET Core 3.1 Web App calling an ASP.NET Core 3.1 Web API, which in turn accesses an Azure SQL database. Authentication is provided via MSAL (Microsoft Identity Platform) - i.e. using the relatively new Microsoft.Identity.Web and…
user3529977
  • 215
  • 1
  • 2
  • 9
2
votes
1 answer

Azure Stream Analytics with two event hub inputs joins

I have two Event hub inputs (Event-A & Event-B) to azure stream analytics. Input Event-A: Primary (whenever I am getting event from 'event-A' then I have to do joins with data from 'event-B' for last 20 minutes duration) Input Event-B: Secondary…
user1531248
  • 521
  • 1
  • 5
  • 17
2
votes
2 answers

Slow API call Azure App Service and Azure Standard database 50 (S2) with Entity Framework

I'm hosting an app on Azure for testing purposes. However a lot of API calls are getting really slow even though performance does not seem to be maxed out at all. One API call that takes 170 ms locally with IIS Express and SQL Server Express takes a…
Ogglas
  • 62,132
  • 37
  • 328
  • 418
1
vote
1 answer

Best way to export firebase into azure sql

Using firebase for App Data - what is the best way to ETL this into Azure SQL so we can analyze better? Have tried doing firebase->big query->azure data factory->azure sql and it just seems a bit clunky. Have seen I could export to JSON then…
Zack Widdoss
  • 69
  • 2
  • 8
1
vote
1 answer

What is the minimum required access level (permission) required to move, create, remove Azure SQL elastic pool?

I am developing a background worker that moves database between pools, create a pool, delete a pool, etc. I couldn't find in Microsoft document what the minimum required access to do such tasks? Admin to Azure SQL Server, Contributor or anything? I…
Dan Hunex
  • 5,172
  • 2
  • 27
  • 38
1
vote
1 answer

Read list of files in azure blob storage folder using Logic Apps and insert file names with extension into Azure SQL

I'm learning Azure Logic Apps work flow, I have extracted archive into folder in blob storage. Now, I need to read files names with extension in extracted path and insert those file name into Azure SQL database. Kindly could I get help in achieving…
Varanasi Phaneendra
  • 113
  • 4
  • 13
1
vote
1 answer

"Cursor" and "FOR XML" clause in Azure data warehouse

While creating stored procedures in Azure data warehouse, I have got some error on "Cursor" and "FOR XML". So wanted to know if they are supported by Azure data warehouse or not. If not then what are the alternatives. sample code with error msg…
shubhi jain
  • 29
  • 3
1
vote
0 answers

Azure SQL unavailable to Web App intermittently

I have a webapp running in Azure. It uses a Azure MSSQL database set to Standard S0: 10 DTUs performance. The backend is written in dot net core 3.1. The app works fine when I visit it. Checking my logs I found a few of these, they happen weeks…
JensB
  • 6,663
  • 2
  • 55
  • 94
1
2 3 4