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...

Querying temp tables across a linked server.

And if you are still reading you probably fit into one of the following categories.
Not a DBAA relatively new DBALike...

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....

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...

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...

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...

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...

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...