Book Review: Sapiens: A Brief History of Humankind

Sapiens: A Brief History of Humankind, by Yuval Harari, made it on my reading list after hearing about Mark Zuckerberg’s...

Comparing the contents of two tables Redux

I did a post the other day on comparing two tables. It was meant as a general overview but I...

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