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
654 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
531 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
721 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
773 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,380 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,745 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,531 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers