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)
429 reads
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)
429 reads
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)
269 reads
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)
655 reads
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
128 reads
2025-10-03
77 reads
Adopting a modern development approach brings with it the need to manage PRs, which Steve thinks can be like trouble tickets.
2025-10-01
108 reads
2025-09-29
136 reads
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
54 reads
A bit of advice from Steve to ensure you do not neglect the management of your finances for the long term.
2025-09-26
92 reads
Today Steve wonders what you might do with extra time if the AI can give it to you.
2025-09-24
82 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Hi, our peer who owns a remote mysql server from which we extract warehouse...
What is returned as a result set when I run this command without a new seed value?
See possible answers