02 January 2020
02 January 2020

Power BI and Excel

4
Power BI and Excel are tools so close to each other that Power BI was born inside Excel. Power Query, Power Pivot, Power View, they were all Excel plugins before being united and become Power BI. The ability to build an ETL, design a model and generate reports and dashboards with great storytelling make Power … Read more
10 October 2019
10 October 2019

Programmer Gear: Thin Apple Watch Band

0
This blog is different than my normal T-SQL blogs I almost always do. But I know that I cannot be the only computer programmer who wants to wear a smart watch when working to get some of the health and alert benefits that they can provide. The band though, has always been a blocker to … Read more
30 September 2019
30 September 2019

The Case of the Vanishing Index Compression

0
Recently, we started adding compression to some of our larger tables in our data warehouse where columnstore indexes didn’t make sense. (For example, some very large dimension tables, and a few facts where they are not used for large aggregates in the common manner). The changes were checked into source control, we monitored performance, all … Read more
16 June 2019
16 June 2019

A Father’s Influence

0
My dad and I had a very interesting and complex relationship. Some of this was due to his complex upbringing. His father was an alcoholic who died fairly early in his life, and his mom, well, his mom liked me a lot, but she was a messed up woman in many ways. After his father … Read more
02 May 2019
02 May 2019

Enjoying Joins in MongoDB

10
MongoDB has a prodigious appetite for unstructured data and has its place in a Database Developer’s toolkit. Even with indexes in place, some operations that involve aggregation are a lot slower than they are with relational databases: So it is when using ‘joins’ between collections. Lookup, the MongoDB equivalent to Joins, cannot yet do Merge … Read more