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.

Azure SQL Database

How to create the Custom Policy in Azure

I did not have a chance to work on Custom Policy in Azure, Thanks one of the clients that came to me with error message that they could not deploy / modify one their database. From the Activity logs we observed the error message like ‘Policies attempted to append some fields

Azure SQL Database

Azure SQL database export stuck at pending

The customer is getting stuck with exporting Azure SQL Database, they tried from Azure Portal and SSMS however after a few hours there was not any progress. We checked all considerations that Microsoft has mentioned here Export a database to a BACPAC file - Azure SQL Database & Azure SQL

Elastic job

Conflict once creating elastic job agent

I explained about elastic job agent earlier and how we use that to create SQL Job in Azure, I experienced new issue related to creating elastic job agent recently, once the user tried to create this after a minute he got “Conflict” error message and could not find more details.

Audit

How to enable Auditing for Azure SQL Database

In many scenarios enabling Auditing could help DBA to find the root cause or protect their databases. For most companies Auditing is a “Must”! it could track who login to the database, which user modify the data and so many other benefits. I highly recommended to enable it if you

Restore Azure SQL Database

Prevent to delete the database or server

It might be easy to answer this question, can we restore an SQL Server database in Azure if we delete the server? Microsoft here answer this question,  If you delete a server, all its databases are also deleted and can't be recovered. You can't restore a

Elastic job

How to create SQL Job in Azure SQL Database

As you know with creating the SQL Job you’ll be able to schedule and run statements and T-SQL commands whenever you want, housekeeping and rebuilding the index are good examples as you don’t want to run these kind of commands during the business hours but do you know

External table

Create external table in Azure SQL Database

External table has some great beneficials in different cases, one of the important scenario is with external table you’ll be able to run query in multiple databases. As you know in Azure SQL server you only can run the query for the database that you connected, it means the

planned maintenance

Change the planned maintenance time for Azure SQL and MI

As you’re aware one of the adventures of PaaS is the user doesn’t need to do anything for maintenance. Cloud service provider in our case Azure will do all patching and maintenance for you! Planned maintenance event keeps Azure SQL Database and Azure SQL Managed Instance services secure,

managed identities

Connection issue for User Assigned Managed Identity (UMI)

Let me start with managed identities in Azure, Azure AD supports two types of managed identities: · system-assigned managed identity (SMI) · user-assigned managed identity (UMI) You can create managed identity users from Managed Identities, I'll explain all steps later in seprate post. There are several benefits of user-assigned managed

Copy Azure SQL Database

How to copy a database between subscription

I already talked about SQL Package which is a great way to export/import database, we can use that for some purposes like copy database between subscriptions and tenants. In this post I want to share another way with T-SQL command that also Microsoft explains that here perfectly,  Copy a

Access to database

How to create and check AAD Login in Azure SQL Database

If you want to create AAD login for Azure SQL Database firstly be aware that you have to create AAD users with Azure Active Directory Admin, That means you’re not able to create AAD Logins for your database when you use a SQL Login. USE statement is not supported

Login Failed

User is not able to access the database master

Creating the user account and get permission to the user is one of the day to day task for database administrator. The user told me they got issue when their end user trying to connect to the database, they got the following error message, also they mentioned they’re pretty

Copy Azure SQL Database

How to copy Azure SQL Database between tenants or subscriptions

You have a massive database in one subscription or tenant, and you need to copy the database to another subscription/tenant.  As here also explains The Azure portal, PowerShell, and the Azure CLI do not support database copy to a different subscription. You can use T-SQL if only using a

Connection Issue

Port being blocked for Azure SQL Database

The user got the following error message when try to connect to Azure SQL Database from their Virtual machine, they said they already set the firewall, the user has access to the database and etc but they confused with this error message. A network-related or instance-specific error occurred while establishing

Connection Issue

Connect to Azure SQL Database from Azure or outside of Azure

In this post I want to talk about connectivity to Azure SQL Database, that’s one of the most common issues that normally users have. In this post I cover Public IP address and how we can access to Azure SQL Database from Azure VM or our of Azure environment.

Restore Azure SQL Database

Change time zone for Azure Database or Manage Instance?

When you want to restore any database in Azure like other activities you need to choose the time based on UTC and sometimes that’s a bit confusing for users depend on their local time zone. The question is do we have any option to change time policy on Azure

Export

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.

Index

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

Firewall

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

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

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

CDC

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

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

Blob storage

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

Blob storage

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