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 →
SQL Server: Running Sums with Bob’s Burgers
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 →
Summer = Sunscreen
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 →
Cultivate Wellbeing & Resiliency
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 →
Disinformation: Do you know when you’re being had?
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 →
GDPR: Who Owns Your Data?
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 →
SQL Server: Padding records on days when Bob isn’t grilling burgers…
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 →
Hilarious Real Life Graphs
If you haven't run across Matt Shirley yet, stop and take a look! His daily, hand-drawn graphs are brilliantly simple. They distill emotionally ambiguous situations like the Sunday blues into minimal charts that everyone instantly "gets." Sibling relationships become a Ven diagram, and the life cycle of socks a scatter plot...of sorts! ... Continue Reading →