How to Work with On-Premises AI Models to Generate T-SQL Code
See how a small local model performs on some SQL tasks. This shows how Ollama can run a model on your laptop.
Imagine the Physical World
Today Steve notes that he often compares the work a computer does to what might happen if the same actions occurred in the physical world.
How SQL Server maintenance becomes an attack path – and what to do about it
The article covers four connected areas: over-privileged database users, msdb and SQL Server Agent exposure, privileged maintenance jobs, and trigger-based permission hijacking.
Managing Incidents and Fighting Fires
Managing incidents as a DBA /DB manager and some of the key things you should be doing.
BIT_COUNT in SQL Server
Learn how the BIT_COUNT() function works and how it enabled operations where data is stored in bits.
Power BI Best Practices
In this tip, we’ll look at some best practices to help you get the most out of your models. We will also look the DAX formula language.
Are You Working More Hours?
AI is causing some people to work more, which seems at odds with the idea of what AI should be: a useful tool.
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
As database changesets accumulate over time, they gradually become more than deployment artifacts. This level explores how a well-organized changeset library evolves into a replayable representation of the database’s structural history, supporting not only reliable deployments but also reconstruction, auditing, and long-term maintainability. Through practical examples and a real-world case study, it shows why maintaining coherent Create and Rollback scripts continues to provide value long after a successful production deployment.
T-SQL in SQL Server 2025: REGEXP_LIKE
This article goes into one of the new regular expression functions in SQL Server 2025: REGEXP_LIKE().
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers