Azure SQL Server Tutorials
Azure SQL provides an option to encrypt your columns if you are storing 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 it. How to encrypt a column in Azure SQL In this article, you … Read more >>
You must know what is happening in the database if you are a Database Administrator. You need to be aware of the activities going on in the database. Therefore, email notifications can help a lot in monitoring database activities. You can define a notification email triggered when a specific action triggers in the database. How … 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 achieve this. How To Reset Azure SQL Database Password Let us discuss all the approaches individually. Approach-1: Using Azure Portal To reset Azure SQL database password, follow the below … Read more >>
In this Azure SQL blog, I will share my incident when I got this error: “Cannot open server requested by the login. Client is not allowed to access the server“. Cannot open server requested by the login. Client is not allowed to access the server Recently, I was working with the Azure SQL database. I created … Read more >>
Recently, my team was required to migrate an SQL Server database to Azure SQL using the Azure database migration service. We analyzed the requirements and performed the complete steps to do this. In this article, you will learn how to migrate your SQL Server database to an Azure SQL database using Azure Database Migration Service. … Read more >>
Azure SQL has many advantages over the on-premise or local SQL Server instance. For example, high availability, security, and reliability. You may want to migrate your SQL Server database to Azure cloud if you wish to use these facilities. Migrate SQL Server to Azure SQL database Let us discuss all the approaches individually. Approach-1: Using SQL … Read more >>
In this Azure SQL tutorial, I will explain how I encountered the error “cannot drop schema because it is being referenced by object” and how did I resolve it. Cannot drop schema because it is being referenced by object I was trying to delete a schema in Azure SQL database using the DROP SCHEMA statement. … Read more >>
In this Azure SQL tutorial, I will explain what are schemas and how to manage them in an Azure SQL database. I will explain how you can create, view, alter and delete a schema in the database. I will create and explain multiple examples of managing schemas in an Azure SQL database. What is schema … Read more >>
In this Azure SQL tutorial, I will share how I resolved the error Cannot bulk load because the file could not be opened. Operating system error code (null). Cannot bulk load because the file could not be opened. operating system error code (null) Recently, when I was working with the BULK INSERT statement in the … Read more >>
In this Azure SQL article, you will learn how to view the most recent Azure SQL database query history. The query history of a database means the queries that are recently executed on that database. I will explain various techniques to see Azure SQL database query history. How to view the query history of an … Read more >>
Download A 40 pages PDF And Learn Now.