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

Azure SQL database query history2

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

How do I make an Azure SQL database Read Only

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

bulk loading data to azure sql

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