2025-09-02 (first published: 2025-08-04)
335 reads
Uncategorized
Hack Your Brain
Now, let's be really clear up front, I don't mean getting a surgically implanted chip in your head, done on your kitchen table. Brain hacks are generally either, forming habits that are good for learning and concentration, changing how you do things to help enhance your brains function, eating differently in support of brain health, […]
2025-08-02
105 reads
Model Context Protocol (MCP): A Developer’s Guide to Long-Context LLM Integration
Large Language Models (LLMs) like Anthropic’s Cl...
2025-09-02 (first published: 2025-08-01)
817 reads
How to safely and surgically restore filegroups
Most DBAs are familiar with full and differential ...
2025-09-02 (first published: 2025-08-01)
770 reads
Get Your Chores Done
I grew up in a pretty rural environment, in the southern US, in what's considered the Old West (Jesse James, reportedly, had a hideout a few miles from my current home, the Daltons, Belle Star, I can keep going, all came through this part of Oklahoma). Here, we call our daily tasks, like taking out […]
2025-08-01
88 reads
Best Way to Repair SQL Database: How to Restore SQL Server?
Summary: SQL Server administrators frequently enco...
2025-07-30
652 reads
2025-07-30
1,719 reads
A Little Appreciation
I'd like to take a moment and simply voice my appreciation for Steve Jones. Steve's still on sabbatical, so I've been doing some of the work, along with my co-worker, Kellyn Gorman (who I also appreciate, very much). I'm sure you've noticed. Oh, not simply that the editorials are different. That's to be expected. Nah, […]
2025-07-30
98 reads
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
When a SQL Server Express-based factory app started crawling, the culprit wasn’t hardware or network — it was a decades-old WHILE loop migrated from C/C++ to SQL. This real-world story breaks down how procedural habits, memory grants, and lack of window functions nearly derailed a production floor.
2025-07-28
14,241 reads
Planning for the Right Emergency Response
I'm currently testing a pair of POC radios <editor: can no one shut him up about the radios?> No, go away. So, where was I, oh yeah, POC radios. What are they, I hear you asking. <editor: no one asked that> Hush. Push-to-talk Over Cellular. POC or PoC. In short, you get a SIM card […]
2025-07-28
76 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
extended events to spy on our server between 8 and 9 am
Hi, our peer who owns a remote mysql server from which we extract warehouse...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers