Matt Mansoomi (Page 2)

Matt Mansoomi

Exporting Azure SQL DB is in progress for a few days!

Exporting Azure SQL DB is in progress for a few days!

Today I want to share something about exporting Azure SQL database, it looks simply as it explains here you can go to the database then select Export button on the toolbar then choose the Azure storage account and done! But like other things in technical life, it could be challenging.

Slow Index creation

Slow Index creation

Performance and slowness are a common scenario for database in many companies and organizations, normally it takes time to find out what’s the root cause and what action do we need to take. In my recent case the customer knew what the issue was and asked for some help

Connection issue for DataSync

Connection issue for DataSync

Before this I talked a bit about DataSync and how to troubleshoot some popular errors and issues, A few weeks back I got client with DataSync issue again, basically they got connection issue when tried to sync data, here was the error message: SQLError Number:40532, Message: Cannot open server

How to use JDBC to store and retrieve data from Azure SQL Database

Connection Issue

How to use JDBC to store and retrieve data from Azure SQL Database

I got the new case last week that was kind of new for myself! I am not a Java developer and could only advise about SQL Server, my plan is when I have time do the Java code and test all of these, I’ll try to update here later

SQL Data Sync troubleshooting

SQL Data Sync troubleshooting

SQL Data Sync is an effective method on Azure that allow you to synchronize the data you select across multiple databases, as Microsoft explains here that’s bi-direction and you can use on both on premises and cloud. Sometimes it can be tricky and goes out of sync. I got

How does CDC impact the transactional logs?

How does CDC impact the transactional logs?

I got case that the customer has issue with transaction log in Managed Instance, basically the transactional log increases to 500 Gb! When they checked with sys.log_reuse_wait_desc they found it was waiting on replication but their first question was we have not replication on database. If

Cannot connect to Managed Instance

Connection Issue

Cannot connect to Managed Instance

Sometimes connecting to Managed Instance can be confusing. Lots of things about connection to Azure Managed Instance like Public endpoint, Private endpoint, proxy, redirect and so on! And probably that’s why sometimes users don’t know what’s the issue? I believe if they can have some idea about

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:

How to pass DP900 - Microsoft Azure Data Fundamentals

How to pass DP900 - Microsoft Azure Data Fundamentals

I passed DP 900 exam recently and I wanted to share with you a few tips and how you can pass the exam. If you’re Database administrator, Data Engineer, Data Analyst or any other roles which work with data that’s good place to start! I highly recommend this