As we know in Azure SQL Databases there is no SQL Server Agent, which means we cannot run scheduled tasks through it. However, in Azure SQL Databases we can schedule jobs in many other ways such as using Azure Data... read more
How to encrypt a column of a table with sensitive data
In this article we will describe how to apply encryption to a table column via Column Level Encryption (CLE). We will also mention what we should pay attention to in order to have a smooth transition. CLE is proposed as a solution… read more
How to export / import entire database using bulk copy (bcp) in SQL Server
Very often we will need to transfer records from tables from one system to another. Usually we do this work through a wizard, but there is also another tool in SQL Server, the bulk copy program or otherwise... read more
How we enable auditing in Oracle Database
In this article we will see the steps and options we have to enable auditing in an Oracle Database. Through auditing we can record who and how makes access or changes to... read more
Why partition a table and how to do it in SQL Server
As we know a relational database mainly consists of entities called tables. Arrays have no logical limit to the size they can reach. There are cases when their size can become unmanageable. Where does it begin... read more
How to properly install SQL Server
In this article we will analyze how a new SQL Server installation should be done step by step. In particular we will see the setup for SQL Server 2019. We will also see what we need to have done before starting the installation and... read more
What is Dynamic Data Masking and how do we enable it in SQL Server
In this article we will analyze what Dynamic Data Masking is and what options we have for using it in SQL Server. Dynamic Data Masking is a function whose purpose is to hide the sensitive… read more
How to improve the performance of a query running on an Oracle database (SQL Tuning Advisor)
Many times we will hear that suddenly a query that was running fast suddenly started to run slow or that a query is running very slowly for no reason. The easiest way to find out what is wrong and solve it is with… read more
How can we schedule a Job in Azure SQL Database using Logic App
Let's say that every day we would like to send by email a report from the result of a query in a database. This process in SQL Server is done using SQL Server Agent and Database… read more
