Quantifiably Good
My last few posts have been a bit serious so let's have a little fun! It's easy to count to 10 with your fingers, and you can count to 20 if you throw your toes into the mix. But how can you use your fingers to go higher than that? You could throw in your... Continue Reading →
In the first post in this series on disinformation, I asked what we could do as a society to prevent or manage disinformation -- false information that is intended to mislead its consumers. The solution isn’t easy, but we can start here...
After coffee, I take on the morning’s math problem: figuring out the insulin needed for my kid's breakfast. So much for total carbs, minus amount spilled and not eaten, plus replacement carbs eaten, minus some for gym class in the morning... Life is all about numbers when you’re living with Type 1 diabetes (T1D). Type... Continue Reading →
Want a quick way to copy your file's path and paste into that email to send to your fellow coworkers? In Windows Explorer, hold the SHIFT key while you RIGHT-CLICK on your file name and select Copy as path. Then paste into your document and voila! You have your entire path in quotes. So simple!... Continue Reading →
Recall our Bob's Burgers example of padding records. Let's expand on it. We now want to know for each record in our padded record set, what was the rolling weekly running sum of burgers served as well as total burgers served to date. And we might as well get the sum of burgers served overall... Continue Reading →
Last weekend, my family went camping. It was our first exposure this year to our medium yellow star and as always, we forgot about “carefully” applying sunscreen on our virgin skin. By the end of the day, my daughter’s fair skin looked like preschoolers finger painted sunscreen. She sported some lovely patterns of white and... Continue Reading →
This 2018 graduation season is difficult for me for many reasons. There is little-known local news reporting that two high school students ending their own lives just days before graduation, following the well-known national news that two public figures committing suicide the week before. I know families that bear the same grief from losing their... Continue Reading →
A few days ago, Abijeet Nath and Nilopal Das were killed when they stopped in a village in Assam state in India to ask for directions. They were attacked by a mob that suspected they may be child abductors. Abijeet and Nilopal were the latest victims in a series of deaths in India related to... Continue Reading →
I attended a conference by the Data Warehouse Institute (TDWI) last October. In one of the presentations, Gerald Hopkins talked about GDPR. It was the first time I had ever heard of it, and Gerald basically told us that if we were doing business in Europe and hadn’t started working on GDPR we should be... Continue Reading →
I'm a huge fan of Bob's Burgers. So today's SQL tip will be featuring the Burger of the Day. We want to show burger records even on days when Bob hasn't been grilling. Let's setup our use case. Our goal is to capture a record per day in the month of January for every Bob's... Continue Reading →