Not able to connect from my Local Visual Studio 2022 to Azure SQL Server
Azure provided this connection string for ADO.NET: Server=tcp:jeanjhskyblue.database.windows.net,1433;Initial Catalog=MEDISEABLUE;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication="Active Directory Default"; when…
Need help to restore sql backup
I’m trying to restore my db and i read if it’s before 7 days we can get but! It’s been more than 7 days can anyone help me to get that back’
SQL Database export
How to export and download exported database?
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Alerts in Managed instance
Hi I am looking at setting up alerts on the managed instance based of https://learn.microsoft.com/en-us/sql/ssms/agent/create-an-alert-using-an-error-number?view=sql-server-ver16 where it states it applies to MI However I encounter error. I need to…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Creating Certifcate Or Symmetric key Over Azure Managed Instance with Entra Service principal
Hi Team, We are connecting a database over Azure SQL Managed Instance from our C# application. We need to create Symmetric-Key/Asymmetric-Key/Certificate with TSQL statement.
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Trying TDE CMK with Azure key vault
CREATE ASYMMETRIC KEY EKMSampleASYKey FROM PROVIDER [AzureKeyVault_EKM] WITH PROVIDER_KEY_NAME = 'keyname', CREATION_DISPOSITION = OPEN_EXISTING; throwing the below error Key with name 'keyname' does not exist in the provider or access is denied.…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Impact of Increasing Storage and Cores for Azure SQL Database in Business Critical Tier
Hi Team, What is the impact of maximum storage size for Azure SQL Database within the Business Critical service tier. we are currently using a Business Critical configuration with 8 cores and 2TB of storage, and plan to increase it to 12 cores and 2.5TB…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Issues with mi IP address
Hi guys. I am doing a course about Azure and I was checking the section to connect a Blob Storage to SQL Database. When I was setting up my Firewall rules, the first issue I found was that Azure didn't recognize my IPv4 but IPv6 instead so I have to…
![](https://techprofile.blob.core.windows.net/images/5kfUQwbXfkqnY7o5wQqfdA.png?8DAA55)
Failed to save 'sql servers on machines' plan for subsribtion 'N/A'
Trying to turn off Azure Defender for Cloud but have error: How to do it successfully ?
Workday and alternative
Hi, I have a table which needs to duplicate with weekday and alternative create table table3 ( col1 varchar(20) , col2 varchar(20)) expected results Insert into table1 values('catch', 'catch1') …
How to replace Data flow activity having transformations inside it in ADF with other activity.
I have Azure data factory pipeline which have data flow activity. Data flow activity points to source file in storage account gets data from it as a source then performs different transformations on data using conditional split, derived column, flatten…
Microsoft Applied Skill 4 - Failure to create Databases 1-4
While attempting the "Migrate SQL Server Workloads to Azure SQL Database" it failed to create Databases: DB1, DB2, DB3, and DB4. While DB5 was a partial. Has anyone else had this happen to them? What steps have you taken to resolve this…
sp_invoke_external_rest_endpoint returns json parse error on @response
i am running azure sql and call various MS graph and external rest endpoint via Azure API manager using the sp_invoke_external_rest_endpoint procedure. On 1 instance calling the proc, I get the following error returned: Msg 11558, Level 16, State 202,…
how to add user assigned managed identify in azure sql database using powershell?
how to add user assigned managed identify in azure sql database using powershell? I tried two methods as follow and they didn't work. 1.add parameter userassignedidentityid when create az sql database . # Create Azure SQL Database $databaseName =…
How to install SQLPackage and Powershell on Windows Azure Agent
Hello, I have a windows Azure Agent which has been setup by our Azure Admin team. The agent does not have the SQLPackage and Powershell installed on it which is required for SQL DACPAC file generation. As part of my release pipeline I am using a…
Getting Azure Synapse Analitics Tables Size - Query on documentation does not return correct data
Hello, I've a Synapase Workspace with a Sql Pool that has a SQL Server version 12.0.2000 . My requirement is to get the phisical space storage for each table in my database. Many peoples pointed me at…
Azure SQL Managed Instance Scaling Both Primary & Secondary
I have two SQL Managed Instances, one is using it as the primary and the other one is for secondary-geo replication . At the moment both of them have the same specs (Service Tier - Hardware Generation- vCore - Storage), I would like the scale up the…
Delete data from an Azure SQL database after copyingit to an Azure Blob
How can I create a pipeline in ADF to delete data from an Azure SQL database after copying it to an Azure Blob, without using the copy or lookup activities to execute the query? I need to create a view and perform some activity. Is there a custom method…
System Database Backups for Azure SQL Managed Instance
I don't see the ability to backup system databases for Azure SQL Managed Instance. If the server was lost I would lose server logins, backup information. Is there any documentation regarding why we don't have to backup these databases, and the steps we…
Retention period for various DMVs such as sys.dm_db_resource_stats, sys.dm_os_wait_stats
I want to understand retention period for various DMVs (Dynamic Management Views). I specifically want to know the retention period for DMVs such as sys.dm_db_resource_stats, sys.dm_os_wait_stats, sys.dm_database_replica_states,…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)