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.

Expert-led PASS Data Community Summit Pre-cons

Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth.
Register now

Sign up to PASS Data Community Summit 2022

There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Register now.