Au Revoir for now
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight for Brussels and this is my last day at work for a couple of weeks....
2026-10-07
5 reads
Blog Posts
Local Models Using GPUs with Ollama
Can you use your GPUs when running a local model under Ollama? You can, and it really depends on how you run Ollama and what your hardware is. Ollama...
2026-10-07 (first published: 2026-09-23)
158 reads
Microsoft Tools for Making Data AI-Ready
Making Data AI-Ready, Part 2 (This is the second article in a three-part series on making data AI-ready. Part 1 covered the fundamentals of AI-ready data, this article looks...
2026-10-07 (first published: 2026-09-24)
596 reads
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting something a little more practical for day-to-day DBA work. Something I could open, work through...
2026-10-05 (first published: 2026-09-22)
477 reads
Don’t Fear the Technology
The concern that a particular technology is going to destroy the world seems to be an ever present fear. The technology changes but the fear and the marketing around...
2026-10-05 (first published: 2026-09-22)
370 reads
Goodbye, Microsoft
A few years ago I took a new job at Microsoft, working as a Senior Content Developer, and as of this writing I own all the SQL Server content...
2026-10-05
102 reads
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But why keep this important visual warning at the bottom of the screen? In this post,...
2026-10-05
33 reads
The SUM of Nothing: #SQLNewBlogger
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that Look Too Easy. I decided to give you a few thoughts from me on the...
2026-10-05
23 reads
Architecting Zero Downtime Deployments–Day of Data Boston
Here are the resources for my talk at Day of Data Boston. Slides – ArchitectingZeroDowntime.pptx Slides also at: https://dayofdata.org/2026-10-03-dayofdata1150/#schedule Code: https://github.com/way0utwest/ZeroDowntime Book: Refactoring Databases Some interesting questions. I’ll write...
2026-10-04
23 reads
Creating a Local Model Chatbot on Windows
After my session at VSLive last week, I had a few questions from the audience. I’m adding some of these into blogs, and this was one: How do I...
2026-10-02 (first published: 2026-09-21)
531 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers