Your SQL Server query is fast when you run it in SSMS. It's slow in your application. But why?

A TSQL solution for parsing file names, with a little help from an old DOS trick.

Monitoring SQL Server TRUNCATE TABLE operations has always been a challenge. But I think I've found a workable solution with Extended Events.

Specifying a collation in WHERE clause predicates can result in scan operations, even when there is an underlying index. Can we coerce SQL into using Index Seeks?

Introducing the Fediverse: a New Era of Social Media

A (mostly) simple option that doesn't require any I/O...or the need for a large maintenance window.

Enshittification strikes again. It's gotten so bad on LinkedIn, I deleted my account.

After more than 30 years, Microsoft has finally pushed me away from their OS.

StackOverflow reverted my 'edit' and suspended my account for a week.

I started my first full time job as a junior developer in May 2000. What have I learned in that time?