Are You a Good Engineer?
A thread about what it takes to be a good engineer has Steve commenting on those characteristics that are important to him.
Debugging Flyway Callbacks and Migrations that Use Placeholders
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.
Is Your SSIS Catalog Migration Ready
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.
SQL Server Monitoring Using Free Tools
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
Install SQL Server and Oracle using PowerShell and Windows Containers
In this article we look at how to install SQL Server and Oracle using PowerShell to create development environments using Windows Containers.
Defining DevOps
Many people ask about DevOps and what it entails. Steve has a few thoughts on the challenges of adopting DevOps in a company.
How to Integrate Azure DevOps with Azure Synapse Studio
Learn how to connect your Synapse workspace to a Git repository.
Crowdsourcing quality: Can the hive mind/herd mentality help you in software testing?
Crowdsourcing is one way to get a job done. In this article, Devyani Borade describes crowdsourcing quality testing of software.
Testing a Flyway Database Migration
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.
Knowing When to Respond
I ran into this quote on the Microsoft Learn site, which I thought was a great way to think about how to administer a system: "Without a baseline, every issue encountered could be considered normal and therefore not require any additional intervention." When I've had users file tickets or complain about things not working well, […]
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers