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”

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”