Blog

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”

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”

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”

Loading…

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


Follow My Blog

Get new content delivered directly to your inbox.