Dynamic Pivot Tables in SQL Server

This article has been originally published on SQL Shack. In this article, I am going to explain how we can create a dynamic pivot table in SQL Server. Pivot tables are a piece of summarized information that is generated from a large underlying dataset. It is generally used to report on specific dimensions from theContinue reading “Dynamic Pivot Tables in SQL Server”

Updating Schema History table for Flyway

The default version history table for Flyway has been changed to {schemaname}.flyway_schema_history from Flyway 7.0 onwards. However, for backwards compatibility, we need to set it to fallback to the previous table name {schemaname}.schema_version. Steps to update Go the the flyway configuration file. On MacOS, it can be found under the following directory – ‘usr/local/Cellar/flyway/7.2.0/libexec/conf/flyway.conf‘. FindContinue reading “Updating Schema History table for Flyway”

Understanding Dynamic Data Masking in SQL Server

This article has been originally published on SQL Shack. In this article, I’m going to explain the Dynamic Data Masking feature in SQL Server. As it goes by the name, Dynamic Data Masking is one of the security features that was introduced in SQL Server 2016. In an ever-growing digital era, the security of ones’Continue reading “Understanding Dynamic Data Masking in SQL Server”

Warnings in SSAS Cubes

In this article, I’m going to list out some of the most common warnings we encounter while developing SSAS Cubes and the reason for those warnings. As you are aware, SSAS cubes are developed using the SQL Server Data Tools (SSDT) for Analysis Services (Visual Studio), all the examples will be taken from Visual StudioContinue reading “Warnings in SSAS Cubes”

Introduction to Many-to-Many Relationships in SSAS

This article was originally published on SQL Shack. In this article, I’m going to explain what many-to-many relationships in SSAS are and how to implement the same in a SQL Server Analysis Services (SSAS) project. For the sake of this article, we will only consider the Multidimensional Cube and not the Tabular. Also, this articleContinue reading “Introduction to Many-to-Many Relationships in SSAS”

Setting up Power BI Data Gateway

This article was originally published on SQL Shack. In this article, I’m going to explain what a Power BI Data Gateway is and how to set it up. I’ll also cover the underlying architecture that the gateway uses and how to manage on-premise data using the Data Gateway. Please note that this article is notContinue reading “Setting up Power BI Data Gateway”

Conditional formatting in Power BI

This article was originally published on SQL Shack. In this article, I’m going to explain what conditional formatting in Power BI is. Conditional formatting, as the name suggests, is a way of visualizing data that applies special format rules based on some pre-defined conditions on the values of a selected metric. It is mostly usedContinue reading “Conditional formatting in Power BI”

Sort Months Chronologically in Power BI

This article was originally published on SQL Shack. In this article, I’m going to demonstrate how to sort months chronologically in Power BI. Visualizing sales data in a time period is one of the most influential ways of reporting. Often, at times it is essential that you design charts that show the trend or growthContinue reading “Sort Months Chronologically in Power BI”

Execution Plans in SQL Server

This article was originally published on SQL Shack. Introduction In this article, I’m going to explain what the Execution Plans in SQL Server are and how to understand the details of an execution plan by reading the various metrics available once we hover over the components in the plan. Being a Data Professional, it is very essentialContinue reading “Execution Plans in SQL Server”

Introduction to Row Level Security in SQL Server

This article has been originally published in SQL Shack. In this article, I’m going to discuss Row-Level Security in SQL Server. RLS or Row-Level Security as the name suggests is a security mechanism that restricts the records from a SQL Server table based on the authorization context of the current user that is logged in.Continue reading “Introduction to Row Level Security in SQL Server”