Azure SQL Database
An Azure relational database service.
5,204 questions
2 answers
One of the answers was accepted by the question author.
How to change connection string to different SQL databse on Azure Portal?
I have Web app and Web API both deployed on Azure. Now there is a SQL database on Azure, which is consumed by the App. Where to find those connection string to change the server name to new one? I tried API's configuration setting, where connection…
asked 2020-06-19T22:10:58.573+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, 8%, 22%)' 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)
Anonymous
accepted 2020-06-26T15:58:25.177+00:00
Anonymous
1 answer
Azure SQL - Public Endpoint - Secure Connection
Hi, I'm using a managed SQL instance with public endpoint, From here: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/public-endpoint-overview it says: "...SQL Managed Instance data traffic is always encrypted if the…
asked 2020-06-18T09:34:56.917+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(153.6, 64%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
juni dev
336
Reputation points
commented 2020-06-25T04:07:03.417+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Azure Sql database for my mobile app Userwise ? Different database for Different User ? per single users may have more than a million records
I have develop a MobileApp with offline data sync. with Microsoft Azure Sql Database. It works fine. My App will be use by small retail shops. And every shops login has more than 1 million records. Now My Question is, What is Better ? 1.Use Same…
asked 2020-06-17T11:44:31.097+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(41.6, 95%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Dhiren Naik
1
Reputation point
commented 2020-06-25T03:47:41.957+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Connect to SQL Azure Database - from Home vs from Office
Hi, I have an Azure SQL database on my test subscription I'm able to connect to the DB with SSMS from my Home Network (my IP is whitelisted on server and DB azure firewall) So, the Azure DB connectivity is doable In order to be able to connect to…
asked 2020-06-15T15:38:08.467+00:00
juni dev
336
Reputation points
commented 2020-06-25T03:20:22.693+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Failover groups or Geo-Replication
I am new to Azure database and i need to backup our data for security purpose. What is more commonly used a fail-over group at the sql server level or a geo-replication at the database level, or are they both used together?
asked 2020-06-18T20:13:25.72+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, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
Ernest Taylor
1
Reputation point
commented 2020-06-24T16:50:33.46+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
2 answers
Designing Table Structure for Accomodating Huge Amount of Data
I am working on a use-case wherein I am expected to receive 80 million records every week and I have to load it in Azure SQL Database, some of the data is dimensional type and some is of fact type, I would be using Azure Data Factory to load the data…
asked 2020-06-09T04:27:29.12+00:00
Pratik Somaiya
4,201
Reputation points
answered 2020-06-23T19:50:50.353+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
SQL Server update to version 18.5.1 from 18.5 seems to cause a write error on a query with related tables
SQL Server update to version 18.5.1 from 18.5 seems to cause a write error for a query with 2 related tables. This works in 18.5 and SQL server 2012. We have an Access front-end using a simple query between two related tables as the record source. …
asked 2020-06-22T16:47:20.947+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(275.2, 39%, 36%)' 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)
maryd
1
Reputation point
answered 2020-06-22T16:56:40.723+00:00
Yuji Masaoka
56
Reputation points
1 answer
Access SQL Server from multiple Docker container
Hi, on my Windows 10 Enterprise PC I have installed Docker Desktop for Windows and a SQL Server. In the computer management "SQL Server configuration manager", protocol "TCP/IP" I have the port 49172 configured for TCP/IP. …
asked 2020-06-22T15:10:13.563+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(12.8, 33%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Christian Havel
96
Reputation points
answered 2020-06-22T16:24:53.77+00:00
Yuji Masaoka
56
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure SQL database DACPAC creation
Hello Team, Currently we are in a process of acquiring a 3rd party vendor and take over their data sources which include Azure SQL databases. They did not maintain any code repo for the same and directly made changes via logging in the database. So…
asked 2020-06-02T09:13:16.313+00:00
Nandan Hegde
29,901
Reputation points MVP
accepted 2020-06-19T10:07:02.297+00:00
Nandan Hegde
29,901
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
Metrics for SQL Azure read -only scale out
Hello Team, we have enabled read only scale out feature of SQL azure so that we can redirect our read only traffic to this read only DB and utilize high through put and separate the write and read traffic. Recently , we are seeing some connection time…
![](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, 70%, 10%)' 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)
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,676
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
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
16,991
Reputation points MVP