2019 Year In Review, Part 2

In yesterday’s post, I covered my presentation goals. In today’s post, I’m going to hit on things which were outside of those goals.

Website Rebuild

The Catallaxy Services website was a bit old when I started it—it was a learning project in Django and I wanted to write all of the code by hand. This year, I went out and got a more professional design and rebuilt the Catallaxy Services website. I have more details on the process, but the quick reasoning was that searching my site on a phone—something I would not have done in 2012—was painful. This helps a lot. I’m still not happy with my hero image (which is the sunrise over Mt Haleakala), but it’ll do for now.

The Book

PolyBase Revealed was a labor of love. Or at least a lot of labor and something approximating an emotion. Now it’s time to sit back and cash those fat royalty checks. It turns out that if you make the royalty check itself twice as large, people don’t care as much that they’re only getting 37 cents in royalties.

DataCamp Course

I have a DataCamp course entitled Time Series Analysis in SQL Server. I go into great detail on how you can work with dates and times in SQL Server. The first module is free, and the rest of it is for pay.

TriPASS Incorporated

We’re wrapping up the final pieces of incorporating the Triangle Area SQL Server Users Group. We elected a board in February and are registered as a 501(c)(3) thanks to Tom Norman’s efforts.

TriPASS Twitch Streaming

Twitch streaming has gotten off to an okay start. If you’re interested in catching SQL Server user group meetings online, join our Twitch channel. If you want to see some of the mechanisms behind the stream, I wrote up a post.

For next year, I really want to improve my streaming skills; it takes too long to get things set up, too much is flaky, and I want to improve the intro and outro, as well as the quality of streams when we have remote presenters.

100 SQL Saturdays

SQL Saturday Orlando marked my 100th SQL Saturday. I’m still going to be on the SQL Saturday circuit and have several confirmed events so far on the schedule for 2020.

New Talks

This was a big year for new talks (and part of the impetus behind making a few others obsolete). In 2019, I created the following presentations:

I had a few more “one-off” presentations for TriPASS, but I won’t count them because I don’t intend to present them again.


Looking back on this, I’m not sure when I actually slept during the year. It’s been a big year, and I’m looking forward to 2020 being a big year as well. I’ll talk about some of my goals in the next post.

2019 Year In Review, Part 1

This will be a review of my presentation goals for 2019. Tomorrow, I’m going to talk about a bunch of other stuff I did. It’s been a busy year.

Coming into the year, I had 5 major goals and 2 stretch goals. Here’s how I did on each of them.

Speak at 20 SQL Saturdays and 10 User Groups

I ended up hitting 20 SQL Saturdays on the nose. As far as user groups go, I had 13 user group presentations, including two remote. One successful goal down.

Speak in 4 Countries

I ended up speaking at events in six countries: the United States, Canada, Germany, Ireland, the United Kingdom, and Australia. Two successful goals down.

Update 4 Older Talks to Use GitPitch

I’ve become a lot more comfortable with GitPitch (to the point where I’m paying for the full product, as I want it around for a while). At the beginning of the year, I listed out a half-dozen talks which would be good to migrate to GitPitch. I moved four of them, rewrote a fifth (on PolyBase), and will probably retire the 6th at some point. Speaking of which…

Retire 4 Talks

Sometimes, it’s good to put a talk out to pasture. I ended up giving up on a few of them this year, though funny enough, I brought my talk on Biml out of retirement due to internal demand.

I missed on my two stretch goals, but did end up hitting all of my main goals, so I’ve got that going for me. Tomorrow, I get to brag about all of the stuff I was doing while missing those stretch goals…

Update: PolyBase Revealed

I jumped the gun with the Cyber 5 sale, but PolyBase Revealed is available for pre-order. You can pre-order the paperback edition on Amazon for $27.99, get the Kindle edition on Amazon for $24.99, or buy the eBook directly from Apress for $19.99.

When I originally spec’d out the book, I estimated that it would be approximately 175 pages long. Well, it turns out that I had a little bit more to say on the topic than I thought, and the final length will be 311 pages. If all goes well, it will be available in mid-January, which still makes it a great Valentine’s Day gift for the 50 closest people in your life.