Voice of the DBA

Tag: syndicated

Sabbatical 3 Review

I’m back. My last day of work was Jun 27 and I came back a few days ago, on Aug 13. Just over six weeks away and I am very grateful to Redgate for allowing me the break from work. This was my third sabbatical, and it was mostly unwired, which was new.

Or as my wife said last week, I was practicing for retirement.

I think I was, as I didn’t have firm plans when I started and tried not to feel pressured to get things done, but I did have a nice mix of being productive and relaxing. Here’s a look back.

Week 1

Week one started with expenses. I know I was off, but I had a lot of expenses in June with travel to multiple places and I needed expenses done. I spent a few hours Monday getting those done and submitted, as well as playing a little guitar and relaxing.

The week had me at the gym, swimming outside for the second time this summer, doing some yoga, and a little yard work, but mostly relaxing. It had been a long May and June, and I took it easy, spent time with my wife, cooked for the kids, and tried to unwind.

This was also almost time for volleyball tryouts, so I was at the gym, running some practice sessions.

Week 2

Week 2 was a bunch of medical appointments. I had a yearly checkup, a dentist, and an ortho appointment that diagnosed golfer’s/tennis elbow. I’ve been bothered for months, but hadn’t done much about it. Not great news, but it did slow me down from doing too much work this week. My wife and spent time running errands around my appointments, we got some supplies for our basement, which was being finished, and I relaxed more. I did some chores around the ranch, but not too many.

Learned how to play “While My Guitar Gently Weeps”, although it’s rough. Need more practice.

We also booked some trips this week for the sabbatical, which have us something to look forward to.

I spent some time this week with volleyball tryouts eating up partial days.

Week 3

Despite my elbow, I had to go to work this week on the ranch. I wrote about this earlier, but this was roof replacement week for our riding arena.

A long week.

Week 4

We finished midday on Sunday with the roof and Monday morning my wife and I were off to Cancun. The plan was Monday – Friday, but we were enjoying it and decided to stay until Sunday.

Expensive, indulgent, but we had a good time at Secrets the Vine, adults-only, all inclusive resort. An amazing view from our room and good food and drinks all week (too many).

I wouldn’t do it again, but despite a good time and enjoying the week with friends, I prefer more movement on vacations, so I’d choose something else. But I’m a weird, type-A, keep moving person.

Week 5

Mostly chores, trying to not aggravate my elbow. I had purchased a few things, like a brush cutter, so I got those things assembled and did some work around the ranch. I also built a tire rack, organizing the spare tires in the shed.

Some gym time, some chores, and some maintenance. I managed to get a couple sprinklers working that had been broken and spent an afternoon at the gym fixing some chairs for the club.

Week 6

I had a quick trip to Chicago for work, coming off sabbatical for an event at Wrigley Field. I had never been, so I was willing to do this. My wife was supposed to come for a 2 day trip, but she cancelled with our other plans so she could work. As a result, I was in town for about 26 hours, and enjoyed myself. A beautiful view from across the street.

It was weird to be back at work and sit in the airport and make a bunch of notes from the event. It’s been awhile since I was typing that much.

I turned around 24 hours later to head to Big Sur, CA with my wife and our oldest. We’d agreed to take him on a trip and we spent 5 days there, bleeding into this week.

It was a fun trip, more our style with biking, hiking, and moving around a bit. It’s a beautiful part of the country and the weather was amazing. Here we are a Bixby Bridge.

Overall

Overall it felt like was retired. I had things to do, but no real time pressure. I didn’t let the 6 week limit drive me, but just moved around day to day. Taking my time on things and not worrying about what got finished and what didn’t.

I could have done more, but it was a very relaxing time and I feel ready to get back to work.

August 15, 2025
Advice I Like: Naps

Learn how to take a 20-minute power nap without embarassment. – from Excellent Advice for Living

I don’t like naps. In fact, I try to avoid them and keep going, even when I’m tired. I’d rather power through things and then go to bed early and get rest.

That being said, there are some times when traveling that I’ve decided to just give in and nap. Turn off distractions, leave my phone out of reach, and just sleep. I’ve even done that a few times during the work week at home when I’m exhausted. Getting 20-30 minutes of rest can be refreshing.

