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

Month: November 2018

Implementing CTE for filling gaps inside a sequence

Posted on November 15, 2018March 13, 2019 by geohernandez

This is the second article of a series dedicated to implementing Recursive Common Table Expression in different kind of scenarios, and this time I will address another use case; it basically consists in filling gaps inside a sequence of an incomplete range of dates.  I would like to comment that the next example has been…

Read more

Using recursive CTE for generating a specific number of rows

Posted on November 8, 2018November 15, 2018 by geohernandez

I remember the first time that I discovered the amazing feature called Common Table Expression (CTE), it was during my first read of Itzik Ben-Gan book (T-SQL Querying), maybe one of the most interesting feature together with Windows Functions.  I know, I am a declared fan of CTE, but we can start defining a CTE as…

Read more

Soft skills and Why we must improve them

Posted on November 1, 2018November 1, 2018 by geohernandez

The stereotypes are an “easy” and “toxic” way of grouping and split the people, we can find it in every society and it is extended to the professions.  The IT field it is not the exception, in fact, the IT workers profile don’t fit in many of classic “supposed to be” and being realistic, the…

Read more

Search for articles

Recent Posts

  • Using interpolated format strings in Python
  • Getting the last modified directory with Python
  • First steps for configuring SQL Server with Docker

Categories

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

Archives

  • 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