Multi-Database Marked Transactions

Poor Database Design Realities

Steve sees that poor database design is the reality of the world and we have to work around that.

T-SQL Tuesday #174 – My Favorite Interview Question

This month is a great topic to me. I think growing and improving your career is a skill that most of  us could improve, especially in our younger years....

Logon Trigger Messages

Using AI for the First Draft

What is an AI LLM useful for? Steve thinks a first draft is not a bad way to look at your AI results.

DBCC CLONEDATABASE is Semi-Discontinued

Microsoft is no longer supporting some uses for DBCC CLONEDATABASE. Read a few of Steve's thoughts on the change.

The SQL Assessment API

A New Word: desanté

desanté – n. the brooding delirium of being sick, which makes time slow to a trickly and turns even the most pathetic of tasks into monumental struggles, until the...

Adding Hints with Query Store

Denver Dev Day – Best Practices for Database Deployments Resources

I delivered a talk today on database deployment best practices at the Denver Dev Days 2024. This is a great event, and I have been lucky enough to attend...