There are moments in technology when the ground shifts beneath our feet. Moments when the tools we once thought of as reliable utilities suddenly become engines of transformation. SQL...
2025-10-06
177 reads
Why Developers Shouldn’t Have sysadmin access in SQL Server
7 reasons—and exactly what to do instead
It can feel “faster” to hand developers sysadmin. In reality, it’s like giving them the master...
2025-10-06
554 reads
ecstatic shock – n. a surge of energy upon catching a glimpse from someone you like, which scrambles your ungrounded circuits and tempts you to chase after that feeling...
2025-10-03
27 reads
The New Arena of Leadership The role of the Chief Data Officer is no longer about governance alone. It is about vision. It is about turning data into the...
2025-10-02
26 reads
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily create database snapshots. This new version fixes a bug that we’ve found in version 2...
2025-10-24 (first published: 2025-10-02)
1,552 reads
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth, blocks covering-index usage, and makes code brittle when schemas change. Specify only the columns you...
2025-10-02
73 reads
In parts 1 and 2 of this series, we’ve gathered info and done the triage just like anyone in almost any industry does At this point you’ve: Defined what...
2025-10-27 (first published: 2025-10-01)
1,753 reads
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there was a great question that I wasn’t sure about. Someone asked about the download size...
2025-10-01
68 reads
After setting up dozens of Internet of Things (IoT) smart home devices, I started to wonder: how hard could it be to build one from scratch?
I needed a project...
2025-10-01
31 reads
Are you diversifying your DBA skillset? My recent job search made one thing clear: the database landscape is broader than just SQL Server and Oracle. More and more companies...
2025-09-30
155 reads
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Comments posted to this topic are about the item Absolute and Relative References
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I