New Flyway Course on Redgate University

Flyway Desktop is the newest way to automate database deployments. In this brand new course Kathi Kellenberger provides an overview of DevOps, including definitions, tools, and demos of some of the advanced features available in Flyway Desktop.

Refresh a Power BI Dataset using Microsoft Power Automate

Learn how to refresh a Power BI dataset by integrating Power Automate into the report.

Try Before You Commit in Flyway

Sometimes we want to check whether it is possible to run a Flyway migration without error, but not actually make the changes. We might just need to 'sanity test' the performance of a migration on the Staging server, for example. By using a placeholder 'switch' to trigger a SQL Exception, we can get Flyway to roll-back its transaction, and therefore the migration, on demand.

Flyway Enterprise is here...

SQL LIKE Statement for Various Text Patterns

In this article, we look at how to use SQL LIKE statement to find various text patterns contained within a set of text along with many different examples of how to use LIKE.

Build Your Own SQL Server Central Monitoring Solution with PowerShell

In this article, we look at how to use PowerShell scripts to query all of your SQL Server instances to build your own central monitoring solution.

How monitoring tools can help you excel at your job

Want to make the most of your scarce resources and do your job even better? Join us at PASS Data Community Summit, from November 15-18, and learn how database monitoring tools can speed up your maintenance tasks and give you the time to support strategic initiatives.

Join a community like no other at Summit

There's less than one week until PASS Data Community Summit takes place, and there's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Register now.

Refresh a Power BI Dataset using Microsoft Power Automate

Learn how to refresh a Power BI dataset by integrating Power Automate into the report.

Backing up MySQL Part 1: mysqldump

mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because it’s very basic and quite powerful – mysqldump database backup tool is command line-based, very simple and very straightforward to use. As far as MySQL or its flavors (MariaDB and Percona Server) are concerned, this command line-based tool is one of the top choices for junior and senior database engineers across the world alike.