Azure SQL Database
An Azure relational database service.
5,276 questions
1 answer
One of the answers was accepted by the question author.
Supplier Data Processing/Analytical Services
Scenario Company A has an Azure Tenant and regulatory approval to store and process sensitive data Company B provides data processing and analytical services in Azure (sql database/warehouse, adf, blob storage etc) and does not have regulatory…
asked 2020-08-14T11:59:53.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(208, 57.99999999999999%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
jase jackson USA
201
Reputation points
accepted 2020-08-23T07:49:45.367+00:00
jase jackson USA
201
Reputation points
0 answers
SQL Data Sync Stuck
Hello, I think my Azure SQL Data Sync is stick in processing. This article mentions posting to this forum with my Subscription ID and Sync Group ID: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-troubleshoot Taken…
asked 2020-08-07T19:38:44.427+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(112.00000000000001, 49%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kyle Stokes
1
Reputation point
commented 2020-08-22T17:38:57.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(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
One of the answers was accepted by the question author.
Action recommended: Allow communication with existing Azure SQL Database gateways by 15 September 2020
Hi, I have received and email with the title: Action recommended: Allow communication with existing Azure SQL Database gateways by 15 September 2020 And the body says: Update your network configuration to allow communication with existing Azure SQL…
![](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(140.8, 40%, 23%)' 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
MSSQL migration to Azure SQL managed instance TSQL differences
Hi, We are planning to migrate SQL server 2008r2 running on Windows 2008r2 to Azure SQL managed instance. I have read Microsoft documentation some of TSQL like Always on availability group, CLR functions (with restriction) are not available in Azure SQL…
asked 2020-08-07T08:13:32.297+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, 12%, 37%)' 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)
Sam
1
Reputation point
answered 2020-08-21T04:39:20.94+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
One of the answers was accepted by the question author.
Metrics stopped recording
I have an Azure elastic pool, and the pool and all databases record zero for all metrics starting about a week ago. Any hints on troubleshooting?
asked 2020-08-11T20:09:43.087+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(121.6, 89%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Thomas Carbone
21
Reputation points
commented 2020-08-20T12:13:22.567+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, 64%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWT%3C/text%3E%3C/svg%3E)
Wojciech Torkowski
1
Reputation point
1 answer
One of the answers was accepted by the question author.
SQL gateway migration Sep 2020, please clarify (Need clarity on impact)
Hi Everyone, Can you please clarify the article at https://learn.microsoft.com/en-us/azure/azure-sql/database/gateway-migration?tabs=in-progress-ip it states Traffic migration may change the public IP address that DNS resolves for your…
asked 2020-08-17T12:25:20.653+00:00
Pranesh Sathyanarayan
191
Reputation points
commented 2020-08-19T14:56:07.88+00:00
Pranesh Sathyanarayan
191
Reputation points
1 answer
Permission to add user to db_accessadmin without adding to db_owner
I have a client with a head-office, and various field offices. I would like to grant a couple of head office people, who are SQL Azure contained users, the permission be become what I'm calling an "admin-lite". Specifically, I want them to be…
asked 2020-08-07T11:58:44.693+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(304, 10%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Andrew Richards
1
Reputation point
commented 2020-08-19T07:48:37.02+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
What is causing waittype CXSYNC_PORT and what to do about it?
Hi, I'm running a query against Azure SQLDb which 'stands still' for 2 hours now, apparently not doing anything. No CPU-usage (from anyone), no DataIO, no LogIO. sys.dm_exec_requests tells me my query is suspended with wait type CXSYNC_PORT. What can…
asked 2020-08-12T11:02:51.197+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, 34%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVV%3C/text%3E%3C/svg%3E)
Veelen van, Klaas
11
Reputation points
commented 2020-08-18T20:26:58.157+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, 32%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Steve Rajkovich
16
Reputation points
1 answer
Four questions concerning the configuration of Azure
Hello Azure-Community, I am currently adjusting the configuration of our IT infrastructure to Azure and have come across a few questions. I am grateful for any help in this regard. ) We are currently using DS1_v2 for our staging environment and…
asked 2020-08-14T07:14:03.4+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, 28.999999999999996%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Pablo S
106
Reputation points
commented 2020-08-18T12:38:36.75+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
Azure dev test Labs
Experts, I am new to this Arena. So i tried free tier to learn Az-900. but as Corona pandemic was on its peak in April-June month, i tired trying to use this free tier but coulnt get success in even creating a single VM. so my free tier expired for me…
asked 2020-08-14T03:48:36.527+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, 3%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Manish G
1
Reputation point
commented 2020-08-17T20:21:22.987+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
Phising Scam?
I received an email from Microsoft: "Update your network configuration to allow communication with existing Azure SQL Database gateways by 15 September 2020" Recommended action To avoid service disruptions, update your network…
asked 2020-08-17T15:52:27.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(185.6, 99%, 27%)' 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)
SandroM
1
Reputation point
answered 2020-08-17T17:29:58.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(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma
17,581
Reputation points
0 answers
High reported CPU using tedious (nodejs) after Azure SQL database switch
Hello, After Azure SQL database switch (because of internal upgrade of SQL engine/VM or configuration change like upgrade from S2 to S3), we observe a very big CPU spike after 3 to 10 minutes after the switch which will not go away unless we close…
asked 2020-08-06T10:34:12.84+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, 14.000000000000002%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Rafał Jońca
26
Reputation points
commented 2020-08-17T16:24:52.77+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Connection Problems When Deploying SQL DB To Azure DB
I have created a new Azure account to publish my web app + DB. I have created the app service, service plan, SQL Server and SQL DB, I have also configured the Azure sql server firewall to accept request from my client IP. WHAT'S WORKING When I'm…
![](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, 57.99999999999999%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOO%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(249.60000000000002, 39%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
1 answer
Create SQL user at deployment time
In our release pipeline in Azure DevOps we provision a SQL server and a SQL database. After the database has been created a contained user is created in that database manually, before the application can be started. I'm trying to create the contained…
![](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, 3%, 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)
0 answers
Azure Java EventHubTrigger using r2dbc-mssql gives netty errors
I am trying to persist the messages received b y a Java EventHubTrigger to Azure SQL Database using r2dbc-mssql driver. When the function gets triggered I get the following error: Caused by: java.lang.NoSuchMethodError:…
asked 2020-08-07T19:21:42.927+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(124.80000000000001, 88%, 22%)' 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)
Nalla
1
Reputation point
commented 2020-08-17T06:23:55.873+00:00
Pramod Valavala
20,601
Reputation points Microsoft Employee
2 answers
Unable to create External table in Azure SQL / SQL (onpremise) using Azure Storage as Source
Hey Team , I am trying to create external table using Azure Storage as source. In Azure SQL , i am getting error : External tables are not supported with the provided data source type. In OnPremise DB , Incorrect syntax near 'EXTERNAL'. Please…
asked 2020-08-11T10:15:38.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(32, 55.00000000000001%, 13%)' 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)
Arun Agrawal
1
Reputation point
commented 2020-08-17T00:59:52.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(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,611
Reputation points
1 answer
One of the answers was accepted by the question author.
Question concerning SQL Databases
Hello Azure-Community, I am currently adjusting the configuration of our IT infrastructure to Azure and have come across a few questions. I am grateful for any help in this regard. 1.) Regarding SQL Databases: What storage capacity does a pool have…
1 answer
managed Instance provisioning charges
Experts, As we all know managed instance provisioning takes a lot of time, so this provisioing time is also considered in cost or only once this MI is ready for us, only that time is calculated.
asked 2020-08-14T02:30:31.973+00:00
Manish G
1
Reputation point
answered 2020-08-14T07:25:30.59+00:00
Anurag Sharma
17,581
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure ADFS 2019 Azure SQL/mi Options?
We want to do a cut over from ADFS 3.0 to Azure 5.0 (2019) in the cloud. I read that Server 2016 ADFS does NOT support Azure SQL, we tired with 2019 and it did not work either, could not find the Database from the wizard. Should we try SQL mi or since…
asked 2020-08-13T16:58:56.22+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, 32%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rodney R. Fournier
21
Reputation points
accepted 2020-08-13T18:36:37.803+00:00
Rodney R. Fournier
21
Reputation points
1 answer
Use dockered LocalDB with a local application
Hello ! Would it be possible to use LocalDB running on Docker with an application running locally ? Thanks a lot !
asked 2020-07-08T09:51:41.2+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(86.4, 65%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
Vincent Chiche
1
Reputation point
commented 2020-08-13T12:31:58.217+00:00
Vincent Chiche
1
Reputation point