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)
597 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
113 reads
2022-11-11
1,192 reads
Learn how to refresh a Power BI dataset by integrating Power Automate into the report.
2022-11-11
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
I just learned that my database was created on my C:\ drive in the...
I am needing to migrate a MSSQL db to MySQL, on a different server...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers