Advice I Like: Fear and Imagination

Fear is fueled by a lack of imagination. The antidote to fear is not bravery; it looks more like imagination – from Excellent Advice for Living

What a neat way to look at things. Most of us have fear. I have fear all the time. I fear illness as I age (or injury), I fear failure at work, I have fear before new presentations. I do think that bravery is just pushing down your fear and continuing on in the face of it.

I certainly don’t think brave people get rid of fear. Maybe they get used to it and it feels less impactful.

However, I haven’t thought about imagination. Though, I do sometimes confront people’s concerns with advice or a suggestion to think it through. It seems often that people afraid of things have too much imagination. They consider, or assign a likelihood score to things that is too high. Most of the time the worst thing isn’t likely to happen, but we fear it.

I do think that if you imagine positively, then perhaps you have less fear. If you look for the good, the opportunity, then you have less fear.

I 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.

Posted in Blog | Tagged , | 2 Comments

Getting More Time from AI

As I get older, I find that time is the most valuable commodity I have. It’s the one thing that I need more of, but I can’t get it. Even if I find more efficient ways of doing things, it seems there’s an endless list of things at work and on the ranch that need to be done.

It seems to be the same for most of my friends in other jobs, whether in medicine, law, or any other position; they’re often overloaded with more work than they can get done in a week. Arguably, it’s not all important work, as sometimes we might tackle a task, only to have our boss throw the work away or delay the project. That’s annoying, but I also understand priorities change.

Mostly, I understand people ask for a lot of things they don’t really need, but because it’s easy to ask. Over time, they may forget about their request or realize they don’t need it anymore. So I tend to do the work I’m asked and then not worry about if it’s really needed.

However, that’s not what this piece is about. Let’s say that you have a useful AI Assistant that can truly produce better code, faster than you can. You trust the coding agent (under your guidance), and it saves you time. Let’s say that this agent reduces your coding load by 30%. Forget the issues with the agent stealing your joy.

A number of studies show that the average developer only codes around 2-3 hours a day. Some might say 4, but that’s just 50% of your workday (I hope). If you save 30% of that time, then you’re saving 1:20 a day, 6:40 a week. That’s a nice chunk of change, but what will you do with the time? Or maybe more importantly, what will your boss expect you to do?

A lot of management might see 30% and expect you to get 30% more coding done (of 40 hours), asking for 12 hours more of work. I see that a lot as management somehow things that developers work 8 hours a day and should get 8 hours worth of code written. When that doesn’t happen, and it never does, they often schedule more meetings to check on your progress. Hence to 2-3 hours worth of actual work.

The smarter group of managers might think that you could get 5 hours more work done (30% of 3/day), and the really smart group of managers might use that time to improve the coding skills of the staff. That’s more than a 10% allocation of time and if focused, could help developers write more efficient code (especially SQL), improve their secure coding knowledge, and perhaps even tackle some technical debt with refactoring of existing problem areas. Maybe you could learn to better judge AI-produced code.

I know that many people are skeptical of AI assistance in coding. I think it’s a tricky thing, but even if the AI doesn’t produce production code, but allows me to conduct a lot of quick experiments that can prove out a hypothesis, I think it can help developers become more productive.

If they learn to use it as a tool and management doesn’t expect it will turn every developer into a 10x (or even 2x) engineer.

If you had more time, what would you do in your work day?

Steve Jones

Listen to the podcast at Libsyn, Spotify, or iTunes.

Note, podcasts are only available for a limited time online.

Posted in Editorial | Tagged | 5 Comments

The Challenge of Implicit Transactions: #SQLNewBlogger

I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick post to show the impact of this setting.

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

The Scenario

You run this code:

2025-09_0086

Everything looks good. I ran an insert and I see the data in the table. I’m busy, so I click “close” on the tab and see this.

2025-09_0087

I’ve gotten so used to these messages, and annoyed by them in SSMS, I click “No” to get rid of it and close the window.

The Problem

A short while later I open a query window to do something related and check my data. I don’t see it.

2025-09_0088

What happened? I had implicit transactions set. This might happen if you mis-click this dialog. Ths option is close to the ANSI_NULL_DFLT_ON option.

2025-09_0089

You could also, or someone could in your terminal (as a poor joke) run this:

SET IMPLICIT_TRANSACTIONS ON

In either case, this means that instead of that insert running as expected, it really behaves like this:

BEGIN TRANSACTION

INSERT dbo.CityName
(
    CityName
)
VALUES
(‘Parker’)

If I don’t explicit commit (or click “Yes”) then this isn’t committed.

Be wary of implicit transactions. It’s a setting that goes against the way many of us work and can cause lots of unexpected problems. This is a code smell I would never want in my codebase.

SQL New Blogger

When I ran into this twice in a week, I decided to spend 10 minutes writing this post. It’s a chance to explain something and give a recommendation. Something every employer wants.

Posted in Blog | Tagged , , | 4 Comments

Local LLM Models at SQL Saturday Boston 2025

I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking, two sessions I think. At least one.

Jones_-_Running_a_Local_GenAI_Model_on_your_Laptop_959193

I’m excited for this session as I’ve had a good time playing with LLMs and hope I can make this interesting for the attendees.

I got asked to also talk about the Data API Builder, but Sessionize doesn’t have that updated, so I’ll be double checking that session today.

Hopefully I see you there. It’s a great schedule, with some talented speakers. There is also a precon from Brent on Friday.

Register today and I’ll see you in the Boston area on Saturday.

Posted in Blog | Tagged , , , | 1 Comment