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
41,783 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
5,394 reads
This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.
2020-03-02
10,507 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
22,007 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
23,104 reads
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Comments posted to this topic are about the item What's new in R 4.6
Comments posted to this topic are about the item Interesting Changes in R, which...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers