Disabling and enabling triggers

I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now...

Hugo’s SQL Server Execution Plan Reference

I’m a big fan of T-SQL Tuesday. Each month there is a host who comes up with a topic, and...

SQL Homework – March 2019 – Reconfigure tempdb

You’ve heard of tempdb right? It’s one of the system databases. All of the system databases are important but poor...

Dipping into the Cookie Jar: T-SQL Tuesday #112

This month our intrepid host for T-SQL Tuesday is Shane O’Neill (b/t). He’s asked us to talk about our cookies....

DBA Myths: Can a differential backup get bigger than the full backup?

The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one...

Dem queries

Dem queries, dem queries, dem slow queries,

Dem queries, dem queries, dem fast queries,

Dem queries, dem queries, dem big queries,

Now write...

Using the Microsoft Authenticator app to log into Azure

So I was trying to work on a blog post about the new truncation error this morning and realized I...

Why do I (they) own that database?

Ever looked at the list of databases and wonder why you own one of them? Or why some other user...

Disabling Indexes

Indexes are probably the number one tool we have to improve performance. That said, there are times when we want...

Error in SSMS: Attempted to read or write protected memory.

There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked...