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.…
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.
database migration assistance
In the Source sql server name, only default port 1433 is allow ?? where to specify the port and instance name ?
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…
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…
![](https://techprofile.blob.core.windows.net/images/6ac6d5cce09942beb1e4016b6deb8ccc.png)
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…
![](https://techprofile.blob.core.windows.net/images/6ac6d5cce09942beb1e4016b6deb8ccc.png)
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: 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…
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…
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…
![](https://techprofile.blob.core.windows.net/images/REvKe9i1Lk-IL_Eoahe21Q.png?8D8768)
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…
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…
![](https://techprofile.blob.core.windows.net/images/6ac6d5cce09942beb1e4016b6deb8ccc.png)
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 ,…
![](https://techprofile.blob.core.windows.net/images/f3a7f4ee4f8f40d691a550d3840b0327.png)
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 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…
![](https://techprofile.blob.core.windows.net/images/6ac6d5cce09942beb1e4016b6deb8ccc.png)
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…
![](https://techprofile.blob.core.windows.net/images/6ac6d5cce09942beb1e4016b6deb8ccc.png)
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…
![](https://techprofile.blob.core.windows.net/images/6ac6d5cce09942beb1e4016b6deb8ccc.png)
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
![](https://techprofile.blob.core.windows.net/images/6ac6d5cce09942beb1e4016b6deb8ccc.png)
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…
![](https://techprofile.blob.core.windows.net/images/SbBXW6wumkK4XgZSyURk4A.png?8D926C)
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