Flyway Teams has an Undo facility that enables you to roll back one or more migrations. This article demonstrates how it works and explains how Undo migrations make testing migration scripts easier and branch-based development simpler.
2021-11-01
In this article we cover which performance monitor counters to use to baseline and troubleshoot SQL Server network issues that may be causing performance issues.
2021-11-01
Not a week goes by without news of a new cyberattack. In this article, Robert Sheldon explains the cybersecurity threats in today’s world.
2021-10-29
A key finding from Redgate’s recent State of Database Monitoring Survey of over 2,500 IT professionals was that 79% of respondents reported using either a third-party or in-house monitoring tool. It’s notable because it’s an increase of 10 percentage points from the same survey last year. But when should you use an in-house tool, and when should you take the plunge and invest in a third-party monitoring tool like SQL Monitor?
2021-10-27
Database objects often have references to external databases which makes continuous integration problematic. In this article Liz Baron and Sebastian Meine demonstrate a solution.
2021-10-27
Although it is easy to get started with Flyway, there are times when real-life can trip you up. Discover the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems.
2021-10-25
In this article we look at how to use string functions to concatenate, replace, trim and get substrings in SQL Server, Oracle and PostgreSQL.
2021-10-25
This article from Phil Factor will get you up and running quickly with Flyway migrations on MariaDB or MySQL databases, from PowerShell.
2021-10-22
SQL Server identity columns are easy to add to a table, but you must understand how they work to use them effectively. In this article, Greg Larsen explains the nuances of SQL Server identity columns.
2021-10-22
Learn how to enable or disable full text search for a specific database on a SQL Server instance where the Full Text Search components have been setup.
2021-10-20
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Comments posted to this topic are about the item Celebrating Tomorrow
Comments posted to this topic are about the item SQL Art: I Made a...
I am using ssrs in visual studio 2022, I work on a report, there...
Which of these is more appropriate for tomorrow?
See possible answers