What is my why?–T-SQL Tuesday #111

This is an interesting question from Andy Leonard for T-SQL Tuesday: What Is Your “Why”? He is this month’s host...

Why make?

This post is a response to this month’s T-SQL Tuesday #111 prompt by Andy Leonard.  T-SQL Tuesday is a way...

“SSPI handshake failed” \ “The login is from an untrusted domain” errors

I’ve recently encountered an issue that was difficult to resolve and I didn’t find the particular cause that was troubling...

It’s always parameter sniffing: Line Endings

Combining a few themes of recent posts today. I’ll mix in some sp_executesql, it’s always parameter sniffing, and the plan...

SQL Server Script To Check Your Backup RPO Status

I recently wanted a script to tell me that for every database on a given server
What levels of backups I...

What Data Is Being Sent Externally By Power BI Visuals?

As you build your Power BI reports, you may want to use maps and custom visuals. Have you thought about...

A short guide to sp_executesql

Last week I talked about single use plans. One way to increase execution plan re-use is to parameterize queries by...

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

Editorial – Dealing with Ugly Babies

One thing I learned while working as a database administrator over 17 years is the importance of teamwork across departments....

Partitioning 1: Non-partition aligned queries

Here’s my take on partitioning. I’ll be focusing on getting queries to perform on partitioned tables, and not on partition...