Author Archives: Charles Rinaldini

Querying Delta Lake with T-SQL via Synapse Serverless and Managed Instance

In this blog post I try to demystify how to setup an environment that utilizes Azure Synapse Serverless, Delta Lake on ADLS Gen2, and SQL Managed Instances to enable you to query your delta lake with T-SQL as if it were any other SQL source in order to accomplish something like polybase.

Continue reading

Buying a South Denver Home Based on Power BI Insights

Two years ago I got tired of paying rent and decided to dive into homeownership because of the insights I saw in a similar dashboard to the one in this post. What I saw was purchasing a home in Englewood was a sound investment because it was a neutral to almost a buyer’s market in the southern part. I bet on the southern expansion of Broadway as people found living in Platt Park/Wash Park became more and more unaffordable as well as local investments in the betterment and appeal of Englewood driving northern expansion along Broadway.

It’s inevitable that the South Broadway strip will eventually become more walkable and different than the times of even a decade ago, where it was void of any stores worth visiting and restaurants that were any good; and that’s exactly what the data was showing me. Now I’m here two years later, engaged, and wanting to purchase another home. What will the data show this time?

Continue reading