T-SQL Tuesday #188: Growing the Community

Posted on July 8, 2025 by way0utwest

This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has been a great help in multiple communities over the years, and he has quite an inspirational invitation when you read his story. I am honored to call John a friend and enjoy the times we get to sit and chat.

If you aren’t a part of T-SQL Tuesday, start a blog at WordPress or Medium, or even on LinkedIn. Write a post, leave a link on John’s invitatin, and become a bigger part of our community. If you want to host a T-SQL Tuesday let me know.

Working in the Community

Quite a bit of my career has been intertwined with community. When we started SQL Server Central, we didn’t expect the community to grow like it did. We thought we’d help teach people, but the forums have become an amazing community. If you ever need help, there are plenty of people who can help, arguably better than a GenAI.

From there, my partners, Andy Warren and Brian Knight, and I founded SQL Saturday. I continue to run that today, helping local volunteers run events and fund them.

However, the things I’ve been most proud of is convincing some of the people in the Denver area to deliver their first presentation, helping to inspire and educate their local community. I’ve made it a point over the years to look for, and listen for, smart people and then encourage, support, and inspire them to try speaking. Getting new people to share information is always exciting and thrilling for me, and it adds to the community aspect of my life.

I’ve been less successful in getting others to blog, but still, each time I see someone start blogging, I’m grateful they made the time and overcame their fears to share something with the world.

A rising tide lifts all boats, and a community is an incredible tide.

Posted in Blog | Tagged , | 2 Comments

Sabbatical le Troisième: A Recharge Week

Posted on July 5, 2025 by way0utwest

It’s been a week since I flew home from London and Redgate to begin my sabbatical. Actually, at this time last week I was just about to land in Chicago on my way back.

I hadn’t made any big plans, and despite my wife pushing, I wanted to spend a week at home doing little.

Mission accomplished.

I got back and spent Sunday and Monday doing some chores, trying to catch up on some lawn maintenance and weeding at the ranch, however, after that I slowed down. While in Cambridge I was attacked by a mosquito the last night and ended up with a few dozen bites on my arms. My body doesn’t react well to these and I’ve had a lot of itching and welts on the arm.

I did a few chores, helping my daughter as she’s working two jobs and sometimes get late with things on the ranch, so I’ve filled water and cleaned stalls. I cleaned a UTV and found the reason why the brakes weren’t working. A broken caliper, so I drove that to the shop after debugging a loose battery cable leading to inconsistent starting.

It’s worse in the sun, so starting Tuesday I decided to slow down and spend a little more time inside. I worked on cleaning out closets and doing some household chores. I also caught up on laundry, played some guitar (re=learning Angel from Montgomery, and trying to learn Secret of Life, which is hard). I also managed to spend a few afternoons with my wife not doing much, relaxing and catching up in person, as opposed to on the phone.

I have a few things planned out and bought some pieces and parts. Today I replace a gate wheel and cut some wood to repair a feeder. I’ll grab a few pictures and post to show that I am being productive.

Posted in Blog | Tagged , | Comments Off on Sabbatical le Troisième: A Recharge Week

PASS Summit on Tour in New York City

Posted on July 2, 2025 by way0utwest

The PASS Summit goes on tour this year, with an August stop in New York City. This is the first event in the series, and I’m excited to go back to New York City for the event. You can register here and come see some amazing speakers on Aug 18-19, 2025.

2025-06_line0085

The lineup is small and short, but it’s a one pre-con day with two half-day sessions and then a one full day of hour long sessions. The pre-cons include security, analysis, performance tuning and more. All from industry experts. The regular sessions are across four tracks with a variety of things you can learn during the 5 time slots throughout the day.

There is also a Redgate Summit in New York on Wednesday. That’s got Redgate specific content, but if you’re interested (or a customer), stay an extra day for that as well.

If you’re near New York City, or can convince your boss to send you, register today and join us on tour. The larger main event is still in Seattle, and if you prefer that, come for a full week in November.

Posted in Blog | Tagged , , , | 1 Comment

Quick Wins with GenAI

Posted on June 30, 2025 by way0utwest

The more I look to GenAI to save me minutes, short periods of time, the better it works. Here’s an example of something I do regularly where AI helps.

This is part of a series of experiments with AI systems.

Reformatting code

I often see code like this submitted in articles.

2025-06_line0083

The code conversion box often adds extra lines between code. It’s a strange error, and since things get pasted in with lots of formatting, it’s not so simple to fix. I often look at the code side of things and remove lines. This is the raw code:

2025-06_line0081

It’s ugly, and it’s easy to fix, but it takes time and it can be an annoying task. I often might put on a video or multi-task while I handle this simple reformat.

Using Claude

Claude is often my go-to GenAI for now. I tried this prompt, with a CTRL+V of the code. As you can see, Claude starts to reason things out.

2025-06_line0084

On the right side, I can see it rewriting code, which is always fascinating. Reminds me of terminal work over a 300baud modem in university. I’ve grabbed a short snippet of how this works.

Once this is done, I see my code on the right code. I can click “Copy” at the top and then paste back into the editor. It looks much better.

2025-06_line0082

This allows me to move on and tackle some other task before I come back to this, knowing Claude will have helped me.

Small wins, very helpful, but a lever to make me more productive.

I don’t know if this is worth the cost in computing, but it is very helpful. Minutes saved are likely worth a small subscription to the tool every month if I can find a few more tasks like this.

Posted in Blog | Tagged , , | Comments Off on Quick Wins with GenAI