Reading a SharePoint List with Azure Logic App

5 years ago

Sometimes in life you have to do things you really don't like to do. Such as extracting data from a…

Quickly Editing Data in SSMS

5 years ago

WARNING: do not do this in production. A quick blog post on a SSMS trick: how to quickly edit data.…

SUMX returns incorrect results with duplicates

5 years ago

Okay, the title of this blog post could also have been "SUMX returns unexpected results with duplicates". The results only…

Cool Stuff in Snowflake – Part 11: RESULT_SCAN

5 years ago

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight…

Author of the Year 2019 Nomination at MSSQLTips

5 years ago

This year I've been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine…

Cloudbrew 2019 – Slides

5 years ago

Cloudbrew 2019 is over and it was a great event. Great speakers and a big audience. Even in my session…

Book Review: T-SQL Window Functions by Itzik Ben-Gan

5 years ago

A couple of years back Itzik Ben-Gan (the T-SQL guru) wrote the book Microsoft SQL Server 2012 High-Performance T-SQL Using…

T-SQL Tuesday #121: Gifts received for this year

5 years ago

It's T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the subject is looking back at the…

Refresh Power BI Dataset using Logic Apps

5 years ago

A recent blog on the Power BI website announced the availability of a preview component in Microsoft Flow, which allows…

Cool Stuff in Snowflake – Part 10: RATIO_TO_REPORT

6 years ago

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll…