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.
A Custom Execution Method – Level 19 of the Stairway to Integration Services
The next level of the Stairway to Integration Services looks at how you can execute your package.
Blogs
Get SQL Server Configuration using T-SQL
As a SQL architect or database administrator, it is required to know how to...
SQL Server – Retrieve Physical Cores, Physical and Virtual CPUs, and Processor type information
Today's post describes SQL queries to get the following information about the processors of...
SQL Server - How to comma-separated values into different columns
This article will demonstrate the method to store comma-separated values into different columns using...
Forums
Are all learning resources just rote memorization?
Title says it all, recently got frustrated prepping for GCP's ACE with Qwiklabs because...
Upgrade SQL and OS of legacy
Hi All, We are planning to upgrade both SQL and OS of legacy versions....
How to run a different account using SQL Job to execute powershell script
Hi All , I need to run powershell script which is located in other...
Ask SSC