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
37,409 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,505 reads
This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.
2020-03-02
9,523 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
12,963 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
19,733 reads
Last week we discussed advantages of recompilation in Common Mistakes in SQL Server – Part...
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Comments posted to this topic are about the item The Need for DevSecOps
Comments posted to this topic are about the item A Reuseable Window
Comments posted to this topic are about the item Sentiment Analysis with IA
Ask SSC