Azure SQL Database
An Azure relational database service.
6,346 questions
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…
Azure SQL Database
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…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
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…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
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
![](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
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…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
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,351
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…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,379 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,653 questions
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,146
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…
Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,662 questions
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
928 questions
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
Moderator
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…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
Azure Policy
Azure Policy
An Azure service that is used to implement corporate governance and standards at scale for Azure resources.
1,019 questions
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
![](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,631
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…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
Azure Database for MariaDB
Azure Database for MariaDB
An Azure managed MariaDB database service for app development and deployment.
64 questions
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 ,…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,503 questions
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,406
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
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
SQL Server | Other
14,503 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(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…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
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…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
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…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
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
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
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…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
Microsoft Security | Microsoft Defender | Microsoft Defender for Cloud
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
27,221
Reputation points Microsoft Employee
Moderator
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
Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,662 questions
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
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
361
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
0 answers
HTTP 500 error after deploy split-merge tool
I deployed the split-merge tool to test the movement of data between shards, I followed every step of this manual 1: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-configure-deploy-split-and-merge. But although azure shows the…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
asked 2020-08-28T05:39:23.06+00:00
Roque, Mairelin
6
Reputation points
commented 2020-08-31T10:53:22.963+00:00
Anurag Sharma
17,631
Reputation points
1 answer
Using newsequentialID for GUID columns in Azure SQL DB
Dear Experts, I have this Azure SQL DB and I can see few tables that have their ID column using the uniqueidentifier column. Also, these tables have the primary key clustered defined on this ID column which is leading to heavy fragmentation. The plan…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
1 answer
One of the answers was accepted by the question author.
How to connect to SQL Database server using MFC CDataBase object
Hi Team, I have a project with MFC where they are connecting to the SQL server using the class CDatabase and CRecordset. At present i am using DSN as the part of the connection string. Now i want to establish the connection using the CDataBase…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
asked 2020-06-30T11:28:43.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(92.8, 61%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Darsi, Sanjay Kumar
41
Reputation points
accepted 2020-08-28T08:44:54.073+00:00
Darsi, Sanjay Kumar
41
Reputation points
1 answer
Azure : SSRS Report Server : Image files bulk upload
Hello, I have created azure release pipeline to upload files, and looking solution to bulk upload .png files on report server. In a release pipeline, the SSRS task can upload only .rdl files, not .png. It gives MIME type error. Could you please…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,346 questions
SQL Server | Other
14,503 questions
asked 2020-08-21T00:24:19.433+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(54.400000000000006, 54%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAU%3C/text%3E%3C/svg%3E)
Ajay Unecha
1
Reputation point
commented 2020-08-28T07:34:38.637+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, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT
14,006
Reputation points Microsoft External Staff