Who is the best Batman? – A Power BI Analysis of data Introduction Who is the best Batman? We were drinking some cold beers with some friends when someone said that Pattinson was the best Batman. People started to discuss and after 2 hours, the police had to stop the fight. The discussion inspires me […]
The post Who is the Best Batman in Power BI appeared first on SQLServerCentral.

Flyway provides a database-independent way for a team to track, manage and apply database changes, while maintaining strict control of database versions. It updates a database by running a series of versioned migration scripts, in order, and keeps track of all the changes in a special "schema history" table. It sounds simple, but it is easy to derail this team discipline if you don't find the right answers to the following questions…
The post Flyway How-tos: a User’s Perspective appeared first on SQLServerCentral.

You can automate Power BI table refreshes using PowerShell, an Automation Account, and Runbook. Dennes Torres explains how in this article.
The post How to automate table level refresh in Power BI appeared first on SQLServerCentral.

The payback of DevOps is not simply in automation but in using that automation to increase the visibility of the development processes. This article demonstrates way to make Flyway developments more visible, regardless of your RDBMS, such as by providing a detailed migration history, and change reports that reveal detail of what is going on to all involved.
The post Database Development Visibility using Flyway and PowerShell appeared first on SQLServerCentral.

A short story about why standards matter and where they can help you with limiting the off hour calls from others in your organization.
The post Standards Matter appeared first on SQLServerCentral.

MySQL stored procedures are objects containing one or more SQL statements for reuse. They often contain business logic. Robert Sheldon demonstrates how to create and call stored procedures.
The post Working with MySQL Stored Procedures appeared first on SQLServerCentral.

My FlywayTeamwork PowerShell framework is designed to help get you started quickly with developing databases, using Flyway versioned migrations. It introduces a PowerShell task library, and automation, to take care of repetitive chores. It will also help you get to grips with the practicalities of using Flyway in team-based development. This article explains the basics of its design and provides a demo how to use Flyway to migrate a PostgreSQL database, while generating a high-level narrative of the changes made between versions.
The post What is the Flyway Teamwork Framework? appeared first on SQLServerCentral.

How to use Redgate's schema comparison engines to generate object-level scripts for every database version that Flyway creates, and then use them to create ad-hoc, Flyway-compatible migration files.
The post Creating Flyway Migration Files using Redgate Schema Comparison Tools appeared first on SQLServerCentral.