Azure SQL Database
An Azure relational database service.
5,572 questions
1 answer
One of the answers was accepted by the question author.
Azure Web App Slowness
Total noob here. Ported over an asp.net webforms / sql server application for testing. I went with the most basic sql database and web app. With the above selected basic options, the performance is unacceptable compared to my current hosting service.…
asked 2020-09-02T15:28:17.55+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, 72%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Geoff Campbell
21
Reputation points
accepted 2020-09-07T21:49:31.823+00:00
Geoff Campbell
21
Reputation points
1 answer
Need powershell command to list database backup status of SQL database running in Azure virtual machine
Hi, I need a powershell command/Script to list the last database backup status and date of SQL agent running on the Azure virtual machine.
asked 2020-08-31T12:04:51.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(83.2, 28.999999999999996%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
keerthy ganesh
6
Reputation points
commented 2020-09-07T09:14:13.983+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,321
Reputation points
1 answer
database migration assistance
In the Source sql server name, only default port 1433 is allow ?? where to specify the port and instance name ?
asked 2020-09-04T19:02:08.697+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,326
Reputation points
answered 2020-09-07T09:02:00.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(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,606
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS CSV Loading issue
I am looking for a C# solution to use a script task in SSIS so that I can load multiple csv files to SQL Tables Now If I use a data flow task, then I have to create 1 DFT per file as each file has a different metadata ( unless there is some other…
![](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, 72%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
1 answer
Could Azure SQL Database auto created and set as provisioned?
Noticed that I was going to get a large bill, which links to Azure SQL Database being setup as provisioned 32GB allocated. gen 5 with 2vcpu. Any other instances of Azure starting database around 30th Jul 2020 as provisioned? I don't recall touching…
asked 2020-09-03T14:07:04.437+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, 25%, 36%)' 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)
matt Aze
1
Reputation point
commented 2020-09-04T17:49:59.64+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Azure Compute Utilization doesn't match database CPU consumption
When I view my compute utilization graph and compare it to the database performance graph (even after using 'drill into logs/performance') I can't figure out why the DTU percentage is so high. I'm experiencing intermittent connection lag with…
asked 2020-09-03T08:52:36.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(89.60000000000001, 41%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Cliff Cawley
96
Reputation points
commented 2020-09-04T17:47:26.533+00:00
Mike Ubezzi
2,776
Reputation points
0 answers
Are there any differences in data type in an Azure SQL Server DB for fields stored in Blob storage (already connected) or is it all connected by default?
I am trying to store videos and images efficiently in my SQL Server DB (on Azure). I set up the Azure SQL Server DB, and I linked it to Blob Storage. Are all fields stored in Blob storage by default, or is there something I need to specify in the…
asked 2020-08-29T23:21:21.593+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, 34%, 34%)' 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)
Matthew
1
Reputation point
commented 2020-09-04T10:46:28.477+00:00
KalyanChanumolu-MSFT
8,321
Reputation points
0 answers
Azure Sql Database: Error when trying to restore from long term retention restore
Hi, I'm trying to restore from long term retention backup. But it is failing without giving me much of an error message. This is all I'm getting: "Error restoring SQL database with long term retention Restoring SQL database with long…
asked 2020-08-28T17:58:52.357+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(140.8, 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' %3EBW%3C/text%3E%3C/svg%3E)
Ben Wong
6
Reputation points
commented 2020-09-04T10:44:23.16+00:00
KalyanChanumolu-MSFT
8,321
Reputation points
0 answers
How to copy data from Azure SQL Database to Azure Synapse?
Hello Experts, I am pretty new to Azure Data Factory and struggling with a simple problem. I've done this in SSIS but now trying to implement the same in Azure Data Factory. I have a list of tables that I would like to copy the data on an incremental…
asked 2020-08-30T16:39:04.32+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(220.8, 19%, 31%)' 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)
Julaayi
1
Reputation point
commented 2020-09-03T04:43:02.267+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(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
Applications in Azure how connect to onpremise monitoring software
Dear All, We are moving an application (database, new IP in azure) to Azure from on-premise which uses on-premise exchange 2019. When the database is down the monitoring software detects it and sends an email to exchange which in turn fires an email to…
asked 2020-08-30T09:51:03.193+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(156.8, 7.000000000000001%, 25%)' 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)
Azurebegginer
146
Reputation points
commented 2020-09-02T08:56:25.1+00:00
tbgangav-MSFT
10,426
Reputation points
0 answers
Need help to build a policy to deny sql database that has Transparent Data Encryption disabled
there is a build-in azure policy name "Transparent Data Encryption on SQL databases should be enabled" With definition ID: /providers/Microsoft.Authorization/policyDefinitions/17k78e20-9358-41c9-923c-fb736d382a12 But this policy only…
asked 2020-08-21T21:04:13.817+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, 59%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Hoang Nguyen
1
Reputation point
commented 2020-09-02T07:35:50.87+00:00
Anurag Sharma
17,606
Reputation points
1 answer
SQL Server ColumnStore indexes
Recently I did a POC with column store databases. I used Maria DB ColumnStore database storage engine and SQL server's column indexed on Azure. I had around 38 GB's of sample data to query upon. I wrote close to 45 test cases (with queries). Some of the…
asked 2020-08-26T09:15:19.623+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, 51%, 14%)' 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)
Deepak2610
6
Reputation points
answered 2020-09-02T06:05:47.29+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
One of the answers was accepted by the question author.
Query to find list of all primary keys and check if they are clustered and if they are on uniqueidentifier column
Dear Experts, I have this requirement to query all the tables in my database to check if the tables have clustered indexes on the primary key and if the key column is an uniqueidentifier. I prepared this script below select o.name as TableName ,…
asked 2020-09-01T11:16:02.677+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, 54%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
mo boy
396
Reputation points
commented 2020-09-01T13:01:50.353+00:00
Dan Guzman
9,231
Reputation points
1 answer
Auto Refreshing Data in excel with SQL Database
Hello, Is there a way for me to code my excel workbook that is connected to SQL server to automatically refresh (for example cell A to D) every 1 mins, Friday to Sunday, from 8 am-4 pm, using SQl code, Power query or VBA code. Thanks
![](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(265.6, 60%, 35%)' 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)
0 answers
Azure SQL DB | GRANT VIEW DEFINITION to sys.database_role_members?
Hi Trying to enable view definition on sys.database_role_members Running this query: GRANT VIEW DEFINITION ON OBJECT::sys.database_role_members TO [user]. Get the following error: Granted or revoked privilege VIEW DEFINITION is not compatible…
asked 2020-08-26T13:06:21.373+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(0, 53%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Knall
1
Reputation point
commented 2020-09-01T03:54:23.727+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Data Sync is missing records between On-Premises DB and Azure SQL DB
Hi, I have a data sync group on azure, which is allow me sync on-premised database's data to Azure SQL db. The Direction is Bi-directional, the conflict resolution is Hub Win. Now I have a problem: the azure db is missing 101 records from On-premised…
asked 2020-08-28T14:45:46.78+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, 55.00000000000001%, 10%)' 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)
Cccccche
1
Reputation point
commented 2020-09-01T00:56:17.213+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Free SQL Database for 12 months
Hello, As shown in the 12 months free services of Azure, I find SQL database with a capacity of 250GB. However, when I created an SQL database from portal, I am being shown that I will be charged at least 300 rupees for a month for a basic plan of 5…
asked 2020-08-28T16:29:03.353+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(188.79999999999998, 98%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kartik K
1
Reputation point
commented 2020-09-01T00:53:53.37+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Can we download BPA tool for SQL server 2019 in Azure ?
Hi There, I've to run Microsoft SQL 2019 best practice analyser tool on the SQL install and provide report to the security team . Wanted to know is BPA tool is available for SQL 2019 in Azure platform? Regards, Ken
asked 2020-08-27T06:15:33.717+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(217.60000000000002, 97%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Ken
21
Reputation points
commented 2020-09-01T00:50:36.233+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Vulnerability Scan Timeout
I have a recommendation in the Azure Security Advisor "VA2065 - Server-level firewall rules should be tracked and maintained at a strict minimum" on a number of sql server instances. My understanding of how to remediate these is: Adjust…
asked 2020-08-10T05:10:27.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(99.2, 90%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jim Pelletier
1
Reputation point
commented 2020-08-31T20:41:11.267+00:00
James Hamil
23,976
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
SQL Connection attempts
Hi, How can I see what connection attempts are being made to my Azure SQL Server and where are they coming from (IP address)? Many thanks, JD
asked 2020-06-16T08:52:31.813+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
answered 2020-08-31T15:48:32.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(22.400000000000002, 84%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Alex Hunting
1
Reputation point