T-SQL Tuesday #204 – Are blogs still relevant?

Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026. If you’d like to reply, your response should go live on November 10th, 2026. All posts must be posted by 23:59 Pacific Time. Details and the rules are at the bottom of this post.

In 2009, right around the time T-SQL Tuesday was getting started, I wasn’t a very good at SQL Server. I could install it, check some boxes, and restart the server if there were problems. But that was about it.

That year I found myself looking for my next job as a Database Administrator. I went to an interview with a large healthcare company all ready to answer technical questions and give reasons why they should hire me, and the interviewer starts by asking me: “What SQL Server blogs do you read?”

I was frozen, because I didn’t read any database blogs. I didn’t even know there were such things. I read blogs about sports or music or any number of frivolous things, but nothing then that related to databases or SQL Server. I blurted out something about “Microsoft blogs” and continued with the interview, a bit shaken. Ultimately, I didn’t get offered the job.

But that question haunted me so much that afterwards I started seeking out blogs, and later other forms of media produced by people in the data community. That sharing of free information in blogs has made a massive difference for my career path. Obviously, at some point I started my own blog, which I dare say has made a significant impact in my skills and employment.

But…have times changed since 2009? Are blogs still relevant?

The invitation

For this T-SQL Tuesday, I’m asking folks to share why they do or don’t think the blog platform is still relevant for those of us working with databases.

I realize it’s a bit odd to ask folks to write a blog post about the relevance of blogs, and how that might tilt the resulting content, but I also know there are a lot of folks who have lapsed in their blogging in recent years. I’m wondering if that’s an issue of being too busy, or not having enough to say, or just not being interested in this medium anymore.

There are no wrong answers. You can talk about your favorite reasons for blogs as either an author or a reader, or even share a short list your favorite blogs and their reasons for relevance to you.

Conversely, you can talk about alternative media you use to learn about all the new things. Or even respond on an alternative medium and link it here (which might be a first for T-SQL Tuesdays). Or, if you have lapsed in blogging and reading blogs, share the reasons. Heck, you can even reminisce about “the good old days” of…whatever you think made up the good old days of blogging.

The “rules” (don’t worry – like the Pirate Code these are more like guidelines)

T-SQL Tuesday is a monthly blog collaboration of sorts started by Adam Machanic and maintained by Steve Jones, and everyone with a blog is welcome to join. Here’s how to play along.

  • Publish your post on Tuesday, November 10, 2026 between 00:00 and 23:59 UTC on that day.
  • Include a link back to this blog post, or leave a comment in this post linking to your content. (This one is actually a rule.) 
  • Please include the T-SQL Tuesday logo at the top of your post.
  • Share it on social media with #tsql2sday so the rest of the community can see it.
  • Any blogger is welcome to participate. It doesn’t matter how long your blog has been active, where you blog, or even what language you post in. We just want to hear your thoughts.

One week later I will publish a “roundup” post linking to all the responses. I’m greatly looking forward to this, and I hope you have some fun with your response – this is a request for a voluntary contribution, not homework.

Thank you in advance for sharing your thoughts on this subject. T-SQL Tuesday has been connecting bloggers and helping to bring awareness to new authors since 2009, and I certainly hope that continues this month!

T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future

I haven’t posted in a while (well, not here at least since I’ve been posting at the Straight Path Solutions site recently), but I did want to reply to the latest T-SQL Tuesday call. This month’s edition is hosted by Mike Walsh, who asks folks to write two short but thoughtful notes to yourself: one to your past self of 10 years go, and one from yourself 10 years in the future.

One quick note: am I writing this to myself? Absolutely. But hopefully these words resonate with others not as far down my path, as I’ve learned these truths the proverbial “hard way”.

Continue reading “T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future” →

What I’ve learned in my first 100 days with a consulting group

