Introduction Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not robust and not reusable. In order to reuse the same piece of code, […]
2020-04-21
35,473 reads
Business users get great value from SSAS cubes. In this article, learn how to create a drill-through action in an SSAS multi-dimensional model cube.
2020-03-09
4,277 reads
This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.
2020-03-02
9,441 reads
This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.
2020-02-25
11,895 reads
Introduction In Financial Data, analyzing the Moving Average (MA) is a very common practice. The direction of the moving average conveys important information about prices, whether that average is simple or exponential. A rising moving average shows that prices are generally increasing. A falling moving average indicates that prices, on average, are falling. This article […]
2020-02-04
18,943 reads
Well, turns out code signing is pretty complex, so I’m writing this blog post...
By Steve Jones
For those that attended my talk at Denver Dev Days, here are the slides:...
By Steve Jones
As a part of my AI experiments, I decided to ask CoPilot to write...
Comments posted to this topic are about the item Software Flexibility (Avoiding the next...
Our IT department contacted me recently and asked if they should change the default...
Ask SSC