I'm answering a question in the forums and I spot something that crawls up my spine: ;WITH... The person was using a Common Table Expression (CTE) which requires that the preceding statement in the batch have a statement terminator, the semi-colon. However, since the terminator isn't required everywhere, lots of people don't use it at […]
A thread about what it takes to be a good engineer has Steve commenting on those characteristics that are important to him.
Placeholders come in very handy in Flyway, but troubleshooting the SQL migration and callback scripts that use them can be tricky. This articles demonstrates how to develop, test and debug these scripts in a tool designed for these tasks, such as SSMS, leaving Flyway to do what it's designed for, which is running the scripts.
In this article, we will see if the given SSIS catalog is ready for migration without any issues using SSIS Catalog Migration Wizard inspect feature.
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
In this article we look at how to install SQL Server and Oracle using PowerShell to create development environments using Windows Containers.
Many people ask about DevOps and what it entails. Steve has a few thoughts on the challenges of adopting DevOps in a company.
Learn how to connect your Synapse workspace to a Git repository.
Crowdsourcing is one way to get a job done. In this article, Devyani Borade describes crowdsourcing quality testing of software.
Often, we want to test the new version of a database, produced by a Flyway migration, before committing the new migration file, or to test the same migration run on a number of different databases. This article demonstrates how to do it, by generating and using JSON parameter files to run a series of Flyway actions on any number of databases, on any number of servers.
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers