Locking & Blocking
On the gridiron, two opposing teams are contending for one very limited resource, the football. One team has it; the...
2009-12-08
522 reads
Handling Inconvenient Requests
"You can have everything in life that you want if you will just help enough other people get what they...
2009-12-08
741 reads
Database Books
Well my theory on posting every week has been tested to the limit somewhat and I didn’t get anything written...
2009-12-08
451 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
Are trivial plans cached?
It is sometimes said that trivial execution plans are not cached and queries that have such plans are compiled on...
2009-12-08
1,241 reads
The Numbers Don’t Lie… Except When They Do
There are few things more reassuring for a data professional than having clean, consistent data to back up critical business...
2009-12-08
627 reads
December Patches
I note these for Database Weekly, but I haven’t blogged about them. A mistake on my part.
The December patches from...
2009-12-08
501 reads
T-SQL Tuesday #001 – Dates and Times
T-SQL Tuesday was started by Adam Machanic (@AdamMachanic) on his blog to encourage SQL Bloggers to share their tips and...
2009-12-08
463 reads
Age calculation with SQL Server
There seem to be many different methods being suggested to calculate an age in SQLServer. Some are quite complex but...
2009-12-08
1,137 reads
Fundamentals of Storage Systems – RAID and Hard Disk Reliability, Under the Covers
In the last RAID article we covered the basics. This is a little deeper dive into the underlying mechanics of...
2009-12-08
1,523 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
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...
Forums
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries
The Service Name
Comments posted to this topic are about the item The Service Name