Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
0
votes
0 answers

Long Running Azure SQL Database Maintenance

There has been a previous question on this and the accepted answer was Azure Elastic Job agent. The problem I have is that the feature is in preview and it still lacks a lot of functionality like diagnostics and alerting. I also find it to be very…
Michéle Johl
  • 91
  • 9
0
votes
1 answer

Read Azure Audit Logs from Local File System

I have downloaded the Azure Audit Logs in my Local Drive. I am trying to read them from my local machine. I am using below query select * FROM sys.fn_get_audit_file('C:\Ran\Audit\Chevron\2020-04-10\01_48_07_838_426.xel',DEFAULT,DEFAULT) Got below…
Baxy
  • 139
  • 1
  • 13
0
votes
1 answer

Node JS Sequelize cannot connect to Azure SQL Database

I'm currently trying to connect a Node JS app to a single database that I created using the Azure SQL Database. In order to connect to the database, I use Sequelize. In order to do that, I set up the firewall to accept my IP address as explained…
Imperator123
  • 599
  • 2
  • 11
  • 25
0
votes
1 answer

Azure SQL Database - Cross Reference DB Queries - SP

We are currently doing a POC on migrating on-premises SQL DBs to Azure SQL Database. While migrating , we hit with an issue on applying schemas - few of the Stored procedure calls other DBs. Scenario is like we have central DB- A, and there is…
Renji
  • 391
  • 2
  • 7
  • 20
0
votes
1 answer

Updating MS Azure SQL T-SQL stored procedures, functions, tables and Views online in a chromebook without SSMS?

I support some MS Azure cloud solutions that are Azure SQL + Azure Functions C# + Azure Web + JS frameworks. I've been working remote from a Chromebook am able to support 90% of the solution with the exception of SQL stored procedures, tables and…
Hell.Bent
  • 1,667
  • 9
  • 38
  • 73
0
votes
1 answer

Connect to SQL Server using Windows Authentication from Azure Web Job

I am trying to connect to azure sql server using Windows Authentication from azure Web Job. I have tried using the below connection string. When I run the code in an IDE, it is taking the user who is currently running the code. But it's not the same…
Kishore Valavan
  • 1
  • 1
0
votes
1 answer

Is there a possibility to create external table in Azure SQL Data Warehouse pointing to only few folders from the specified location?

I have been trying to create an external table in Azure SQL Data Warehouse by considering only some folders instead of all from the azure Datalake location. But I'm not able to do so. Request for help in this regard. Below is the example for this…
Deekshit
  • 1
0
votes
1 answer

Azure SQL DB with AAD - is there a way to get read-only access

I am looking for a way to sign in into Azure SQL DB with my AAD credentials, but I only want to have read-only access. First try Opened Azure SQL Server Access Control (IAM) tab. Added myself a Managed Applications Reader role. This doesn't allow…
eddyP23
  • 6,420
  • 7
  • 49
  • 87
0
votes
1 answer

How to use a function remove multiple possible prefixes from a Name string in SQL Server

I need to correct Names of users by removing prefixes for a report. I need to use a function here since there is an elaborate case logic in the report. I want to pass a first name with prefix and get back a first name without a prefix. I will be…
user1372603
  • 47
  • 1
  • 6
0
votes
1 answer

Converting None latin characters into latin charcters in Azure SQL Server

I would like to use a function convert none Latin characters to Latin characters when producing a report from the data in the DB, which is Azure SQL Server. i.e. input the original name and output the name with the latin characters For example if a…
user1372603
  • 47
  • 1
  • 6
0
votes
1 answer

How to remove multiple possible prefixes from a Name string in SQL Server

I need to correct Names of users by removing prefixes before I can process the names. For example, my list of prefixes is: am, auf, auf dem, aus der, d, da, de, de l’, del, de la, de le, di, do, dos, du, im, la, le, mac, mc, mhac, mhíc, mhic…
user1372603
  • 47
  • 1
  • 6
0
votes
1 answer

Azure Internal Server Error on ASP.NET Core Web API Controller

I've created a ASP.NET Core Web API Controller with React Js App and it on Azure. After sever try I am able to upload on Azure and now I'm getting error on my API. When I click on Customer it does not give me error but there is no data from SQL…
Rahul Waghmare
  • 125
  • 1
  • 2
  • 9
0
votes
0 answers

Date field calculation is not consistent

I am trying to calculate age-range based on Customer's date-of-birth. Data for this source comes into staging, where I call this following stored procedure. And a batch size generally is 500K to 2M here. CREATE PROCEDURE…
Shanta
  • 262
  • 1
  • 4
  • 15
0
votes
2 answers

Pick the records which has the flag either X or Y, but not the records which has both X and Y from a SQL table

I have a table like this AID B C 2471 D471 X 2471 D471 Y 2471 E471 X 2471 F471 Y 2472 D471 X 2472 D471 X 2473 E471 Y 2473 E471 Y 2474 F471 Y I need to pick the AID which has…
Inc
  • 55
  • 4
0
votes
1 answer

How to avoid GROUP BY or DISTINCT in UPDATE

I have a table like this A B C D E F 00002471 Sd3a28d471 0 24.00 377.500000 1 00002471 Sd3a28d471 0 353.50 377.500000 1 00002471 Sd3a28d471 1 211.00 211.000000 1 00002471 Sd3a28e471 1 343.00 343.000000 …
Rafael S
  • 3
  • 4
1 2 3
…
36 37