In this article we will analyze how we can access tables / views located in a remote Oracle database. To achieve this we need to create an object called Database Link.… read more
How can we store docx, xlsx, jpg, xml, etc. files in a database table? in SQL Server
In SQL Server we have the ability to store files such as Docx, Xlsx, XML, JSON, JPG, PNG etc. in a field of a database table. In this article we will analyze how this is done and how it is done... read more
How can we see the historical snapshot of a table in SQL Server using Temporal Tables (aka Row Versioning)
Coming from the SQL Server 2016 version, SQL Server brought the ability to view a table historically over time. That is, to have a row versioning in the table with the possibility to choose the time we want. read more
What are Columnstore Indexes and when do we use them in SQL Server
In this article we will analyze the difference between a table that is physically stored via a Clustered Rowstore Index and one that is stored via a Clustered Columnstore Index. What exactly are Columnstore Indexes, when should they be used and what are… read more
How to load data into Microsoft Excel from a database using Power Query
Microsoft Excel one of the first Microsoft programs. From its first versions, it had the ability to collaborate with software from other companies. In this article we will explore how to connect Excel to any… read more
How can we get an email whenever an error occurs in the Oracle database Alert log
In a system based on an Oracle database, that an error occurs is recorded in a log file called the Alert Log. It is very useful to be informed immediately when something happens and the most immediate way is no other… read more
How can we do field translation in SQL Server using Python (no API)
Python as a scripting language gives unlimited possibilities for automation. In this article we will see how in collaboration with SQL Server it is possible to translate the entire table field into Greek with one click through google translate. First… read more
How we can schedule jobs on Azure SQL Databases using Elastic Database Jobs
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
