Dynamic! Dynamic!

Dynamic is one of my favorite search words. It is the opposite of “static”. A lot of time, SQL statements requires static input, such as column name and table name in SELECT.  However, Dynamic SQL gives a way to overcome this requirement.  This post I will share with you other two usages of ‘dynamic’.

Continue reading “Dynamic! Dynamic!”

Brain Twister in SQL

My kids and I love tongue twisters. We say tongue twister loudly in the car and they giggle and laugh loudly. I love to hear them giggle and laugh.

As I  work full time as a SQL developer, I write and read SQL code much more often than when I was a SQL blogger. When I  see SQL some code, I think: this is good. But, can you find a better way? Furthermore, what is the best way? These questions tickle my brain and when I find some answer, my brain giggles and laughs. I love that feeling.

Today, I want to share two SQL brain twisters (that comes from my work) with you. Continue reading “Brain Twister in SQL”

AI and BI – Part 1

Immediately after Xbox 1X was on the market, the price of Xbox 1S dropped dramatically. However, my son only wanted the newest model. It was OK for him not to have an Xbox at all, but it was not acceptable for him to have an older version of Xbox.  I am in the same group with my son. I prefer to play the newest toy too. Excitedly, I announce my newest project: using AI (Artificial Intelligence) to answer BI (Business Intelligence) questions. Continue reading “AI and BI – Part 1”

Some Topics that I am interested recently

As I learn, I feel two strong different interests drawing me.

First, I am interested in learning BIml. BIml brings the automation and the separation of objects and algorithm into ETL part of business intelligence.

Second, I am interested in deepening my skills in data visualization. I especially like this book, Storytelling with Data by  Cole Nussbaumer Knaflic. 

Continue reading “Some Topics that I am interested recently”