Byte Sized Software Tech

Latest Posts

Latest Posts

Automating a SQL smoke test

In modern database development workflows, updates to the schema and data should be tested, so they don't introduce bugs or cause data loss. This testing can sometimes be referred to as a smoke test, which is...

Clone a dedicated SQL pool between encrypted and resource locked Synapse workspaces

This post covers the automation of cloning a Synapse dedicated SQL pool from one workspace to another where locks and encryption exist. The steps required by the code are as...

Gracefully delete all pipelines from a Synapse workspace that has pipeline to pipeline dependencies

As you build out a Synapse workspace, you will inevitably start to create a dependency model between pipelines. When deploying artefacts to the workspace, you may need to clear down the existing content...

Azure AI

Microsoft Entra

Microsoft Fabric

Azure Networking

Azure Data Factory

Azure Synapse

Azure SQL Database

Azure Logic Apps

Azure/Fabric/Entra

Microsoft Azure is a cloud computing platform and an online portal that allows you to access and manage cloud services.

Microsoft Fabric is a unified Data Factory, Synapse Analytics, and Power BI platform to streamline data integration, analytics, and business intelligence.

Microsoft Entra is a suite of identity and access management (IAM) solutions that enhances security, access control and compliance across cloud environments.

By Jon Shah
Apr 10 2025

Clone a dedicated SQL pool between encrypted and resource locked Synapse workspaces

This post covers the automation of cloning a Synapse dedicated SQL pool from one workspace to another where locks and encryption exist. The steps required by the code are as...
By Jon Shah
Mar 18 2025

Gracefully delete all pipelines from a Synapse workspace that has pipeline to pipeline dependencies

As you build out a Synapse workspace, you will inevitably start to create a dependency model between pipelines. When deploying artefacts to the workspace, you may need to clear down the existing content...

Azure DevOps

Ansible

Terraform

DevOps

DevOps allows workflow automation and streamlining which can accelerate software development cycles, by promoting closer collaboration between developers, teams, and stakeholders. This approach enhances software quality, enabling faster and more reliable delivery.

By Jon Shah
Jun 19 2025

Automating a SQL smoke test

In modern database development workflows, updates to the schema and data should be tested, so they don't introduce bugs or cause data loss. This testing can sometimes be referred to as a smoke test, which is...
By Jon Shah
Apr 10 2025

Clone a dedicated SQL pool between encrypted and resource locked Synapse workspaces

This post covers the automation of cloning a Synapse dedicated SQL pool from one workspace to another where locks and encryption exist. The steps required by the code are as...

PowerShell

SQL

Python

YAML

Coding

Programming tips and tutorials for a few common languages.

By Jon Shah
Jun 19 2025

Automating a SQL smoke test

In modern database development workflows, updates to the schema and data should be tested, so they don't introduce bugs or cause data loss. This testing can sometimes be referred to as a smoke test, which is...