In case you don’t follow me on LinkedIn or Twitter, your humble host joined the smart folks at Straight Path Solutions in March. This is a talented group of SQL Server consultants founded by Mike Walsh and includes several former Microsoft MVPs, and I’m incredibly honored to be part of their team.

Especially since I didn’t have much experience as a consultant.

Maybe you don’t either, which is why I wrote this post. If you ever wanted to know how consulting is different than a typical job as a fulltime DBA, I’ve assembled this brief retrospective of things I’ve learned so far.

Let’s get to it then.

Continue reading “What I’ve learned in my first 100 days with a consulting group” →

How to find tables with 0 records using space

This is a follow up post to the previous one about tables with no records using data space, with the idea coming from twitter of all places. Sometimes on twitter the conversations kill, but after reading that post my friend Chris Wood suggested writing something to FIND those tables.

Which is a solid idea, so let’s get to it. No time to wait too long.

Continue reading “How to find tables with 0 records using space” →

How can a table with 0 records use so much space?

Just like that puppy you got during the pandemic, your databases hunger for more. And they grow. And occasionally make a mess. I’ll stop the analogy.

Anyhow, it’s worthwhile to occasionally review the tables in a database to see which ones are growing every day, using the most space.

But what if during a review you see the largest table looks like this?

That’s around 24 GB of sweet drive space allocated for 0 records. But…how?

Let me show you how.

Continue reading “How can a table with 0 records use so much space?” →

How to get Change Data Capture to work in an Availability Group

If you’ve ever had to implement Change Data Capture (CDC) for a database in an Availability Group, then you know that the CDC jobs don’t really consider the Availability Group. The capture and cleanup jobs created are set up as if the database exists only on a single instance.

And that’s a problem, because I would guess quite lot of databases are in Availability Groups. Maybe even some of yours. If you have this issue, I’ve put together a step-by-step solution in this post.

I know this post is a little long compared to others here, but I’ve tried to be thorough to save you headaches.

Continue reading “How to get Change Data Capture to work in an Availability Group” →

sp_GetRowcount: How to count the number of rows in any SQL Server table fast

Have you ever had to find the number of rows in a user table, and then wrote a little “SELECT COUNT(*) FROM tblWhatever” and hit execute…and waited…and waited…and waited some more? And then started wondering what was going on?

If so, this post is for you.

Let me explain the problem, and then give you a reusable solution. Consider this a turning point in your career.

Continue reading “sp_GetRowcount: How to count the number of rows in any SQL Server table fast” →

How to tell if Change Data Capture (CDC) is working as expected

I’m not sure how many of you use Change Data Capture (CDC) on your instances, but I’ve had to support it for a while now and I thought I’d share a little script I use fairly frequently to help troubleshoot the capture and cleanup, as well as some advice for resolving issues.

Sharing is such a gentle trait.

Continue reading “How to tell if Change Data Capture (CDC) is working as expected” →

#TSQL2sday – Preconceived Notions About Who Is Smart

For this month’s #TSQL2day, Andy Yun asked folks to share about “something you’ve learned, that subsequently changed your opinion/viewpoint/etc. on something.”

Now, there are technical subjects I could share where I’ve changed my opinion, but in thinking about possible answers I realized all of them start with one thing that has changed: who I thought was “smart”.

I put the word smart in quotes, because it’s a totally subjective and ever-changing opinion. Let me show you what I mean.

Continue reading “#TSQL2sday – Preconceived Notions About Who Is Smart” →

What permissions are required for temporary tables?

Managing permissions is a constant issue for Database Administrators, but rarely do DBAs consider permissions for tempdb. Everybody’s looking for something, but how often do you get requests for “access to read and write in the tempdb database”? Like…never?

OK, but what if you were asked the subject of this post in a job interview? Even if you’ve worked with SQL Server for ages, would you know how to answer this? Moreover, would you know why the answer should give you some concern?

Hold your head up, because I’ll start answering these questions now.

Continue reading “What permissions are required for temporary tables?” →