Azure SQL Database
An Azure relational database service.
5,297 questions
3 answers
Frequent service health issue for Azure SQL DB
We are encountering frequent service health issues for Azure SQL DB in one of our test subscription. We are getting the below service health issue. “We're sorry your SQL database is unavailable at this time. Currently, Azure shows the downtime for…
asked 2020-06-01T14:17:29.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(288, 71%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kundan Chaulya
11
Reputation points
answered 2020-06-09T13:53:19.477+00:00
Kundan Chaulya
11
Reputation points
1 answer
One of the answers was accepted by the question author.
How to create Azure SQL "serverless" database instance usig Azure SQL API in python?
I am developing an Azure base solution in Django. In that how can I allow user to login using his Azure Active directory Account and create an SQL server first, then create a "Server-less" instance of database with predefined database name? …
![](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(224.00000000000003, 50%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
AZURE SQL MI Error: Stale/aborted version cleanup was aborted for database id '10' due to database shutdown.
Hi, I am trying to restore SQL server .bak file to Azure SQL Managed Instance database through SSMS but getting an error Msg 22003, Level 16, State 1, Line 18 Stale/aborted version cleanup was aborted for database id '10' due to…
asked 2020-06-05T18:47:16.897+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, 57.00000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH0%3C/text%3E%3C/svg%3E)
HemantSudehely-0557
266
Reputation points
commented 2020-06-08T18:03:41.503+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(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
SQL DB Restore On Azure SQL VM directly from BLOB container
I have a SQL DB backup of 3 TB, because of the huge DB we have taken split backup into three files. These are copied to azure BLOB storage File1.bak File2.bak File3.bak While trying to restore directly from Blob, there is error Msg 3294, Level…
asked 2020-06-04T18:02:15.94+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, 13%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Afzal Atique
21
Reputation points
commented 2020-06-08T17:42:00.613+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure SQL Managed Instance - General Purpose Gen5 (256 GB, 4 vCores) Cold Start Delay
I have a SQL Managed Instance (General Purpose Gen5 (256 GB, 4 vCores). I want to know if this database has a "Cold Start" delay on the first query after some idle time. If so, How can this be prevented. It sometimes takes over 1 1/2 minutes…
asked 2020-06-01T18:59:05.787+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(134.4, 39%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
WITHERELL Scott
21
Reputation points
commented 2020-06-08T17:30:00.26+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Azure SQL Database Connection error since today
I receive the following error since today in the morning (yesterday all was fine, no changes): System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login…
![](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, 71%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
5 answers
Let SSAS connect to Synapse without enabling 'Allow Azure services'
Hi all, I want to enable my Azure Analysis Services Cube to process with data from Synapse. But I want to disable the 'Allow all Azure Services' option on the firewall. So now I'm thinking about adding an action to my Data Factory Pipeline (self…
![](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(44.800000000000004, 63%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
1 answer
Azure Questions.
Hi Azure Gurus, I primarily work on AWS but gradually learning Azure for my next project. The shift is quite overwhelming with constant comparisons between these cloud solutions. Have few Questions, if you could help me. 1) The concept of running an…
asked 2020-05-28T16:11:06.24+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(150.4, 38%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
nikhil jain
21
Reputation points
answered 2020-06-05T20:38:24.167+00:00
Ryan Hill
26,856
Reputation points Microsoft Employee
1 answer
Azure Data Studio - How do you connect to Sql Azure with Python and R notebooks.
Azure data studio is pretty amazing.The sql notebooks look like something we will start to use all the time.As I saw Hanselman say in a video, we all have folders full of sql scripts with comments in them for processes to follow. What I am struggling…
asked 2020-06-05T04:32:52.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(137.6, 57.99999999999999%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
Wayne
1
Reputation point
answered 2020-06-05T09:55:53.867+00:00
Vaibhav Chaudhari
38,671
Reputation points
1 answer
Database re-provisioning failed.
Trying to create data sync between 2 databases one on my local computer and the other is on Azure cloud, after creating sync agent and sync group and adding the needed tables to be synced an error appears preventing the sync process. Database…
asked 2020-06-02T10:09:41.983+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(115.19999999999999, 51%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Nour Nabhan
1
Reputation point
commented 2020-06-03T23:26:52.237+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Linked server from Azure Managed instance to Azure Analysis services
In the Azure document, it has mentioned the below info about creating Linked Server in Azure Managed Instance. Linked server does not support the below targets. files, Analysis Services, and other RDBMS. What do they mean by analysis services ,…
asked 2020-06-01T18:15:16.923+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(3.2, 92%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Dan.Thiru
1
Reputation point
answered 2020-06-02T22:18:39.627+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
One of the answers was accepted by the question author.
Common Data Model
hi, can assist me with describing Common Data Model, i am failing to grasp the understanding of it. can an example be made with a real life scenario?
asked 2020-05-30T16:11:33.307+00:00
azwianewi modau
26
Reputation points
commented 2020-05-31T18:02:46.113+00:00
Ronen Ariely
15,101
Reputation points
5 answers
ODBC System-DSN cannot store user password (Azure SQL)
Hello, we connect our application to a Azure SQL database using ODBC system dsn. SQL-Authentication (user/Password) is in use. I am not able store the user password. Everytime the app starts I need to enter the user password. Help is…
asked 2020-05-29T07:40:02.043+00:00
Roland Schmid
1
Reputation point
commented 2020-05-30T03:33:32.333+00:00
Ronen Ariely
15,101
Reputation points
2 answers
SQL select statement using same column twice
I have a simple select statement from one table that lists the same numeric column (TRANAMT) twice. If the number is positive (>0) I want it to show in the first reference of TRANAMT. If the number is negative (<0) I want it to should in the next…
asked 2020-05-29T01:02:52.523+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, 86%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Ken King
1
Reputation point
answered 2020-05-29T13:02:34.497+00:00
Vaibhav Chaudhari
38,671
Reputation points
2 answers
One of the answers was accepted by the question author.
How to Generate Primary Key and store in AAD Token for Future Sessions?
Let's assume I have a MSSQL Table called projects and there is a one-to-one relationship between users and projects and I'm using authenticated calls to CRUD functions implement as Azure Functions to manipulate this table. (That is to say, the Azure…
asked 2020-05-11T22:34:07.61+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, 23%, 40%)' 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)
Siegfried Heintze
1,861
Reputation points
accepted 2020-05-21T01:08:57.737+00:00
Siegfried Heintze
1,861
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure SQL Managed Instance - Error while connecting to Analysis Service - "The OLE DB provider "MSOLAP" has not been registered"
Hi all, we are modifying our application to use a Azure SQL Managed Instance, after changing a few definitions in the installation process and some SQL code we have the database code running. The only exception is the access to a Analysis…
asked 2020-05-18T11:13:02.25+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(134.4, 23%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Luís Pinho
41
Reputation points
accepted 2020-05-19T08:02:29.107+00:00
Luís Pinho
41
Reputation points
2 answers
Which are the most common performance challenges with Microsoft Azure SQL?
I would like to learn more about the common challenges we face with Microsoft Azure SQL. I have seem several trainings that enforce the investigation idea of increasing immediately the resources and see if the challenge is eliminated, but I am not…
asked 2019-11-13T16:04:06.007+00:00
Farcasescu, Marcela
1
Reputation point
answered 2020-05-08T16:22:46.63+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, 21%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Shaila Patel
1
Reputation point