Newest 'azure-sql-database' Questions - Stack Overflow

Questions tagged [azure-sql-database]

Azure SQL Database is a relational PaaS database hosted in Microsoft Azure. Azure SQL Database provides predictable performance, scalability, business continuity, data protection, and near-zero administration for cloud developers.

-2
votes
1answer
39 views

Why is Azure SQL database so expensive?

For a small personal coding project I recently created a SQL database in Azure. For the past weeks I have been hardly using the database, out of 2 GB available space I have been using only 13 MB. ...
0
votes
2answers
24 views

Can I store txt files in Azure SQL Database?

Hi is it possible to store .txt files inside azure sql database? if not then which service provides this?
0
votes
1answer
16 views

Azure SQL login as Rest-API authenticated user

I am building a WebApp in Azure and the users log in in their App, thorugh their Azure account. The WebApp frontend is sending a Bearer authentication token to the backend so that the backend can ...
0
votes
1answer
20 views

How to configure the alert whenever the primary Azure SQL Database goes down?

In Azure, how can you configure an alert or email notification when a SQL Server failover happened whenever you have setup a SQL server with Failover groups and failover policy is set to automatic? ...
0
votes
1answer
17 views

How to connect to Azure SQL Server in databricks using active directory authentication

In the below code I am using SQL Server user id and password to connect to my db. But I get an error while connecting with active directory. Please Suggest some solution to connect Azure SQL Server ...
0
votes
0answers
17 views

How can I create a Session in Azure SQL using Database Versioning concept for where two or more users where they can make changes and submit it

I would like to provide my users with a session or workspace using Azure SQL DB where they can take a snap shot of the database and cook up their changes, analyze the result and then submit the final ...
0
votes
1answer
23 views

How can I create a contained user on an Azure SQL database using C#?

I need to create a contained user for my Azure SQL database using C#. I have the following code already for creating the database: // Login to Azure var credentials = UserTokenProvider....
0
votes
1answer
30 views

Error while creating sql database in existing Azure SQL Server

While creating a sql database with following parameters: Want to use SQL elastic pool? - No Compute and storage - Free, 32 MB storage and default Additional settings using existing Azure SQL Server,...
1
vote
1answer
23 views

What events are tracked in Azure Sql audit Logs

What type of events are tracked in Azure Sql Database auditing. Can we setup to audit is a specific column in a table is updated?
0
votes
0answers
22 views

I want to import my json file from azure file storage to azure database

i have a json file in azure file location and i want to import that file into azure sql database. i also want to query my json into a table. json format { x ,x , {1.2.3], x} i want to upload [1,2,3]...
0
votes
1answer
14 views

Azure ADF unable to create linked service to an Azure SQL server VM in a different tenancy or subscription

