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 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
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
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
How to install SQL Server on Linux via Docker
In a previous article we saw the installation of SQL Server 2019 on Red Hat Enterprise Linux. In this article we will see how to install SQL Server 2017 again on RHEL but with only 1 core and 1GB Ram... read more
