A Lack of Excitement
I usually use all the problems, crashes, and issues that I run into at work as grist for my mill,...
2009-12-23
658 reads
The Scary DBA
Apology
I’ve been somewhat light in my blogging of late. Unfortunately, I just haven’t hit any interesting or difficult problems lately...
2009-12-22
532 reads
What is Your Greatest Weakness
I was tagged earlier this week by Tim Ford to comment on my biggest weakness. I wish I could say...
2009-12-15
785 reads
T-SQL Tuesday #1: Date/Time Tricks
I’m going to try out Adam Machanic’s idea for a blog party. The topic this month are Date/Time tricks.
Instead of...
2009-12-08
665 reads
Dr. DeWitt’s Key Note at the PASS Summit
If you missed this, here’s your chance to make it up. If you were there, and like me, you need...
2009-12-02
723 reads
SQL Standard Update
Andy Warren in the latest PASS Connector has posted an update on where we’re at with the SQL Server Standard....
2009-12-02
648 reads
How do -You- use SQL Server
I’ve been tagged by a misplaced yankee, uh, New Englander, whatever. The question is, how do I/we use SQL Server...
2009-12-01
776 reads
SQL Saturday #34/New England Data Camp v2.0
It’s official sports fans. Well, it’s been official since last week since Adam Machanic set up the web site. The...
2009-11-30
1,381 reads
XQuery For Idiots
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...
2009-11-30
1,747 reads
SQL Server XQuery For Idiots
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...
2009-11-30
1,532 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers