Data Scholar

Latest Posts

This article has been originally published on SQL Shack. In this article, I am goingContinue reading “Dynamic Pivot Tables in SQL Server”

by Aveek November 24, 2020

The default version history table for Flyway has been changed to {schemaname}.flyway_schema_history from Flyway 7.0Continue reading “Updating Schema History table for Flyway”

by Aveek November 15, 2020January 14, 2021

This article has been originally published on SQL Shack. In this article, I’m going toContinue reading “Understanding Dynamic Data Masking in SQL Server”

by Aveek November 2, 2020November 26, 2020

In this article, I’m going to list out some of the most common warnings weContinue reading “Warnings in SSAS Cubes”

by Aveek April 12, 2020January 15, 2021

This article was originally published on SQL Shack. In this article, I’m going to explainContinue reading “Introduction to Many-to-Many Relationships in SSAS”

by Aveek April 1, 2020January 15, 2021

This article was originally published on SQL Shack. In this article, I’m going to explainContinue reading “Setting up Power BI Data Gateway”

by Aveek March 30, 2020January 15, 2021

Loading…

Something went wrong. Please refresh the page and/or try again.