Matt Mansoomi

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

Managed Instance

Connect to Managed Instance with Public End Point

If once you tried to connect to managed instance, you got the below error message, this post might help you to fix the issue. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance

How enable zone-redundant for Azure SQL?

I got a customer with the below question regarding zone-redundant configuration for Azure SQL Database. “Is availability zone support in Azure East region and if so, how do I configure it for Azure SQL Database? Do we need to enrol for preview?” Firstly, if we check Microsoft Public documents it’

Cost Saving in Azure

Don’ not see Start stop button in managed instance?

Microsoft had an awesome news in November 2022 for those who use managed instance. You can stop/start instance from Azure Portal or PowerShell. That’s a huge change as you can save on billing costs when you're using Azure SQL Managed Instance. See all details here. As

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

create Managed Instance

Quota limitations for SQL Managed Instance

Last week I worked on a new issue, the customer was not able to create Managed Instance, they got this error message: Managed Instance is not available for the chosen subscription and region. Please try again with some other subscription or use Microsoft Support to request region access. Limitation for

Restore Database

Restore managed instance database from blob storage

Let’s assume you already configured your managed instance, and you got access to the server with SSMS, now you want to restore your first database from Azure blob storage to MI. It’s very straight forward process, for restoring database to managed instance you have several methods but in

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

Book

Overcoming Mood Swings by Jan Scott

Recently I’ve finished “Overcoming Mood Swings” and I want to put some highlights from the book here, it helps me to review what I learn and also could be helpful for those who want to read this. Overcoming Mood Swings self-help manual for those who have experienced mood swings

Virtual Machine in Azure

Common VM connection issue

I am not a network guy however for most of us with any IT background having a Virtual machine is a great thing, if you’re a developer, database admin etc you might need to have VM to do your part. Typically, you choose a virtual machine when you need

Escalation engineer

One year in Microsoft as an Escalation engineer

working in Microsoft as an Escalation engineer I started my role in Microsoft as an Escalation engineer last year, I am proud of myself to work in such a great company. Before this, I also worked on SQL Server as database administrator also used to work with customers for so

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.

Virtual Machine in Azure

How to create your first VM in Azure in 10 steps!

In this post I want to show you how you can create the Virtual Machine in Azure step by step. You can do that with wizard or different methods however I wanted to create every single item separately. That helps us to see how we can configure VM. 1- Create

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