Brian Dill's Avatar

Brian Dill

@wbdill

FOR: democracy. AGAINST: fascism, oligarchy, authoritarianism. Database guy, automation obsessed, hobby photog, hobby musician. Tools: databricks, SQL Server, PowerShell, R, Excel, DuckDB https://briandill.com/ https://youpic.com/photographer/BrianDill

134
Followers
300
Following
51
Posts
11.11.2024
Joined
Posts Following

Latest posts by Brian Dill @wbdill

Billboard Hot 100 chart of Taylor Swift songs from her "Secret Life of a Showgirl" album.

Billboard Hot 100 chart of Taylor Swift songs from her "Secret Life of a Showgirl" album.

After the post-Christmas slump, "Opalite" and "The Fate of Ophelia" rebounded on the #BillboardHot100. This week "Opalite" takes the top spot and all but these two songs have fallen off the chart for #TaylorSwift.

02.03.2026 22:28 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
DataTune - Data Community Conference - Nashville 2026 DataTune is Nashville’s community-driven conference for data professionals, leaders, and innovators. Join us March 6 – 7, 2026, to learn, connect, and explore the future of AI, engineering, and analyt...

Also very excited to see the use of DuckDB in the lite version. I'm presenting a DuckDB 101 session at datatuneconf.com. I hope to bump into you to say hey and thanks in person.

18.02.2026 20:23 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Can't wait to check this out. Thank you from all of us "poors" who don't have a big corporate credit card. :)

18.02.2026 20:22 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
Announcing Free SQL Server Performance Monitoring That Doesn't Suck Announcing Free SQL Server Performance Monitoring I built a free, open-source SQL Server performance monitoring tool. Two editions, no licensing fees, no telemetry, no cloud dependency. Here's what it does...

Announcing Free SQL Server Performance Monitoring That Doesn't Suck

Announcing Free SQL Server Performance Monitoring I built a free, open-source SQL Server performance monitoring tool. Two editions, no licensing...

11.02.2026 17:19 πŸ‘ 17 πŸ” 8 πŸ’¬ 4 πŸ“Œ 3
Billboard Hot 100 chart for Bad Bunny

Billboard Hot 100 chart for Bad Bunny

#BadBunny continues his post-Superbowl bump in the #BillboardHot100

shiny.briandill.net/BillboardHot...

#rstats

18.02.2026 20:16 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
debut songs on the Billboard Hot 100 for 1998-12-05

debut songs on the Billboard Hot 100 for 1998-12-05

some of the debut songs that week of 1998-12-05

#billboardhot100

17.02.2026 00:35 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Table showing the Billboard Hot 100 weeks with number of new songs that week.

Table showing the Billboard Hot 100 weeks with number of new songs that week.

Dec 5, 1998 saw the most songs (60) debut on the Billboard Hot 100 - aside from the chart's inaugural week way back in 1958.

The next highest debut week had just 34 in Nov 27, 2021. The average # of songs newly appearing on the chart in any week is 9.21.

#billboardhot100

17.02.2026 00:29 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

YouTube is now old enough to drink.

14.02.2026 21:59 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
DuckDB 101 session will be presented at DataTune conference in Nashville on Sat March 7, 2026

DuckDB 101 session will be presented at DataTune conference in Nashville on Sat March 7, 2026

Come see my "DuckDB 101" session on Saturday March 7, 2026 at the datatuneconf.com in Nashville
#DuckDB

11.02.2026 20:08 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
DataTune - Data Community Conference - Nashville 2026 DataTune is Nashville’s community-driven conference for data professionals, leaders, and innovators. Join us March 6 – 7, 2026, to learn, connect, and explore the future of AI, engineering, and analyt...

@hannes.muehleisen.org I LOOOOVE DuckDB so much that I am presenting a "DuckDB 101" session at datatuneconf.com on March 7

11.02.2026 19:20 πŸ‘ 8 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

@heidisql.com is there any consideration for supporting DuckDB databases?

@duckdb.org

11.02.2026 15:28 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Billboard Hot 100 chart for Kid Rock

Billboard Hot 100 chart for Kid Rock

For comparison here is Kid Rock's #BillboardHot100

shiny.briandill.net/BillboardHot...

#rstats

10.02.2026 20:41 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Billboard Hot 100 chart for Bad Bunny over the past year. 5 songs revived in the rankings after the Superbowl halftime show.

Billboard Hot 100 chart for Bad Bunny over the past year. 5 songs revived in the rankings after the Superbowl halftime show.

#BadBunny #Superbowl bump on the #BillboardHot100

shiny.briandill.net/BillboardHot...

#rstats

10.02.2026 20:38 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Is it just me or is the Venn diagram of the Gadsden flag "Don't tread on me" crowd and the "comply or die" crowd starting to look like concentric circles?

#Minnesota #minneapolis #ice

25.01.2026 14:59 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Table showing ranking of popular names that never reached #1

Table showing ranking of popular names that never reached #1

"William" is the most popular name to never reach number one in any year. #SSA #babynames

shiny.briandill.net/Babynames/?n...

wiki.briandill.net/books/duckdb...

