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.
2022-11-18
2022-11-18
479 reads
Learn how to refresh a Power BI dataset by integrating Power Automate into the report.
2022-11-18
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.
2022-11-16
2022-11-16
425 reads
2022-11-21 (first published: 2022-11-14)
599 reads
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.
2022-11-14
The use of IoT and lots of data is allowing governments to better serve their citizens.
2022-11-12
117 reads
2022-11-11
1,206 reads
Learn how to refresh a Power BI dataset by integrating Power Automate into the report.
2022-11-11
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers