IT People’s Technical Debt and Reputation Credit

In Canada and USA, when people apply for a credit card or a loan/mortgage, the lending institutions will always do...

OBJECT_ID()–#SQLNewBlogger

 
One of the things that is needed in quite a few functions is the object_id of a particular table/view/procedure/function in...

What has 2 Thumbs and Deleted a LUN with the Log File of a Production DB on it?

That’s right, I did it. I was deleting unused LUNs and the focus somehow jumped from the LUNs for the...

Conditional Formatting and Quick Calcs in Power BI Desktop

There’s a new update out of Power BI Desktop (May 2016), but at the time of writing there’s no official...

Incomp…

This is about analytics.

This is about day to day life.

This is also about how the things should not being done.

Incomp…...

InsideSQL–The Deep Dive

There’s a new conference in London next week, the InsideSQL conference on June 14th. It’s at the CodeNode venue, near...

Power BI Custom Visuals Class (Module 02 – Enlighten Aquarium)

In this module you will learn how to use the Enlighten Aquarium Power BI Custom Visual.  While it might not...

Quick Tests for a Function

I was writing a poorly performing UDF the other day and then wanted to replace it with a better performing...

Share custom solutions in the MinionWare Community Zone

Since we released Minion Reindex over a year and a half ago, we’ve had a ton of wonderful feedback, praise, questions, and...

Sights that just scream, “No!”

I’m at a conference, specifically a security conference. So I looked at the available WiFi connections. Among the conference and hotel specific...