Databases

Welcome to a new article on the Aleson ITC Blog. In today’s post we are going to talk about the end of the extended support that Microsoft gives to the 2014 version of SQL Server. How does Microsoft’s fixed lifecycle policy and SQL Server support Read More

Welcome to a new article on the Aleson ITC Blog. In today’s post we are going to talk about performing a relational migration to No SQL Nowadays there are very reasons to migrate from a relational database, such as MySQL, Oracle, PostgreSQL or our always Read More

Welcome to a new article on the Aleson ITC blog. In today’s article we will show you how to search queries without parameterization in Query Store. Recently we had a problem on a production server of one of our customers. This problem was related to Read More

In this series of 3 posts about PostgreSQL we are going to see how to migrate our PostgreSQL On-Premise server to Azure. In this first post we will create our Azure Database for PostgreSQL – Flexible Server and configure it to be accessible from pgadmin. Read More

Welcome to a new post in Aleson ITC’s blog. Usually we find operations that penalize the performance of the MongoDB server but are not easily detectable. That is why in this post we will see how to work with profiler in MongoDB and its usefulness. Read More

Welcome to a new post on the best Data & AI blog. In today’s article, we will talk about one of the most important new advantages of SQL Server 2022. En concreto, estamos hablando de “Parameter Sensitive Plan” o PSP, que forma parte de una Read More

Hello! Welcome and welcome to a new post in the best Data and Cloud blog. In today’s article we will talk about how to backup to Azure with pgbackrest in Postgre SQL. But first, let’s talk a little about what PGBackrest is and what its Read More