by Jeanne Combrinck | Jul 27, 2018 | SQL Girl
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...
by Chris Webb | Jul 26, 2018 | Chris Webb
It’s my pleasure to announce that version 2 of the white paper that I co-wrote with Melissa Coates, “Planning A Power BI Enterprise Deployment”, is now live and can be downloaded from here. The title should give you a pretty good idea of the subject matter: the aim is...
by Paul Hansen | Jul 26, 2018 | Power BI
We are excited to announce that we have just released the July update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release: Public… This post first appeared...
by Paul Hansen | Jul 25, 2018 | Power BI
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...
by Jeanne Combrinck | Jul 25, 2018 | SQL Girl
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...