geohernandez - Journey of a Data Engineer and Data Architect apprentice
  • ABOUT
  • CONTACT ME
  • WORK WITH GEO
    • Data Specialist
    • Speaker Events
    • Resume
  • EnglishEnglish
    • EnglishEnglish
    • EspañolEspañol
ABOUT
CONTACT ME
WORK WITH GEO
    Data Specialist
    Speaker Events
    Resume
English
    English
    Español
geohernandez - Journey of a Data Engineer and Data Architect apprentice
  • ABOUT
  • CONTACT ME
  • WORK WITH GEO
    • Data Specialist
    • Speaker Events
    • Resume
  • EnglishEnglish
    • EnglishEnglish
    • EspañolEspañol
Azure•Azure SQL Managed Instance•Chronicles from the trenches•SQL Server

Setting up an Azure SQL Managed Instance

September 21, 2021 by geohernandez No Comments

As every option available in Azure and particularly talking about SQL, for the classic question about What option is better for me? The classic answer is still valid and this is “It depends”.  Your necessity or your business workload or architectural design would influence in a determinant way with your decision.

In this article, I am going to explain in a sort of step-by-step guide an approach for configuring a new Azure SQL Managed Instance from now in advance called simply SQL MI.  It is so important to distinguish that exist different ways to arrive at the same result, but the most important is to understand the core concepts.

Continue reading
Share:
Soft Skills•Speaking

Book Review – How to speak so people really listen

May 21, 2021 by geohernandez No Comments

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. 

Continue reading
Share:
Chronicles from the trenches•SQL Server 2019•T-SQL

Introduction to Scalar UDF inlining in MS SQL Server 2019

March 1, 2021 by geohernandez No Comments

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.

Continue reading
Share:
Chronicles from the trenches•Data Engineering•Python

An introduction to pathlib module of Python

February 22, 2021 by geohernandez No Comments

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.

Continue reading
Share:
Page 2 of 8«1234»...Last »

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)

© 2022 copyright Geo Hernandez // All rights reserved     Step by Step