Azure SQL database column encryption

Azure SQL Server column level encryption

Azure SQL provides an option to encrypt your columns if you are storing any sensitive data in the database such as user passwords, credit card numbers, etc. You can use any encryption algorithm to encrypt the data and only authentic users can decrypt this data. In this article, you will learn how to encrypt the …

Read more

Configuring email notifications in Azure SQL database

send email from azure sql database

If you are a Database Administrator, you always need to know what is happening in the database. You need to be aware of the activities going on in the database. Therefore, in order to monitor activities in the database, email notifications can help a lot. You can define a notification email that will be triggered …

Read more

Create stored procedures in Azure SQL database

Create stored procedure template for Azure SQL database

This Azure SQL article will help you to get familiar with stored procedures in an Azure SQL database. We will explain how to create stored procedures in an Azure SQL database with the help of some examples. How to create stored procedure in Azure SQL database Create stored procedure template for Azure SQL database Azure …

Read more

Azure sql password validation failed

Azure sql password validation failed

In this Azure SQL tutorial, I will explain the error ‘Password validation failed. The password does not meet policy requirements because it is not complex enough.‘ Recently, I was trying to change my user password in the Azure SQL database. I was using SQL Server management studio to connect to my Azure SQL database. I …

Read more

Migrate SQL Server to Azure SQL database

Migrate SQL Server to Azure SQL database

Azure SQL has many advantages over the on-premise or local SQL Server instance. For example, high availability, security, and reliability. If you want these facilities, you may want to migrate your SQL Server database to Azure. Introduction to Azure SQL Migrate SQL Server to Azure SQL database Migrating from SQL Server to Azure SQL database …

Read more

How to create SQL authentication user in Azure SQL database

Azure SQL create user and login

When you create an Azure SQL database, a default administrator user is created. This user has all the administrative rights and can manage the SQL server and the databases as an administrator. However, you also need to create more users to manage access to the database. We use multiple users with different authorization levels and …

Read more

Reset Password Azure SQL database

change password azure sql database

You may have faced scenarios when you need to change the password of your Azure SQL database. In this article, we will explain various ways to change the administrator password of your SQL database. Reset admin password Azure SQL database from Azure portal Reset admin password Azure SQL database using powershell Change Azure SQL database …

Read more

Cannot open backup device operating system error 50 azure

Cannot open backup device. Operating system error 50

In this blog, I will explain how I managed to resolve the error “Cannot open backup device. Operating system error 50”. Cannot open backup device operating system error 50 azure Reason: Cannot open backup device. Operating system error 50 Solution: Cannot open backup device. Operating system error 50 Conclusion Cannot open backup device operating system …

Read more

Backup and restore SQL Server to Azure Blob storage

restore sql server from azure blob storage

Microsoft Azure provides storage services, where you can store any kind of data. You can also take a backup of your database in the Azure storage. In this article, you will learn how you can backup and restore SQL Server to Azure Blob storage. How to create a storage account in Azure SQL Server backup …

Read more

Backup Azure database to local SQL Server

backup azure sql database to local sql server

In this Azure SQL tutorial, we will discuss how to backup Azure SQL database to local SQL Server. Microsoft Azure provides a backup facility to backup your Azure SQL database. But sometimes you may want to take a backup of your Azure SQL database to your local machine. This article will help you to achieve …

Read more