Does The Join Order of My Tables Matter?

Photo by pan xiaozhen on UnsplashI had a great question submitted to me (thank you Brandman!) that I thought would make for a...

Does The Join Order of My Tables Matter?

I had a great question submitted to me (thank you Brandman!) that I thought would make for a good blog post:

...I've been wondering if it really matters from a...

SQL Server on Linux Installation On RHEL Server – PART1

In the previous posts, we learned how toinstall SQL Server on Ubuntu Server&install SQL Server on CentOS. Today, we’ll walk...

SQL Saturday Returns to Rochester!

I am very happy to announce that SQL Saturday returns to Rochester, NY on March 24, 2018. This is the Flour/Flower City’s seventh SQL Saturday and SQL Saturday #723...

SSIS script task successfully executed. Or not?

Issue
Recently we came across an interesting issue. I guess this will not happen often, but I think it’s worth mentioning...

Sessions, Temporary Objects, and the Afterlife

For thousands of years theologians have offered various thoughts on the question of what happens when we die. Does some...

What is Azure Databricks?

Azure Databricks (documentation and user guide) was announced at Microsoft Connect, and with this post I’ll try to explain its use...

What is Azure Databricks?

Azure Databricks (documentation and user guide) was announced at Microsoft Connect, and with this post I’ll try to explain its use...

Eliminating Hassles

It is easy for me to fall into the trap of the “who” versus the “what”. If we are not...

Get That Profiler Feel in Extended Events

I know. You love Profiler. I hear you. You’re wrong, but that’s OK. Kidding… mostly.
Unfortunately though, I think a lot...