Many of my customers are using Flyway Enterprise to create migration scripts that will then be used to deploy database changes. They’ve been using Flyway Desktop, but some of them have expressed interest in using command line instead of the desktop. NOTE: Migration script creation in Flyway Enterprise is now…Read more
Redgate Monitor is an essential tool for DBA teams worldwide, providing real-time monitoring of SQL Server and PostgreSQL performance. With RedgateMonitor, you can easily track deployments, errors, and other events on the timeline. This feature, called annotations, allows you to quickly identify the root cause of performance issues and take…Read more
Deploying database code using pipelines in various CI/CD tools is a common practice among our customers who use Flyway. To enhance security and avoid hardcoding sensitive information like connection strings, they frequently employ variables and secrets in the pipelines. Recently, Redgate introduced a new way to configure target database connections…Read more
NOTE: The code in this article works with Redgate Monitor 13. Read this article for Redgate Monitor version 14. Redgate Monitor is an essential tool for DBA teams worldwide, providing real-time monitoring of SQL Server and PostgreSQL performance. With RedgateMonitor, you can easily track deployments, errors, and other events on…Read more
A few years ago, I was approached by an organizer of a developer conference asking if I would be interested in presenting at their event. This was unusual at the time, because I mostly spoke at SQL Server events, but I didn’t remember ever being asked like this before. The…Read more
Many of you know that Redgate purchased some of the assets of PASS, namely session recordings, domain names, and trademarks. Shortly after that purchase, we began talking about what it would take to put on an event to revive PASS Summit. The first step was to survey to find out…Read more
I began attending PASS Summit in 2003. I had no idea that it would change the course of my career and, well, life. Becoming part of the community I found through PASS inspired me to take my career to the next level by presenting and writing. It also led to…Read more
I’m Kathi Kellenberger. I’m the editor of Simple Talk, a DevOps Advocate, and a Microsoft Data Platform MVP. Probably the most important thing to know about me is that I’m a lifelong learner and a teacher. I love learning new things and I love sharing what I’ve learned with others.…Read more
How to avoid database build failures, caused by circular cross-database object references, by restoring or provisioning copies of all required databases to the development, build, or test SQL Server instance.Read more
A monitoring tool must provide us with an understanding of the often-complex performance patterns that databases exhibit when under load, so that we can predict how they will cope with expansion or increase in scale. It must also helps us spot the symptoms of stress and act before they become…Read more