18 March 2016 – Pardaan.com

How-to: Sort Columns – SETASCENDING

Since NAV 2013 we are more and more getting the full potential out SQL Server. In NAV 2009 (and before) it was, for example, unimaginable to setup "your own" sorting for your data retrieval as SETCURRENTKEY only allowed you to use the keys defined on the…

18 March 2016

Data & Analysis

Dynamic Column Selection In Custom Columns In Power BI/Power Query/M

When you’re writing an M expression for a custom column in Power BI or Power Query it’s easy to reference the values in other columns. A slightly more difficult question, however, is how can you reference column values dynamically? For example, given the following input table:…

18 March 2016

Dynamics NAV & BC Tips & tricks

My SQL Server 2014 gets flooded and stops responding

All right, I must confess; my SQL Server is not installed on a super computer. Also, it is not installed and configured by a SQL Server MVP nor by Alain Krikilion. The Hyper-V machine running my SQL Server is using two processors and 12GB of memory.…

18 March 2016