Select Page

Merge Statements

Over the years I have come across a lot of merge statements and I find most of the time there is one fundamental flaw in how it is written by most people. In the update section in most cases I find that there is no section there to check if anything has changed...

Power BI and SharePoint – the road ahead

SharePoint is an important part of how many organizations organize and distribute BI content to users. In recognition of how important this approach is, we’ve invested in modernizing and creating… This post first appeared...

Querying Data in Temporal Tables

Following on from my previous post about modifying data in a temporal table, I will be looking into querying the data in this post. When you want to get latest (actual) state of data in a temporal table, you can query the same way as you query a normal table. If the...