Limit the Blast Radius
AI can go off the rails, as we see in a recent story about an LLM deleting a production database.
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
After defining the deployment contract in the previous level, this article focuses on validating a changeset before it reaches production. Rehearsal across environments ensures that execution order, rollback behavior, and baseline alignment all behave exactly as expected.
You Can’t Trust “Edit Query Text” in SSMS’s Execution Plans.
When there are IF branches or conditional logic, “Edit Query Text” only shows you the branches that actually executed. It’s easy to miss whole swaths of code that didn’t happen to execute one particular time.
Bean Counting to Burnout
Do meetings and paperwork take a toll on administrators? Steve draws a comparison to some of the changes in the US healthcare system.
Coping with a working life as an imposter
It is not existing knowledge but the skill of acquiring new knowledge rapidly that will help you overcome imposter syndrome.
Fixing Impostor Syndrome
Lessons on impostor syndrome from a marketer apply to technologists as well.
The Degradation of the Turing Test
Are computers getting smart enough to pass the Turing test or are humans getting worse at representing themselves as intelligent?
What Can AI Really Do?
Steve asks you what you think AI can do for you today, with a few suggestions of what he sees.
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Built the index, but SQL Server still scans the whole table? Learn how to read execution plans and find exactly why your index is being ignored.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers