Cannot drop schema because it is being referenced by object

Cannot drop schema because it is being referenced by object

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 >>

Azure SQL Database Schema – Complete tutorial

Azure SQL create schema if not exists

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 >>

Azure SQL database query history

MongoDB atlas change user password

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 >>

Read only replica Azure SQL

In this Azure SQL tutorial, we will discuss various aspects of a read-only database in Azure SQL. We will discuss, what is a read-only database in SQL, how to make a database read-only in Azure and vice versa, advantages and disadvantages of a read-only database. Advantages of using read-only replica Disadvantages of using read-only replica … Read more >>

Bulk loading data to Azure SQL

MongoDB update vs updateMany example

In this tutorial, we will learn about bulk loading data to Azure SQL. And we will see various bulk inserting techniques along with some examples. Bulk import and export to Azure SQL database Bulk export using BCP utility Bulk import using BCP utility Bulk insert CSV into Azure SQL database Bulk insert from Azure blob … Read more >>

Connect to Azure SQL database using Python

Python code to connect to Azure SQL database

You can use an Azure SQL database with a Python application. But there are some steps that you need to follow before you can connect your Python application to the database. And we will discuss the following set of topics. Python library to connect to Azure SQL database Python code to connect to Azure SQL … Read more >>

Azure SQL database configure firewall

Deploy and configure Azure firewall using the Azure portal

In this Azure SQL tutorial, we will discuss the Azure SQL database firewall and how to configure it. We will discuss various methods to configure an Azure SQL database firewall. The Azure SQL firewall is a layer of security added to prevent any types of malicious requests. You can allow or disallow any IP address … Read more >>

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 >>