If I sleep. Sometimes I end up laying there and not sleeping and then I feel like I’ve wasted my time.

This is good advice, and I should follow it more often, not just when land multiple time zones away from home.

I’ve been posting New Words on Fridays from a book I was reading, however, a friend thought they were a little depressing. They should be as they are obscure sorrows. I like them because they make me think.

To counter-balance those, I’m adding in thoughts on advice, mostly from Kevin Kelley’s book. You can read all these posts under the advice tag.

August 15, 2025
T-SQL Tuesday #189–AI and your Career

I’m late to the party this month. Taiob Ali has a great invite for a topic that is likely on most people’s minds: AI and your career. I constantly hear people asking about this (well not lately, I’ve been on sabbatical).

I love the T-SQL Tuesday blog party and hope more people participate. Spread the word, ask others to write, and help promote this on socials.

AI and My Career

I’ve been a bit skeptical that AI would really help me. For the last 15-20 months I’ve been using AI in different ways, experimenting with things and seeing where it might be useful. A lot of my use has been in VS Code and Copilot, where I do some coding, and a lot of markdown/HTML management. Across that time I’ve found AI to be more and more useful with reformatting or suggestions completions.

More importantly, I’ve learned to “see” the hints and suggestions quicker and have AI save me time in little ways. None of the items are big, and it hasn’t built me a big piece of code, but I have found it to be very useful in saving minutes. Saving minutes multiple times a day starts to add up in the week and months.

My Outlook

I think AI will help me in my career in two big ways. First, there is the time saving and assistance it gives me that lets me be more productive. I look forward to more agents that can be configured to handle some tasks for me and just get things done. I haven’t been a big Siri/Hey Google person with setting appointments and small tasks, but I can see some of this starting to be more useful over time. I bet I can get some services and agents to do some work for me with natural language that eases my job.

I also think this GenAI tech (and other AI) will help me learn new skills and techniques. I’ve seen some people talking about using an AI to help them learn and I need to do some experimenting here. I tried to get it to build some web apps for me and it didn’t go as smoothly as I’d like, but I’m anxious to see if I can get it to help me learn how to better code in new ways as well as generate code for me.

It’s important to be able to judge if the AI is making good decisions, and that requires knowledge. In some cases, I have that knowledge. In others I don’t, but maybe AI can help me learn.

August 13, 2025
Using SQL Compare to Revert a Stored Procedure
Imagine this situation, someone edits a stored procedure on a production server to “fix” something. However, they broke the procedure and you find out the next day. How do you fix this?

We’ll use SQL Compare since most of you don’t have version control (according to surveys), but you do (hopefully ) have backups. Let’s see how SQL Compare can help.

This is part of a series of posts on SQL Compare.

The Scenario

I get a call one morning that we have problems with a report. This report wasn’t producing the expected values. A user said they saw this:

However,the value the day before had been 2301.54. What was wrong?

Checking with SQL Compare

When I hear this, I think immediately two things:
1. the data changed
2. the code changed
Either is possible, but data is most likely. In this case, when I inquired, the user said no new orders were in the system. While I think humans can easily make mistakes when checking data, code is a possibility.

I asked people, but no one responded with a change being made. So let’s check. I know I have backups, so when I run SQL Compare, I change the source to a backup.

Next, I pick the “add backup files”

I choose my file(s) and confirm they are correct. In this case, just one file. I set the target to my database.

I run the comparison, and I see this. There are a few changes, but the one I’m looking for is my procedure. You can see the code is different.

Arguably, the new code is more correct, but if I need to revert, I can click the deploy button at the top. I’ll want to also just select the SalesReport item.

This will produce a script that I can run in SSMS. I can also just let SQL Compare run this. Note the old code is in the script.

Once I run this, the report works, or at least returns the expected results.

Summary

This is a short demo of using a backup as a comparison source against a database to revert code. In this case, I can see the old code and get that back to ensure my database functions as expected..

SQL Compare is an amazing tool that millions of users have enjoyed for 25 years. If you’ve never tried it, give it an eval today and see what you think.
August 13, 2025