Forcing Execution Plan

Very rarely there is a need to force an execution plan and even more rarely we should be doing it....

Silly Photos at Work

Someone I stumbled across this picture of @brento on my drive.

This might be the best one:

And this was a good...

Paper Model of Hubble Telescope

Not even close to being about SQL, I ran across the plans for a paper model of the Hubble Telescope while...

The need for having both a DW and cubes

I have heard some people say if you have a data warehouse, there is no need for cubes (when I say “cubes” I am referring to tabular and multidimensional OLAP...

The need for having both a DW and cubes

I have heard some people say if you have a data warehouse, there is no need for cubes (when I...

Selecting a Random Row From a Table

A couple of times recently I’ve seen the question asked, ‘How can I select a single row at random from...

Friday Reading 2018-07-20

Haven’t posted one of these for a while! It’s good to have some time back to be able to read/write.
I’ve...

My #SQLCareer Day–July 19

I’ve asked for #SQLCareer posts, and I haven’t done any. My job isn’t a data platform DBA or developer, but...

Getting Schooled by Brent

Earlier this year Brent Ozar invited me to attend some of his online classes for free. Free is good! Training...

SQL Solver

A few months back I ran across this article for checking semantic equivalencies of queries. That’s interesting, from the perspective...