Azure SQL Database - Matt Mansoomi (Page 2)

Matt Mansoomi

Azure SQL Database

All issues related to Azure SQL Database and Managed instance. I am trying to explain how to solve the common issue like connectivity issue or anything related to backup, failed over and other functionality.

Bulk load from selected virtual networks blob storage to Azure SQL Server

Bulk load from selected virtual networks blob storage to Azure SQL Server

I posted before about how to bulk load JSON or CSV file from Blob storage to Azure SQL Database, for that case the storage account was public, that means the storage account was enabled from all networks, you can check or change that setting from Storage Account then Networking, like

Bulk load data from JSON file from Blob storage to Azure SQL Database

Bulk load data from JSON file from Blob storage to Azure SQL Database

Bulk load from JSON or CSV files from Azure SQL Blob to Azure SQL Database is a common scenario, I want to show you how you can import data from Azure SQL Blob. Step1 -Create Master Key If that’s first time you need to create Master Key, As Microsoft

Grant SQL managed identity to Storage Blob Data Contributor role

Grant SQL managed identity to Storage Blob Data Contributor role

In some scenarios like this you need to grant SQL managed identity Storage Blob Data Contributor role on the Storage account, for doing this you need to create the storage account first, then from the left blade choose “Access Control (IAM)” and “Add role assignment” like the below screenshot. From

Restore Managed Instance database with Power Shell

Restore Managed Instance database with Power Shell

This week I got customer for somehow needed to restore the Managed Instance database with Power Shell, He asked the help as they got issue with restoring database with Power Shell, it seemed every time they got different error messages with new command, the errors were like: Restore-AzSqlInstanceDatabase: Cannot bind

Not able to restore SQL Database with PITR?

Not able to restore SQL Database with PITR?

Last week when I tried to restore the SQL database with PITR I got the following error message in Azure Portal. { "status": "Failed", "error": { "code": "InternalServerError", "message": "An unexpected error occured while processing the request. Tracking ID: