If the title isn't obvious enough, this blog post is about the new function GREATEST, and it's sibling LEAST. But…
I'm delighted to announce I'm selected to give an introduction to Snowflake on Azure at the virtual Techorama event. You…
I recently finished the book Calling Bullshit - The Art of Skepticism in a Data-Driven World by Carl T. Bergstrom…
It's T-SQL Tuesday time again, and this month's honor to host the blog party goes to Brent Ozar. The topic…
I had the extreme pleasure recently to extract some data out of an Oracle database. I wrote the source query…
The title says it all, but I'll explain it anyway. When building a data model that will be used for…
In the December 2020 release of Power BI Desktop, a long-awaited feature was added as a preview: small multiples (also…
When you have a very large fact table in Analysis Services Tabular, you most likely have it partitioned. Suppose you…
At February 25th March the 4th 2021 I'll be giving a webinar on the MSSQLTips.com website. The topic is Integration…
At least there's one consistency in the year 2020: every day amazing articles are published on the MSSQLTips.com. And the…