geohernandez
Menu
  • About me
  • Contact me
  • Data Specialist
  • Resume
  • Speaker
  • Speaker Events
Menu

Author: geohernandez

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…

Read more

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…

Read more

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…

Read more

AZ-900: Lessons learned and Cloud perspectives

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

Recently I did the Microsoft Azure Fundamentals exam and passed, nonetheless this experience was totally different from previous exams and certifications earned in the past, and probably many colleagues have felt the same. Let me try to explain to you about my professional context and why I think that this exam is a must for…

Read more
  • Previous
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • …
  • 8
  • Next

Search for articles

Recent Posts

  • List Comprehension and Walrus operator in Python
  • Playing with some Pandas functions and Airflow operators
  • Using interpolated format strings in Python

Categories

  • Airflow (1)
  • Azure (5)
  • Azure DevOps (2)
  • Bash script (1)
  • Blog (1)
  • Cassandra (3)
  • Chronicles from the trenches (24)
  • Data Engineering (6)
  • DB optimization (2)
  • Events (2)
  • GIT (1)
  • MySQL (1)
  • Python (7)
  • SQL Saturday (1)
  • SSIS (2)
  • T-SQL (5)
  • Uncategorized (1)

Archives

  • August 2023 (1)
  • June 2023 (1)
  • December 2022 (1)
  • November 2022 (1)
  • July 2022 (1)
  • March 2022 (1)
  • September 2021 (1)
  • May 2021 (1)
  • March 2021 (1)
  • February 2021 (3)
  • December 2020 (1)
  • October 2020 (3)
  • September 2020 (1)
  • August 2020 (1)
  • January 2020 (1)
  • August 2019 (1)
  • July 2019 (1)
  • June 2019 (1)
  • May 2019 (1)
  • April 2019 (1)
  • March 2019 (1)
  • November 2018 (3)
  • October 2018 (1)
  • September 2018 (1)
  • August 2018 (2)
© 2023 geohernandez | Powered by Minimalist Blog WordPress Theme