Azure SQL Database
An Azure relational database service.
5,334 questions
1 answer
One of the answers was accepted by the question author.
Where can I find a list of known issues on a specific version of SQL 2017
Good Morning, I would like to know where i could find the list of known issues on this specific version of SQL Server 2017? Microsoft SQL Server 2017 (RTM-GDR) (KB4505224) - 14.0.2027.2 (X64) Jun 15 2019 00:26:19 Copyright (C) 2017 Microsoft…
asked 2020-06-17T08:38:58.343+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(166.4, 16%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Lombard, René
21
Reputation points
commented 2020-06-17T09:19:46.97+00:00
Leon Laude
85,711
Reputation points
2 answers
One of the answers was accepted by the question author.
Unable to backup sql azure to a bacpac in blob
Hi, I have been trying repeatedly to backup a sql azure database to a bacpac file on blob. Each time I do, it fails with an error One or more unsupported elements were found in the schema used as part of a data package. Error SQL71501: Error validating…
![](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, 72%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
How do you build SSIS packages in VS 2019
I know SSIS is being phased out but what are they putting in place of it? I installed SQL Server Data Tools which seems great at writing simple T-SQL Statements. What do we do to create more complex projects?
![](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(22.400000000000002, 43%, 12%)' 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)
1 answer
One of the answers was accepted by the question author.
How to extract nth occurrence substring from a string column in SQL Table
Hi All I have a nvarchar(MAX) column (as below) in SQL table, I need to extract nth occurrences substring from this column; I manage to extract the 1st occurrence with CHARINDEX statement 10137-microsoft-technet-qa-roychen.pdfbut unable to extract…
![](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, 3%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
1 answer
Meta data identification
Hello Team, We have a scenario wherein we need to identify where all a column of a particular table is being used and which all tables would be impacted from the same. eg: col 1 of table t1 is being dropped Scenarios: there is a stored…
asked 2020-06-12T05:52:24.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(57.599999999999994, 2%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Nandan Gajanan Hegde (g)
1
Reputation point
commented 2020-06-16T07:02:47.273+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(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
SSIS ObjectRef Compatibility Issue
In the SSIS Dimension Processing Destination, there is an ObjectRef statement originally written in ASSL. However, it reports compatibility issue saying that the interface is not supported. Our DBA suggested that he attempted to upgrade Tabular model to…
asked 2020-06-10T22:39:26.367+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, 96%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHQ%3C/text%3E%3C/svg%3E)
Hongru Qi
1
Reputation point
commented 2020-06-15T10:04:19.013+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
2 answers
One of the answers was accepted by the question author.
Can't seem to find any documentation regarding SQL Addin
Im trying to develop an extending add-in to SSMS, versions 15,17,19 . From the little I found on the web there are only a small number of tutorials to create a simple add-in using VS add-in but nothing more, I searched the entire directory of SQL on…
![](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(227.2, 3%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
1 answer
Test Database using MPN Benefit
I want to create an Azure SQL database to test VB.Net code for accessing an Azure Database with my MPN benefit of $130 CND/month. But when I attempt to configure an SQL database in the Portal using what I think are the least costly parameters, the…
asked 2020-06-10T21:44:14.333+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(284.8, 24%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Robert Scarborough
1
Reputation point
commented 2020-06-13T00:15:59.653+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
One of the answers was accepted by the question author.
performance of JSON Column
How is the performance of when we store data in JSON? Will it impact on creating the report from this JSON Column?
asked 2020-06-10T10:36:36.657+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, 56.00000000000001%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
Kumari, Hemlata
21
Reputation points
accepted 2020-06-12T05:58:52.91+00:00
Kumari, Hemlata
21
Reputation points
2 answers
Cannot sync data from local DB to Azure
I get the following error when syncing local db to Azure: Database provisioning failed with the exception "SqlException Error Code: -2146232060 - SqlError Number:15247, Message: User does not have permission to perform this action. SqlError…
asked 2020-06-10T17:42:37.517+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(243.2, 82%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LD
1
Reputation point
answered 2020-06-11T18:56:17.477+00:00
Manu Philip
17,111
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
SQL FW now blocking SPO requests
This was working previously and now the SQL FW is blocking SPO O365 requests. I've contacted SharePoint and they've said they haven't changed anything on their end. I've checked this document that the IP Addresses are allowed in SQL FW but still…
asked 2020-06-08T23:26:26.44+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(169.60000000000002, 73%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWH%3C/text%3E%3C/svg%3E)
William Holani
21
Reputation points
accepted 2020-06-11T04:02:34.23+00:00
William Holani
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Xevent to azure storage (file target) keeps rolling over
The number of files in my file target location keeps expanding very rapidly. Sometimes they are only ~10kb before the writing to a file stops and another file is created. Below is an example of how I would create an xevent session that targets a…
asked 2020-06-09T16:56:47.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(28.799999999999997, 60%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
David Beavon
211
Reputation points
accepted 2020-06-11T01:19:46.787+00:00
David Beavon
211
Reputation points
1 answer
ARM template failing to restore after creating database. I am using Microsoft.Resources/deploymentScripts to the powershell script.
I am trying to create azure serverless db and restore it with BACPAC which is stored storage account. I am trying this with ARM template, and running Microsoft.Resources/deploymentScripts to the powershell script. the powershell contains the logic to…
asked 2020-06-06T11:34:54.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(118.4, 65%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
mahantesh desai
1
Reputation point
answered 2020-06-10T21:14:43.827+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
FIPS 140-2 validation SQL database service
we are using azure SQL service for our database for our application data store. can we claim as we are a FIPS 140-2 validated?
asked 2020-06-09T16:13:11.513+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, 61%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
ravi Sanapala
1
Reputation point
commented 2020-06-10T21:05:44.563+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
2 answers
cant delete resource group due to master database
SQL server associated with it has already been removed when the delete resource group was run. Db delete error 400 Client Error: Bad Request for url...
asked 2020-06-10T02:05:02.33+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, 50%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
ChrisWork
1
Reputation point
answered 2020-06-10T09:04:56.16+00:00
Ronen Ariely
15,096
Reputation points
1 answer
Insert/Load values into Single newly added column in already loaded table/history data
Hello, I have table called sales having fields Invoice Number,OrderCategory,Item.Its a incremental load table. Everyday day-1 data from source gets added to this table. Currently I had to add InvoiceDate column to table. Now I need to load this…
asked 2020-06-07T17:59:57.657+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(272, 41%, 36%)' 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)
Nody88
1
Reputation point
commented 2020-06-09T23:15:35.227+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Unable to connect to Azure Database due to network settings/Firewall issue
Hello, I am an absolute beginner trying to start a simple project using Blazor and am trying to connect it to my SQL database but am getting this error: A connection to the server 'xxxxxxx' could not be established. This might indicate an issue…
![](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(204.8, 94%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
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
Navtej Singh Saini
4,221
Reputation points Microsoft Employee