Chronicles from the trenches

Looking back to Kimball’s approach to Data Warehousing

Over time, it's fascinating to witness how certain concepts, approaches, or visions age. Time, in its inexorable flow, often brings…

1 year ago

Playing with some Pandas functions and Airflow operators

Recently, I was dealing with a task where I had to import raw information into a staging PostgreSQL Database as…

2 years ago

Using interpolated format strings in Python

The release of Python 3.6 came with exciting functionalities. I want to speak about the feature called interpolated format string…

2 years ago

Getting the last modified directory with Python

Working with os paths is a prevalent task, especially when working on a console application in Python. Recently, I had…

2 years ago

First steps for configuring SQL Server with Docker

Sometimes, our working habits could experiment some interesting changes, maybe forced by real needs or even simply for the valid…

2 years ago

Database Migration Service – We do not have sufficient capacity for the requested VM size in this region

As the title of this post indicates, the Database Migration Service (DMS) could experiment with problems in very rare cases…

3 years ago

Setting up an Azure SQL Managed Instance

As every option available in Azure and particularly talking about SQL, for the classic question about What option is better…

3 years ago

Introduction to Scalar UDF inlining in MS SQL Server 2019

Historically the use of User Defined Functions aka UDF has represented a great option to encapsulate logic into Database reusable…

4 years ago

An introduction to pathlib module of Python

First at all, I would like to clarify something that maybe sounds evident, but sometimes we forget, the path is…

4 years ago

Solving drop database error: can’t rmdir in MySQL

Sometimes, the only thing that we want is to drop a database(not in PRODUCTION) and recreate it from scratch, especially…

4 years ago