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
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 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
What is Query Store and how we use it in SQL Server
Query Store appeared from SQL Server 2016 onwards. It is a tool provided so that we can track each query in the database. Through the Query Store we can see a query... read more
How do we find the size of a database over time in SQL Server?
Very often we will need to make an estimate of the space that a database will need in SQL Server in the future. To do this we need to know the growth rate of the space used by the database. Where… read more
How can we bulk backup/restore databases in SQL Server
Many times we may need to backup several small databases and transfer them to another system or restore them to the same one. The backup/restore process of each database one by one will be time-consuming and... read more
What are the differences between MDX and DAX queries?
They are both expression languages used for data analysis in Power BI, Excel and Analysis Services. If we would like to answer our question with a sentence, MDX (Multidimensional Expressions) you use to analyze multidimensional… read more
