Category: Blog

  • My 2024 in Data: Speaking

    This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my year. I like data and numbers, so I’m looking at a few aspects of life this year with data I’ve compiled from previous years.

    Today I’m looking at my speaking efforts in 2024. Since I finished all my commitments in November, this is an easy post to write.

    Speaking Stats

    Here are the gross stats for public speaking, as free and paid events.

    • Events: 37
    • Talks: 68
    • Virtual talks: 7
    • free, community events (non UGs): 9
    • user group talks: 3
    • Redgate events: 20

    This was also a year when I spoke at two events that repeated during the year. THAT! Conference was in Austin and Wisconsin Dells and I was honored to go to both. I was also at both of the Denver Dev Days (May and Oct).

    Lots of these required some trips, but some were local or remote, so this didn’t feel like a big speaking year.

    In terms of sessions, I delivered 19 different talks throughout the year, with a number of repeats. I like having 5-6 current talks that I can repeat at different events as this helps me practice them and deliver a smoother performance.

    Most of my talks with smaller, < 100 audiences, but I did have a few keynotes this year with some audiences in couple of hundred attendees. Maybe my largest talk was to about 300 people + hundreds online at DevOps Days Minneapolis.

    Many of these events were great, and I’m looking forward to more in 2025. A few that I’m hoping to get back to in 2025:

    • VS Live (none in 2024 other than Live 360)
    • THAT Conference
    • DevOps Days (either Minn or elsewhere)
    • SQL Sat Baton Rouge – one of my favorites and I hope to get back in 2025.
  • My 2024 in Data: Travels

    This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my year. I like data and numbers, so I’m looking at a few aspects of life this year with data I’ve compiled from previous years.

    Today we look at travels, which is something I do a lot each year.

    The Report

    Let’s look at my Power BI Report. Quite the year, traveling to three countries and spending nights in 35 cities. My home city/country are included, so the next is other places. As you can see from the map, I was lucky to get to Australia, the UK, and Italy.

    2024-12_0145

    One of my favorite spots this year was Montepulciano, where my wife and I spent a relaxing day.

    2024-12_0146

    A few other numbers (ignoring home):

    • US States visited: 15
    • Nights in hotels: 119
    • Nights in hotels not for work: 36
    • Trips: 26
    • Flights: 68
    • Overnight train trips: 1

    The non work hotels are likely a bit low as my wife was with me and we extended some work trips by a day and relaxed. Otherwise, I’d have likely tried to miss a few hotel nights and get home.

    I have no idea how many miles I traveled, but it was a lot. I had some long trips this year as well, which were made easier (for most of them) with my wife coming along. Australia was 19 days and the UK/Italy/UK was 14 days.

    I also had some crazy stretches, which were hard, but fun trips. The first was this turnaround:

    • Sun – Wed – London, UK for an event
    • Thur – Cambridge
    • Fri – fly to Colorado
    • Sat/Sun – Colorado, coaching
    • Mon – fly to Sydney, AUS

    My body was a bit messed up after that one. The next one was a easier.

    • Fri – leave Melbourne to fly home
    • Sat-Sun home
    • Mon – fly to NY

    Another almost crossing half the world trip. The last one was also a bit crazy.

    • Wed – Fly to Dallas
    • Thur – event + Fly back to Colorado
    • Fri – Fly to Syr
    • Sat – speak, fly to New Jersey, then London overnight

    That last one was OK since I spent 5 days in Cambridge and then a week in Tuscany with my wife. Glad I went home for a night though.

    All in all, this was one of my biggest and not biggest travel years. I had the same number of trips as last year, but they were more spread out. No trips in Dec, and some nice stretches at home throughout the year. Last year was more hectic with lots of small trips that kept me leaving home almost every week for a lot of the year.

    I also didn’t see as many countries this year, and no new ones, but we had some memorable and amazing vacations, which made a better year.

    I also crossed 1 million flight miles on United this year, which is a nice milestone for someone that travels a lot. My wife gets to share my status, which is nice as she often travels solo and meets me in places.

    Looking forward to 2025, though I have no idea what to expect for travel.

  • Playing with the Data API Builder

    I published an article today on the Data API Builder, which is a way of presenting your database tables as a REST or GraphQL API for developers. You can read the article to learn how to get started, but I’m adding a small thing in this post.

    This is part of my posts on the Data API Builder.

    Setting the Page

    The default page for data is 100 elements (and the next URL). That’s a lot for display, and I might not want developers to get that much data by default. Perhaps I only want 5 rows.

    In the JSON file, I’ll add an item below the development mode element (but a level above. I’ve shown this below:

    2024-12_0164

    The JSON is a bit fiddly, so you need to make sure you know where you’re adding this. The options are below the “runtime” at the same level as “rest” and other items.

    Once I do this, if I query from Postman, I see this, only 5 elements (and the next)

    2024-12_0165

    A quick add, which will be in the next (or next after that) DAB article.

  • A New Word: Dolonia

    dolonia – n. a state of unease prompted by people who seem to like you too much, which makes you wonder if they must have you confused with someone else – someone flawless, selfless, or easy to understand from a distance – feeling vaguely disappointed that they’re unwilling to spend the time it takes getting to know the real you.

    I have a bit of dolonia when I meet some people at events who seem extra excited to meet me. I wonder sometimes if they think I’m someone I’m not. Not a different person, but their impression of what I’ve done with SQL Server Central seems outsized compared to what I think I’ve done.

    Perhaps I have the opposite of dolonia, not realizing my own impact.

    In either case, it’s a certainly a strange life I lead some days.

    From the Dictionary of Obscure Sorrows