780 questions
1 answer
EF Core 3.1.14 Recurring Cold Start
We have deployed a very simple .NET CORE 3 Web API application to Azure Cloud. The application is a web api and talks to a very simple SQL server database hosted in Azure as well. There are two main performance problems we are noticing All API calls…
Developer technologies | .NET | Entity Framework Core
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-05-05T22:35:52.187+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, 37%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Varun Sharma
11
Reputation points
answered 2021-05-09T22:50:47.273+00:00
Varun Sharma
11
Reputation points
1 answer
One of the answers was accepted by the question author.
Import azure SQL Database as a database project in visual studio
when I import azure database to my database project in VS 2019, the table object with identity column has been added 'not for replication'. but I check the original object in database server with sql server management studio, it has not such word. This…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
![](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, 91%, 15%)' 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
I'm getting this error when I try to log into SSMS Error9100. Any ideas on how to solve this?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,703 questions
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,499 questions
asked 2021-05-05T23:19:54.643+00:00
Eugene M Roseboro Jr
21
Reputation points
commented 2021-05-07T07:25:36.283+00:00
CathyJi-MSFT
22,396
Reputation points Microsoft External Staff
1 answer
One of the answers was accepted by the question author.
What are the PORTS need to open in Zscalar Firewall to connect Azure SQL from Power BI Desktop Apps
Hi Every one, Recently in our organization, Zscalar configured to user machines. we have users , they use Power BI Desktop application to connect Azure SQL Server Since then ZScalar configured, user facing issue to connect azure SQL Server. Support…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-04-29T20:58:32.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(28.799999999999997, 65%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Mohammad Nadeem Alam
66
Reputation points
accepted 2021-05-06T13:31:17.307+00:00
Mohammad Nadeem Alam
66
Reputation points
2 answers
One of the answers was accepted by the question author.
Free Version of Azure for Training?
I would like a free version of an Azure SQL database so I can follow along with the Microsoft T-SQL Fundamentals manual. Is such a service offered? Would that just be the free trial?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2020-12-26T04:16:51.74+00:00
Landon Aaker
26
Reputation points
commented 2021-05-06T11:48:20.17+00:00
Vaibhav Chaudhari
38,921
Reputation points
Volunteer Moderator
2 answers
Dynamically update schema from source to destination sql tables
Hello, I have a requirement to incremental load into my Azure SQL tables (destination) from my source which are also Azure SQL tables, within the same server but different databases. I thought I could get this done by ADF without the use of stored…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,639 questions
asked 2021-04-28T00:56:40.533+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, 42%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
sam nick
346
Reputation points
answered 2021-05-06T11:22:59.1+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,351
Reputation points
1 answer
How can I query Azure sql db managed instance from Azure sql db?
We have Azure sql db and Azure sql managed instance (for db migrated from on-premise sql server). I want to query tables of managed instance from Azure sql db through a stored procedure using joins. Is this valid and possible scenario? How this can…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-05-06T07:35:53.587+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' %3EAT%3C/text%3E%3C/svg%3E)
Anirud Thapliyal
96
Reputation points
answered 2021-05-06T08:26:06.28+00:00
Vaibhav Chaudhari
38,921
Reputation points
Volunteer Moderator
1 answer
Azure Database Audit filter
I have enabled Azure Auditing in Azure SQL Database, the audit is capturing all activities in the database and store it in Storage Account. My question is, is there away to configure Azure Audit and filter what to capture and not to capture in the…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-04-16T21:22:56.39+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(163.2, 99%, 25%)' 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)
Mohammed
1
Reputation point
commented 2021-05-06T01:41:28.627+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,226
Reputation points Microsoft Employee
Moderator
1 answer
Private endpoint has listening restrictions?
I'm experiencing some deeply frustrating issues when trying to connect to a SQL server Private Endpoint. Setting aside for a moment a complete specification of the problem, I'd like answers to the following questions Is it the case that a SQL Server…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,772 questions
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
550 questions
asked 2021-05-02T20:24:47.88+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(64, 69%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERE%3C/text%3E%3C/svg%3E)
Robert Ellis
1
Reputation point
answered 2021-05-05T11:56:54.743+00:00
msrini-MSFT
9,291
Reputation points Microsoft Employee
1 answer
Azure SQL Firewall opening for Azure SSIS IR ?
In Azure Datafactory , When azure SSIS-IR has to access Azure SQL db, then should be allow the Azure SSIS IR's IP in Azure SQL . How can we know what is the IP of Azure SSIS IR in West Europe. Is it one IP or multiple IP's. Please help
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,639 questions
asked 2021-04-30T15:49:19.177+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(96, 71%, 19%)' 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)
MS Techie
2,751
Reputation points
commented 2021-05-04T21:35:21.377+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, 9%, 23%)' 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)
KranthiPakala-MSFT
46,642
Reputation points Microsoft Employee
Moderator
0 answers
how to test the scenario of "Premium and Business Critical service tier zone redundant availability"
Hello I am looking for the test case or testing steps for Premium and Business Critical service tier zone redundant availability before actual deployment. It is the requirement from the customer, who wants to do testing of this scenario. Appreciate…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-04-28T20:59:15.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(201.6, 22%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hiral Shah
141
Reputation points
commented 2021-05-04T16:45:32.5+00:00
Oury Ba-MSFT
20,926
Reputation points Microsoft Employee
Moderator
2 answers
Unable to install external assembly or use aggregate function in Azure SQL Database
Hi All, I am trying to install external assembly in Azure SQL database (not a managed instance). I am unable to find any source or process to install external assembly. Also, I have tried creating a User defined aggregate function but that…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-05-04T07:33:09.64+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(163.2, 20%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGV%3C/text%3E%3C/svg%3E)
Gakhar, Vikas
1
Reputation point
answered 2021-05-04T11:02:22.293+00:00
KalyanChanumolu-MSFT
8,351
Reputation points
1 answer
migrate tde cert to Azure sql mi
Add-AzSqlManagedInstanceTransparentDataEncryptionCertificate is the command to add a tde cert to azure sql mi but I have difficulty of list the TDE cert imported ( I can't see it by using SSMS to the Azure SQL Mi under master-> certificate) how…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
![](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)
4 answers
How to download a DB from Azure to local SQL server
I want to download my DB in Azure to a local SQL server but I cant do it with the BACPAC option, is giving an error: "External references are not supported when creating a package from this platform". Also, i think the bacpac option only…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
![](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(230.39999999999998, 79%, 32%)' 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)
1 answer
One of the answers was accepted by the question author.
Database Mail with Key Vault
Database Mail with Key Vault Hi We are in the process of migrating our on-prem sql to Azure SQL Managed instance. we are using the database mail feature. One of the steps while configuring the Database Mail is creating a database mail account …
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
SQL Server | Other
14,499 questions
asked 2021-04-19T11:27:21.257+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(256, 12%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Biju Mathew
481
Reputation points
accepted 2021-05-03T13:40:29.817+00:00
Biju Mathew
481
Reputation points
4 answers
One of the answers was accepted by the question author.
SQL Server Side Transaction on Azure SQL Database
I currently have an application that is hosted on their on-premises environment. The application is currently connecting to two databases on the on-premises environment. The databases are named DB1 and DB2. I have to move the databases onto Azure. The…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-04-30T19:59:05.307+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(96, 95%, 19%)' 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)
Ankit Rathod
391
Reputation points
commented 2021-05-03T11:40:37.22+00:00
Alberto Morillo
34,671
Reputation points MVP
Volunteer Moderator
2 answers
Zapier Connection Azure SQL
Hello, I want to connect to an Azure SQL database with Zapier. Unfortunately that doesn't work. The IP address or port is incorrect. Does anyone know about Zapier? Many greetings Andrea
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-04-28T12:37:28.87+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(246.4, 67%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Andrea Neubert
1
Reputation point
answered 2021-04-30T16:40:48.29+00:00
Alberto Morillo
34,671
Reputation points MVP
Volunteer Moderator
1 answer
New Azure SQL Server Connection Error
Has anyone received this connection error? A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-04-29T19:08:44.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(131.20000000000002, 64%, 22%)' 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)
JAM00L
1
Reputation point
answered 2021-04-30T03:26:01.357+00:00
Alberto Morillo
34,671
Reputation points MVP
Volunteer Moderator
1 answer
Azure SQL Manageed Instance and Azure Active Directory Domain Services
Can Azure SQL Managed Instance accept the creds from a VM that is associated with an Azure Active Directory Domain Service similar to that of Windows Authentication? See twitter post: https://twitter.com/frugecn/status/1385293955894439936?s=20
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
Microsoft Security | Microsoft Entra | Other
2,597 questions
asked 2021-04-22T18:47:10.127+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, 56.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
Christopher N. Frugé
1
Reputation point
answered 2021-04-29T13:51:12.48+00:00
KalyanChanumolu-MSFT
8,351
Reputation points
2 answers
What happens when Azure SQL Managed Instance reaches 100% storage?
I would like to understand - what happens to Azure SQL Managed Instance when it reached 100% of storage limit ? Question: Are there any automated process that will run on SQL MI to clean up some space ? Currently we are using General Purpose Gen5…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-04-12T10:21:10.057+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(96, 11%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kishore A
1
Reputation point
commented 2021-04-28T18:03:02.94+00:00
Oury Ba-MSFT
20,926
Reputation points Microsoft Employee
Moderator