I am trying to create a pipeline to copy some data between Azure SQL databases on different servers, but creating a Linked Service using SQL authentication fails (and gives no helpful information, ...
0
votes
0answers
17 views

How to get SQL database connection compatible with DBI::dbGetQuery function when converting between R script and databricks R notebook?

I have an R script that uses odbc::dbConnect to connect to an SQL database (some databases are Azure, some are on-premise but connected to the Azure VPNs via the company's network, though I don't have ...
-2
votes
2answers
64 views

Should we upgrade MySQL, move to PostgreSQL, or go cloud? [on hold]

We use an internal MySQL 5.5 server for our ERP system. Issue things are getting slow, and bosses are getting annoyed our SLA with our infrastructure service provider is ending soon. our small dev ...
0
votes
4answers
35 views

How do you check the status of a SQL Import Export Operation in Azure?

I am performing a SQL Database Import using a BacPac file to Azure using the REST management API. I need to be able to check the status of an import, as Azure does not allow for me to send events when ...
0
votes
0answers
23 views

Running Azure SQL stored procedures as logged in AAD user

I'm trying to connect to a SQL database on Azure from a web app in such a way that the currently logged in Azure AD user is passed to the database and the stored procedures are executed by said user ...
1
vote
1answer
52 views

Azure PowerShell script does not work when change to a different Azure Subscription

I am experiencing a very strange problem. I recently switched Azure subscription from free trial to pay-as-you-go. The PowerShell script i wrote to create Azure Resource Group, Azure Data Factory, ...
1
vote
1answer
24 views

WHERE clause on an alpha column containing integers fails in an integer comparison

I can't see why the comparison fails in this sample code: create table #a(a nvarchar(10)) insert #a values( 1 ) insert #a values( 2 ) insert #a values( 3 ) insert #a values('A') select * from (select ...
0
votes
1answer
17 views

Query on Azure SQL database on behalf of user in a REST-API

I am building a REST-API that talks to an Azure SQL database using .NET core 2.2 and C#. The API runs as a webapp on Azure. The user-access rights are managed by the database itself. My API requires ...
0
votes
1answer
37 views

SQL Stored Procedure - Understanding SQL Statement

New to stored procedures. Can anyone explain the following SQL sample which appears at the start of a stored procedure? Begin/End - Encloses a series of SQL statements so that a group of SQL ...
2
votes
1answer
59 views

Move Azure SQL Managed Instance across subscription

I have two SQL managed instance in two different region(One in Australia East another one in Australia Southeast. They are in a Pay-As-You-Go subscription. Now I want to move those resources to a CSP ...
-2
votes
0answers
21 views

Loading data from azure database to elasticsearch using logstash

[‎19.‎06.‎2019 18:01] Mouhamed Chaker: i have an SQL SERVER database hosted on azure, i want to migrate data to elastik stack here is my logstash config file , and its doesnt work, i have installed ...
-1
votes
1answer
39 views

SQL Merge using date range on source

I'm trying to create a query that will merge only Trips occurring in the next 3 days. The Query will be ran on Microsoft flows nightly to populate company app. Db is running on Azure SQL and [Trip ...
0
votes
0answers
32 views

How to get the actual error in case of uncommitable transaction in sql server?

I am calling an sp from another sp which is calling another sp from within. For instance sp1->sp2->sp3 I have used TRY-CATCH in all of them. I raise an error explicitly in the sp3 and then catch in ...
0
votes
0answers
16 views

MySql workbanch migration wizard does not retrieve schema

I am trying to migrate from azure SQL to Google Cloud MySql using MySql Workbench migration wizard. I am using the administrative user to connect to azure SQL. The 'Fetch Schema List' finishes ...
0
votes
2answers
39 views

How to select 2 cross split string column in single query

CREATE TABLE #StudentClasses ( ID INT, Student VARCHAR(100), Classes VARCHAR(100), CCode VARCHAR(30) ) GO INSERT INTO #StudentClasses SELECT 1, 'Mark', 'Maths,Science,English', ...
1
vote
0answers
22 views

Azure Max DB Connections on Release to Prod

When we release our Sitecore site to Production, the release takes 7 to 8 mins, and when it seems to be back up, we are getting the warning: The request limit for the database is 90 and has been ...
0
votes
2answers
23 views

How to convert an integer column as a comma separated row in Azure sql

Anyone can help please I want to Convert sql table column to a comma separated row in azure sql I have already tried this code but getting error that can not convert to varchar ...
0
votes
1answer
27 views

Write Microsoft Forms data to Azure SQL

I need to create a data entry form for my users, writing to an existing table in my Azure SQL Server. At present I'm using Microsoft Forms, exporting the data as an Excel spreadsheet each week and ...
-1
votes
0answers
34 views

Shared data with Sql Azure [closed]

We have some crucial data, which is imported via Azure Functions from a external data provider and is now integrated in one database and codebase. But now we are starting a new codebase ( different ...
1
vote
1answer
37 views

_tds.InterfaceError when trying to connect to Azure Data Warehouse through Python 2.7 and ctds

I'm trying to connect a python 2.7 script to Azure SQL Data Warehouse. The coding part is done and the test cases work in our development environment. We're are coding in Python 2.7 in MacOS X and ...
0
votes
2answers
41 views

“CloudException: … Insufficient read or write permissions on the provided storage account.” when enabling DBServer audit logs in Azure

How can I successfully limit the scope of allowed access to an Azure StorageAccount to a specified DatabaseServer? I want to enable Audit logs on a database server in Azure [documentation]. I am ...
-2
votes
0answers
32 views

Automation script for create the database sql server [closed]

As a automation tester (selenium web dirver / katalon studio) I want to create an empty datgabase (SQL Server) and execute all the schema / stored procedure through my test script. My test case ...
1
vote
1answer
46 views

Upload Custom VHD image to Azure Stack Market Place

I've uploaded a VHD image to blob storage and create a image from that and create VM from that successfully. But when creating new VM in Operating System Disk Image my image is not showing. I tried to ...
0
votes
1answer
34 views

Is there a way to access data from another table during table.read - Azure Mobile App

I am trying to get data from another database before reading data in the table. However, I can't seem to find a way to access it properly. The best I've got so far is based on some other examples ...
0
votes
1answer
27 views

Azure SQL failovergroup, what does the grace period mean?

I am currently reading this: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auto-failover-group, and I have a hard time understanding the automatic failover policy: By default, a ...
0
votes
0answers
39 views

Getting notification from azure “Azure SQL DB database is an instance with high locking waits”

We have live tracking & delivering application.On each minute we are storing almost 50K spatial data and Update 100K spatial records but right now its working for few delivery boys once we ...
1
vote
1answer
23 views

Database connection using tedious

What is the recommended way to establish database connection and close it properly in Node.js using tedious? For each and every request we are creating new connection and processing the request then ...
-1
votes
1answer
31 views

How to deploy Azure SQL S0 instance with ansible azure_rm_sqldatabase?

This or last week MS has changed Azure DB default deployment settings. Our deployment script started creating General Purpose 2 vcores instances instead of S0 instances. I'm trying to fix it but looks ...
1
vote
2answers
46 views

Is there any automated way of exporting Azure SQL database table data to Excel?

I am trying to automatically export the Azure SQL database table data to Excel sheets.I tried to achieve it with Azure Data Factory but couldn't succeed as Azure data factory doesn't have direct ...
1
vote
1answer
32 views

How to retrieve unencrypted password from the azure app service connection string

I am new to azure . I have got a new website to work on its hosted on azure, I needed to find out the connection string .so that i can connect to the database in sql server. The connection string is ...
0
votes
1answer
24 views

How to disable Strong Passwords on Azure SQL

We are in the process of moving a database from on-premise into Azure SQL. The software that will consume this database has a database username and password hard coded, so we are unable to change it. ...
0
votes
1answer
31 views

Sqlalchemy - Connecting to Microsoft Azure - Active directory Password

I was connecting to MS SQL with sqlalchemy using bwlow code and now it has been migrated to azure cloud. I tried the chaging the values code but i think its not the proper way to connect ...
0
votes
1answer
17 views

Auto Azure SQL DB Creation -DACPAC task how to configure database Azure pricing model

I have just found out that MS are changing the default Azure PaaS DB config setting on create to use Vcore instead of DTU. I am using Azure Devops to build DBs from a GithHub repository via DACPACs ...
0
votes
1answer
24 views

The current transaction cannot be committed and cannot be rolled back to a savepoint. Roll back the entire transaction

I am getting the following error message randomly, whenever I am trying to execute the below stored procedure through the .net core application. Error Message: System.Data.SqlClient.SqlException (...
2
votes
0answers
28 views

Problems with LKM loading data from Oracle 12c to SQL Database on Azure

I try to create Loading Knowledge Modules (LKM) which transfers data (about 2 - 3 million rows) from the table located on Oracle (Source Service) to MS SQL Database on Azure (Staging Area). So I can't ...
3
votes
0answers
33 views

SSIS: Error from ODBC provider when inserting into Always Encrypted table using CMK in Azure Key Store

I'm trying to use SSIS (Visual Studio 2017) to insert data into an Azure SQL table with a column that's encrypted via Always Encrypted, and a column master key stored in Azure Key Vault, but I keep ...
0
votes
2answers
32 views

How to know will the selected azure hosting plan will work for my web app hosting

I want to host 1 web app in windows OS with SQL server database. I have selected b1 instance and selected S0 database. I have selected app service and storage is these 2 things are enough to host a ...
1
vote
3answers
30 views

Find who created table constraint in azure sql database

I have a azure sql database. Is it possible to find out who created the constraint on table? Or at least when it was added? If yes, how can I do that? Is there any scripts/tools for that purposes? ...
1
vote
2answers
34 views

Azure SQL query suddenly firing thousands of times

All of a sudden from about 8AM this morning a particular query from my website has been firing hundreds of thousands of times an hour, this is within a WebAPI method which is called from a mobile ...
1
vote
3answers
37 views

How to: Change actual execution method from “row” to “batch” - Azure SQL Server

I am having some major issues. When inserting data into my database, I am using an INSTEAD OF INSERT trigger which performs a query. On my TEST database, this query takes much less than 1 second for ...