Start Fixing Your DB with Better Code
The best way to improve your database performance is with better code. We all know that, but few of us actually end up making those changes.
2025-10-10 (first published: 2017-11-16)
596 reads
Editorials
Is Rolling Back The Same as Failing?
When you must rollback a deployment of changes, is that a failure of the process? The development effort? Or something else?
2025-10-08 (first published: 2014-03-04)
303 reads
Getting Fired
When should a DBA get fired? Steve Jones thinks it should be rare and gives you two cases.
2025-10-06 (first published: 2014-03-27)
704 reads
Lessons from the Postmark-MCP Backdoor
The Koi Security team recently uncovered the first known, malicious MCP server in the wild: a package called postmark-mcp, downloaded over 1,500 times per week, that silently BCCs every outgoing email to an attacker-controlled domain. So, what happened? High-level, a lot: The attacker cloned the legitimate Postmark MCP repository, made one small but nefarious change […]
2025-10-04
195 reads
2025-10-03
93 reads
PRs Are Like Trouble Tickets
Adopting a modern development approach brings with it the need to manage PRs, which Steve thinks can be like trouble tickets.
2025-10-01
118 reads
2025-09-29
173 reads
Building AI Governance and Policies- First Steps
AI has moved from experimental to operational in record time for many organizations. In industries like fintech, healthcare, and retail where sensitive PII (personally identifiable information) and relational databases are the backbone of daily operations, this innovation speed to adopt AI brings enormous opportunity, but also significant risks
2025-09-27
94 reads
Don't Forget About Financial Skills
A bit of advice from Steve to ensure you do not neglect the management of your finances for the long term.
2025-09-26
108 reads
Getting More Time from AI
Today Steve wonders what you might do with extra time if the AI can give it to you.
2025-09-24
92 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers