Azure SQL Database
An Azure relational database service.
5,122 questions
2 answers
Question around views features on Azure SQL DB
Hi Sorry, I'm from BigQuery... no one is perfect ;>) AND ... There are 2 cool things about this serverless SQL system, I would like to know if it exists on Azure SQL DB & Synapse ? Authorized Views -created on an analysis database…
asked 2022-04-13T13:38:24.733+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 90%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bamak Mrbi
31
Reputation points
commented 2022-04-14T10:28:24.067+00:00
Alberto Morillo
32,886
Reputation points MVP
0 answers
accessing Synapse Table from databricks using pyspark
sql_pwd= dbutils.secrets.get("keys and scope") 2 …
asked 2022-03-22T07:27:50.957+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 78%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar
1
Reputation point
commented 2022-04-13T12:31:54.747+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 45%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVJ%3C/text%3E%3C/svg%3E)
Vishwanath Jangam
1
Reputation point
1 answer
One of the answers was accepted by the question author.
How to find the Azure Firewall Setting Allowing Access is the solution to HTTP Error 500, Site is unable to handle this request Error?
This is regarding the previous question follow-up: https://learn.microsoft.com/en-us/answers/questions/810439/http-error-500-unable-to-handle-this-request.html As I'm new to Azure So unaware of Firewall settings and it is not mentioned in the…
asked 2022-04-13T03:01:28.433+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 87%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
krishna572
876
Reputation points
accepted 2022-04-13T11:48:10.033+00:00
krishna572
876
Reputation points
2 answers
ADF SQL Connection string error in stored procedure activity
Hi, I have an ADF pipeline that fails on a stored procedure activity. Error: "Cannot create Sql Source. Please double check the connection string, stored procedure are set with correct format. Error: The connection string provided is…
asked 2022-04-08T06:44:12.553+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 10%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RoelV
26
Reputation points
commented 2022-04-13T11:09:17.353+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Http error 500, unable to handle this request
A Simple .NET Core 3.1 Web Application fetching the data from the Azure SQL Server: SQL Commands used: CREATE TABLE Course ( CourseID int, CourseName varchar(1000), Rating numeric(2,1) ) INSERT INTO Course(CourseID,CourseName,Rating)…
asked 2022-04-13T01:32:18.147+00:00
krishna572
876
Reputation points
commented 2022-04-13T03:21:05.487+00:00
Alberto Morillo
32,886
Reputation points MVP
1 answer
How create a replication between sqlserver in virtual machine with sqlserver in managed Instance
I have one database in my Virtual Machine that i need replicate to my Managed Instance. Is it possible?
asked 2022-04-12T15:12:51.85+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 92%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
DBA Admin
1
Reputation point
answered 2022-04-12T16:17:51.1+00:00
Alberto Morillo
32,886
Reputation points MVP
1 answer
Azure SQL Database Deployment Fails with Bicep Setting Active Directory Admin
Hi, I am attempting to deploy multiple infrastructure via Bicep, which all works fine until I get to the SQL DB - it fails with the error: "statusCode": "'Conflict" , "statusMessage " : Failed error: The…
asked 2022-02-05T12:01:13.843+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 40%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jag Sandhu
21
Reputation points
commented 2022-04-12T14:10:46.74+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 49%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Martina Sordakis
1
Reputation point
1 answer
Integrated Authentication to Azure SQL from Azure Linux VM
Scenario: 1 Azure SQL database with AAD authentication with permissions based on AAD Group and row-level security based on user name. 2 Linux VM in the same resource group as the SQL server running python and R code accessing the database 3 User…
asked 2022-04-06T01:34:54.757+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 41%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Simon Harrison
6
Reputation points
commented 2022-04-12T13:07:24.813+00:00
GeethaThatipatri-MSFT
27,102
Reputation points Microsoft Employee
2 answers
Subscription Reactivation problem
I am not able to reactivate my subscription while I paid all dues.
asked 2022-04-09T11:08:17.3+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 61%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAU%3C/text%3E%3C/svg%3E)
asmat ullah
6
Reputation points
commented 2022-04-12T13:04:07.56+00:00
GeethaThatipatri-MSFT
27,102
Reputation points Microsoft Employee
4 answers
One of the answers was accepted by the question author.
Alternative to hyperscale sql long term backups
We would like to extend the backup/snapshot retention policy period from 7 days to at least 30 days in our Hyperscale sqlserver db. As far as I know it´s not possible and I would like to know if this feature will be released in the close future. …
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 34%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
2 answers
Azure (Synpase) Binary == Hex?
**Update ** I just noticed there is a spark function "bin" which works perfectly fine for my purpose. Unluckely that function has not been implemented in Synpase DataFlow. Is there a reason why the function is missing and can I hope…
asked 2022-03-22T13:14:56.213+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 9%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
Bohnstedt, Timo
1
Reputation point
answered 2022-04-12T06:45:11.247+00:00
Bohnstedt, Timo
1
Reputation point
1 answer
One of the answers was accepted by the question author.
The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet in Azure Runbook
Hi, Just created sample runbook in Azure to test azure SQL DB index maintenance. Here is the code:`$AzureSQLServerName = "perfserver1sqlsrv-01.database.windows.net" $AzureSQLDatabaseName = "empdatabase" …
asked 2022-04-11T20:12:36.767+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 46%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijay Kumar
2,016
Reputation points
accepted 2022-04-12T04:56:22.133+00:00
Vijay Kumar
2,016
Reputation points
2 answers
One of the answers was accepted by the question author.
Supported Parameters between Trial version vs Regular version for Azure SQL Server?
Hi We are currently evaluating Amazon RDS SQL-Server verses Azure SQL-Server in terms of supported parameters. My colleague has tested out with a trial version of Azure SQL-Server. However it seems like some of the supported parameters are…
asked 2022-04-07T01:32:38.583+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 69%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
Dongsuk Lim
21
Reputation points
accepted 2022-04-11T22:43:51.46+00:00
Dongsuk Lim
21
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL WHERE Clause with SELECT CASE
Hi I have to alter an existing table with a new type of incoming value. Basically, the return rows are conditional on a material type but the existing table holds a bit value for the material instead of material type as a string. The reason is because…
asked 2022-04-11T21:18:52.083+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 31%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NachitoMax
411
Reputation points
commented 2022-04-11T21:51:53.96+00:00
NachitoMax
411
Reputation points
1 answer
Unable to purchase support plan
Hello, I am trying to purchase a support plan with Azure. I am unable to because I receive this message when choosing to purchase Developer support. This is preventing me from filing a support ticket for another issues I am having with a Azure…
asked 2020-09-17T10:34:06.737+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 0%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jamie Gross
6
Reputation points
commented 2022-04-11T14:47:18.843+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 77%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Gary Abbott
1
Reputation point
2 answers
bcp import error: Unexpected EOF encountered in BCP data-file
Using bcp I'm trying to import a csv file to an Azure SQL Db table. But the following command gives the error shown below: bcp US_SBA_COVI19_NYS in C:\Tmp\US_SBA_COVID19.csv -S myAzuresqlserver.database.windows.net -d MySQLDb -U azure-sa -P…
asked 2022-04-10T21:37:25.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 61%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENW%3C/text%3E%3C/svg%3E)
nam wam
1
Reputation point
answered 2022-04-11T12:46:58.613+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips
17,716
Reputation points
3 answers
One of the answers was accepted by the question author.
Connect using Azure Active Directory authentication
Hi There, I am trying to connect to my SQL DB using Azure Active Directory - Integrated but keep getting errors as shown in image no 2. I have read the documentation…
asked 2022-04-09T07:10:30.047+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 12%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Akshay tondak
261
Reputation points
accepted 2022-04-11T10:31:30.723+00:00
Akshay tondak
261
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL backup of a DTU instance
Good morning, I am trying to configure the backup of a DTU instance from the Backup center. I have read from the Microsoft documents that the backup is included in the monthly cost of the DTU database. From the Backup Center I configured the Recovery…
asked 2021-12-07T08:56:47.603+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 46%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
Cristian Nallino
26
Reputation points
accepted 2022-04-11T10:19:40.757+00:00
Cristian Nallino
26
Reputation points
1 answer
One of the answers was accepted by the question author.
What is max life time for a SQL connection in Azure SQL database?
I am trying to set maxLifetime property of HikariCP pool for my spring boot application. For this I need database specific max life time for a SQL connection, could not find any documentation on this. Most of the documentations talk about application…
asked 2022-04-06T08:37:04.127+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 57.00000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vipin Sharma
116
Reputation points
accepted 2022-04-11T07:12:19.057+00:00
Vipin Sharma
116
Reputation points
1 answer
MS Access Table Link Issue after SQL db Migration to AZURE
Hi I have an Access App that used linked tables through odbc from a local SQL Express Server, which works great :) The goal is to provide this app with data in the cloud so that users can be somewhat mobile. I eventually got my trial AZURE SQL…
asked 2022-04-09T08:31:40.457+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 86%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jerry Barrett
21
Reputation points
commented 2022-04-09T19:42:32.41+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 54%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
João Lucas F. Andreatta
6
Reputation points