geohernandez – Page 5

Book Review – How to speak so people really listen

Posted on May 21, 2021May 21, 2021 by geohernandez

I must confess that I was not a big fan of management books or those books that help you to improve your soft skills, but I reached a point in my career where I realize potentially miss out on progressing and promotions due to the lack of these soft skills. Nonetheless, primarily I saw myself struggling and delivering projects in a successful way, I have to clarify that this affirmation is based on the feedback of the customers, no delays in the delivery time, and the solution was adjusted to the requirements. However, I could identify as a remarked weakness the way I was delivering my messages during my communication through the project.

Introduction to Scalar UDF inlining in MS SQL Server 2019

Posted on March 1, 2021June 9, 2021 by geohernandez

Historically the use of User Defined Functions aka UDF has represented a great option to encapsulate logic into Database reusable objects, nonetheless, during the implementation of scalar UDF (a variation based on the function’s output) for MS SQL Server we have been suffering painful performance penalties until the arrival of version 2019, so in this article, we are going to address how the new Scalar UDF Inlining feature helps us to avoid performance problems and get the maximum value in our Database code inside SQL Server.

An introduction to pathlib module of Python

Posted on February 22, 2021February 22, 2021 by geohernandez

First at all, I would like to clarify something that maybe sounds evident, but sometimes we forget, the path is not a string, it is a fact that we must keep in mind to avoid headaches in our journey in Python. Since Python 3.4 in advance, we count on a powerful and versatile module called pathlib.

Solving drop database error: can’t rmdir in MySQL

Posted on February 11, 2021February 14, 2021 by geohernandez

Sometimes, the only thing that we want is to drop a database(not in PRODUCTION) and recreate it from scratch, especially when we are in the process of automating the deployment of our MySQL databases, for instance using liquibase. Therefore, it is not uncommon in an initial testing process to wish to drop and recreate our tested database.