21.01.2026 04:54 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Mariah Carey's Billboard Hot 100 chart.  Showing her song "All I want for Christmas is You" return to #1 year after year for the past 8 years or so.

Mariah Carey's Billboard Hot 100 chart. Showing her song "All I want for Christmas is You" return to #1 year after year for the past 8 years or so.

Like a moth to a flame Mariah Carey's "All I Want for Christmas is You" returns to #1 again and again.

shiny.briandill.net/BillboardHot...

#billboardhot100
#rstats #shinyr

11.12.2025 05:37 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
chart of popularity of boy's names: Michael, David, and Jacob

chart of popularity of boy's names: Michael, David, and Jacob

Michael, David and Jacob were the king of boy's names from 1954 to 2012. All have seen rapid decline in popularity since 2013.

How popular is YOUR name? shiny.briandill.net/Babynames/

Some stats:
docs.google.com/spreadsheets...

Data: #SocialSecurityAdministration
#rstats

04.12.2025 07:06 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Four Christmas songs in the top 10 - #5 "All I want for Christmas" by Mariah Carey, #6 "Last Christmas" by Wham!, #7 "Rockin' Around the Christmas Tree" by Brenda Lee, #8 "Jingle Bell Rock" by Bobby Helms

Four Christmas songs in the top 10 - #5 "All I want for Christmas" by Mariah Carey, #6 "Last Christmas" by Wham!, #7 "Rockin' Around the Christmas Tree" by Brenda Lee, #8 "Jingle Bell Rock" by Bobby Helms

It's only Dec 4th and already 4 of the #BillboardHot100 chart's top 10 are Christmas songs.

04.12.2025 06:13 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
plot of number of unique names for a given sex/year.  X-axis is year and y-axis is count.  One line for male and one for female.

plot of number of unique names for a given sex/year. X-axis is year and y-axis is count. One line for male and one for female.

The # of unique female names began its long rise around 1945. Male names didn't start its long rise until the late 1960's. Both climbed until the mid 2000's when both stopped climbing.
Data from the #SocialSecurityAdministration

How popular is your name? shiny.briandill.net/Babynames

#rstats

04.12.2025 06:09 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
UTF-8, Explained Simply
UTF-8, Explained Simply YouTube video by Nic Barker

The best explainer I have seen on UTF-8 if you want to take a short trip down the encoding rabbit hole. youtu.be/vpSkBV5vydg?...

05.10.2025 13:41 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Can we outlaw the rubberized coating on plastics that turn into a sticky goo after a few years? Or at least require labeling?
#consumersfirst

30.09.2025 14:41 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Why can't someone make an 18650 Li-ion charger that stops charging at 4.10V?

30.09.2025 14:38 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
The Data Detective: Ten Easy Rules to Make Sense of Statistics Buy The Data Detective: Ten Easy Rules to Make Sense of Statistics on Amazon.com βœ“ FREE SHIPPING on qualified orders

"... it’s far easier to lead ourselves astray when the practical consequences of being wrong are small or nonexistent, while the social consequences of being β€œwrong” are severe. It’s no coincidence that this describes many controversies that divide along partisan lines."
Ch 1 of
amzn.to/46xNVtg

21.09.2025 16:37 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
avacado on napkin 6.02 x 10^23

avacado on napkin 6.02 x 10^23

Where my #chemistry geeks at?
Avocado's number anyone?
If you don't store it carefully it will probably be eaten by a mole!

18.09.2025 01:42 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Redirecting...

I'm always weary of pre-trial hype, but if true this is more than a watershed moment. This is species changing.
www.facebook.com/share/p/179c...

06.09.2025 19:42 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
photo of Ann Wilson and Nancy Wilson of the band "Heart"

photo of Ann Wilson and Nancy Wilson of the band "Heart"

The iconic group "Heart" had two songs hit # 1 on the #BillboardHot100 Can you name them?

Don't peek until you have guessed: shiny.briandill.net/BillboardHot...

13.08.2025 22:26 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Artists with 3+ simultaneous Top 10 on the Billboard Hot 100.

The Beatles 1964
The Bee Gees 1978
none in the 80's, 90's, 00's until
Adele in 2012
Justin Bieber 10-weeks 2015-16
Drake - the first to have 6 2018
Taylor Swift - the first to have 8 - 2022, 2023, 2024

docs.google.com/spreadsheets...

22.06.2025 02:55 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
More Cowbell - SNL
More Cowbell - SNL YouTube video by Saturday Night Live

Today in "let's make you feel old"...

The SNL "more cowbell" skit (2000) is closer to the release of Blue Oyster Cult's "Don't Fear the Reaper" (1976) than today (2025).

youtu.be/cVsQLlk-T0s?...

youtu.be/cVsQLlk-T0s?...

21.06.2025 00:25 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

Guess who was POTUS for 9 of the 10 largest single day drops of the DOW? #ArtOfTheDeal #ColdHardFacts

12.04.2025 01:50 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
ICD-10-CM codes

See the full table of data here: docs.google.com/spreadsheets...

28.02.2025 00:16 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0