Azure SQL Server Tutorials
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 >>
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. Introduction In real-time scenarios, you have a primary database and … Read more >>
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 importing or bulk loading means importing a large amount of data from a file into a database. If you encounter the … Read more >>
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 The Python library you need to connect … Read more >>
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 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 >>
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 >>