Azure SQL Server Tutorials
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 In this section, I will explain how to create … Read more >>
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 >>
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 Azure SQL has three types of databases: You can know more about these on the … Read more >>
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 >>
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 password Azure SQL database from Azure portal Using the Azure portal for managing Azure resources is very convenient. You can … Read more >>
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 Recently, when I was trying to create a backup of my local SQL Server database on an Azure blob container, I faced the error “Cannot … Read more >>
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 >>
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 >>
In this Azure SQL article, you will learn how to create a table in the Azure SQL database. We will discuss multiple ways that you can use to create a table in an Azure SQL database. Also, we have created some examples so that you can understand the concept better. Create table syntax in Azure … Read more >>
In this Azure SQL tutorial, we will discuss the topic “Azure SQL rename database“. We will discuss how to rename the database in Azure SQL. Can we rename Azure SQL database Azure SQL rename database Rename Azure SQL database using PowerShell Azure SQL rename database portal Can we rename Azure SQL database We can rename … Read more >>