Azure SQL Database
An Azure relational database service.
5,273 questions
1 answer
Azure VNET with NVA and Azure SQL Traffic
Hi All, If we have a VM in a subnet with its default route pointing to a NVA (Firewall) VM in same or different(e.g. Peered VNET) and if we also have Service Endpoint enabled on the subnet for SQL, how does the traffic from VM towards SQL Database…
asked 2020-07-06T08:18:10.713+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, 94%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Maji, Kaushik
1
Reputation point
commented 2020-07-14T00:58:21.437+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
Unable to authenticate MFA for Conditional Access
Hi there, I am currently setting up an Azure portal using a free account which I am currently on a Premium 2 trial for Active Directory. Originally I was able to access the database using the credentials of a user called JP01. This user is part of a…
asked 2020-07-07T17:22:47.5+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, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jp
1
Reputation point
commented 2020-07-14T00:38:18.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(214.4, 81%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Marilee Turscak-MSFT
35,461
Reputation points Microsoft Employee
1 answer
A webapp to write data to azure sql dw
Are there any example to build a web, this web is to allow user to input some values, and then write to database (Azure SQL datawarehouse)?
asked 2020-07-08T08:49:43.557+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, 40%, 23%)' 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)
sakuraime
2,321
Reputation points
commented 2020-07-13T16:51:43.7+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
2 answers
Advanced data security setup through ARM template.
Hi, I am attempting to create an ARM template for a SQL server deployment, I nearly have it working exactly as I like but I am coming across an issue with the managed identity. I am able to successfully create a managed identity for the SQL server…
![](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(35.2, 72%, 13%)' 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)
![](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, 31%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
How to connect our C# application in Azure sql managed instance
Hi, My web application residing Azure cloud server and database residing into Azure SQL managed instance. They are in the same V Net but under different subnet. i am using sql server authentication to login into instance. in application i defined…
![](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, 75%, 29%)' 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)
2 answers
One of the answers was accepted by the question author.
SQL Server migration to Azure
Hi, I am .net developer and slowly moving to Cloud technologies. I have a SQL Server which is on-premises server, Can you please guide me where to start to move this to Azure.
asked 2020-07-09T05:39:10.867+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, 6%, 37%)' 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)
AzureAdmin
41
Reputation points
accepted 2020-07-09T05:53:39.673+00:00
AzureAdmin
41
Reputation points
1 answer
Is it possible for in-place database partitioning?
Dear Sirs We are planning to partition our big database into multiple partitions for better manageability. But the facing problems is when the database partitioning starts. The system would have to be stopped for a few hours, even longer. is it…
asked 2020-07-03T05:52:34.777+00:00
Jeff 老魏
1
Reputation point
commented 2020-07-08T09:32:32.917+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure SQL PIM like access
I wanted to set-up something like a PIM access to Azure SQL but upon reading some docs/article, it's mostly adding a user to an AD Group or to the Azure SQL database itself. Is there a way to do PIM or like that for Azure SQL or any of the Azure…
asked 2020-06-25T15:29:09.287+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, 44%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Ramil Navares
26
Reputation points
accepted 2020-07-06T17:58:56.127+00:00
Ramil Navares
26
Reputation points
1 answer
Azure SQL server Deplyoment using ARM to another Resource Group Schema not deplyoed
HI All, I have Azure SQL server with single database in a resource group. now we want to deploy in another resource group using ARM template. it is deploy but i didn't get schema( Table/View etc..) not show in new resource group
asked 2020-07-03T13:42:23.023+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, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
manish verma
421
Reputation points
commented 2020-07-06T10:07:18.887+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
Using MS Access ODBC with Azure AD
Hi, Is it possible to connect our MS Access DB to our Azure SQL Server using ODBC and Azure AD? Our end users login to their devices using their AD credentials. Is it possible to allow to MS Access DB to authenticate with Azure AD by using the…
asked 2020-07-06T08:18:04.243+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, 95%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
T West
136
Reputation points
answered 2020-07-06T08:19:33.197+00:00
Leon Laude
85,691
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Hyperscale - Memory
I have an database on Azure Hyperscale. Right now the configurations of Hyperscale are as follows: (1) Gen5 16 VCore (2) 80 GB memory It seems memory is not sufficient for our workload, can i just increase memory keeping vcores as 16 ??
asked 2020-07-01T07:05:09.317+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(44.800000000000004, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Scalability Experts
21
Reputation points
accepted 2020-07-05T09:55:24.503+00:00
Scalability Experts
21
Reputation points
1 answer
Replication server restart
I wanna restart a Sql server running on a vm which host replication on it, is it safe to just stop the log and snapshot reader and restart the server or do I also have to disable the publisher and distributor
asked 2020-07-04T07:59:06.443+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(233.6, 75%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK2%3C/text%3E%3C/svg%3E)
kK-2020
46
Reputation points
commented 2020-07-04T09:12:32.203+00:00
Leon Laude
85,691
Reputation points
2 answers
Set up and use Azure SQL
Hi team, I need guidance on the steps to get an Azure Microsoft SQL for SQL database and SQL programming. Especially the requirements, services, and steps to take to achieve this for a database below 500MB. Any help will be greatly appreciated. …
asked 2020-06-03T00:57:55.16+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(291.2, 89%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERO%3C/text%3E%3C/svg%3E)
Roland Okorie
51
Reputation points
answered 2020-07-03T03:17:13.217+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(300.8, 57.99999999999999%, 39%)' 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)
strikersree
21
Reputation points
2 answers
SQL2008 Server R2 License/Product Key availability
I need SQL 2008 Server R2 Installation package with valid product key. Is it possible that I purchase SQL Server 2016 Standard edition software and use the product key for 2008 R2 installation.
asked 2020-07-02T10:05:16.243+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(300.8, 14.000000000000002%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Prashant Joshi
1
Reputation point
answered 2020-07-02T11:37:06.543+00:00
Leon Laude
85,691
Reputation points
2 answers
One of the answers was accepted by the question author.
Monitor SQL Short Term Retention Backups
Is there a way to monitor Azure SQL Short Term Retention Backups? Unfortunately, I don't find any options in the metrics and nothing in the Microsoft documentation. Is it even necessary to monitor this type of backup (because its SAAS) ? I want to be…
![](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, 60%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
2 answers
Azure SQL database system design
Looking for some advice We have two applications which in current form the front end application runs on PCs, and talks to a SQL database which runs on an on-prem server. If we are to move the SQL database into Azure SQL PAAS, what is the most…
asked 2020-07-01T00:24:01.98+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, 28.000000000000004%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mark Anyon | Fission IT
0
Reputation points
answered 2020-07-02T08:12:21+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
SQL elastic job not starting and no logs as well
Hello Team, we are using sql elastic job from past few months and we are seeing no issue but all of sudden , we see that our job are not running and even if we manually start the job , then it states moves to create but it not running and there is no…
asked 2020-06-18T18:12:13.617+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, 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)
Rocky420
21
Reputation points
answered 2020-07-01T22:44:03.6+00:00
Mustafa Elmasry
76
Reputation points
2 answers
How to export data from SQL server to a storage container
Hi All. I will like the output of a SQL query to be stored in a storage container in Azure, was wondering what is the best/secure way of doing this in an automated fashion. This can be one output file for each day, the output is a json type. Ideas…
asked 2020-06-29T20:21:02.647+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(80, 39%, 17%)' 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)
MrFlinstone
501
Reputation points
answered 2020-07-01T07:07:59.44+00:00
Vaibhav Chaudhari
38,666
Reputation points
1 answer
Export Azure DB (but disable encryption)
Hi I know this sounds like a bad idea, but I have a legit reason for this. BUT.... all our DBs have TDE enabled but I'd like to be able to perform a couple of backups without encryption being enabled. Beyond enabling/disabling TDE via the portal for…
asked 2020-06-22T21:59:05.873+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, 36%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKF%3C/text%3E%3C/svg%3E)
Ken Faulkner
1
Reputation point
commented 2020-07-01T01:27:35.907+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Which is easiest solution to get connected to Azure SQL database without SIGN in and saving an Client IP everytime?
I have created SQL server, SQL database in azure.I dont have VM,Azure directory,virtual network.Whenever i want to connect to azure SQL database i need to sign in SQ server management studio,then set IP and also in azure portal i need to save my client…
asked 2020-06-30T11:55:25.233+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(300.8, 38%, 39%)' 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)
Manali
1
Reputation point
answered 2020-06-30T12:37:11.73+00:00
Ronen Ariely
15,096
Reputation points