In this article, you will learn how to configure an RDS database for connections from client tools.
The post Amazon RDS - Configuring a Connection to a SQL Server Instance appeared first on SQLServerCentral.

Learn about SQL Server triggers and how to use them for inserts, updates, and deletes on a table, along with step-by-step examples.
The post An Introduction to SQL Triggers appeared first on SQLServerCentral.

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.
The post Try Before You Commit in Flyway appeared first on SQLServerCentral.

This article shows how you can query your database files to get metadata about them and use that to get the reads, writes, and other IO statistics.
The post How to get IO statistics of SQL Server database files appeared first on SQLServerCentral.

Learn how to refresh a Power BI dataset by integrating Power Automate into the report.
The post Refresh a Power BI Dataset using Microsoft Power Automate appeared first on SQLServerCentral.

The post Flyway Enterprise is here... appeared first on SQLServerCentral.

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.
The post SQL LIKE Statement for Various Text Patterns appeared first on SQLServerCentral.

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.
The post How monitoring tools can help you excel at your job appeared first on SQLServerCentral.