Performance tests are central to the quality of the database changes we deliver because they ensure that any business process that accesses the database continues to return its results in an acceptable time. When Flyway creates a new version of the database, it is the ideal time to run these performance checks.
The post Performance Testing Databases with Flyway and PowerShell appeared first on SQLServerCentral.

In this tip we look at how to capture deadlocks that occur in SQL Server and the associated information to help troubleshoot. We look at how to do this using the GUI and T-SQL code.
The post Capturing SQL Server Deadlocks using Extended Events appeared first on SQLServerCentral.

In this article I'll give a practical example of developing a database, with Flyway, in such a way that it is automatically tested with whatever unit tests and integration tests you specify whenever you migrate the branch you're working on to the next version. If a test fails, you can work out why, undo the migration and then try again.
The post Running Unit and Integration Tests during Flyway Migrations appeared first on SQLServerCentral.

Get a basic introduction to triggers in PostgreSQL.
The post PostgreSQL Triggers Part 1 appeared first on SQLServerCentral.

This wizard migrates SSIS Catalog from one server to another in just a few clicks.
The post Migrate the SSIS Catalog in Just a Few Clicks appeared first on SQLServerCentral.

See how our end-to-end framework for extending DevOps to your database enables your organization to balance the demand to deliver software fast with the need to protect and preserve business critical data.
The post Database DevOps: Standardize, Automate, Monitor & Protect appeared first on SQLServerCentral.

Measuring the wrong things is worse than not measuring anything. In this article, Mallika Gunturu explains the right things to measure for agile.
The post Metrics that matter for IT organizations on an agile journey appeared first on SQLServerCentral.

This article will show you how to use a Powerpoint theme to modify and beautify a Power BI report.
The post Tips to improve Power BI report appeal appeared first on SQLServerCentral.