• An Introduction to Bicep

    An Introduction to Bicep

    I am starting a multi-week series of posts covering the topic of Bicep, Microsoft’s Infrastructure as Code scripting language, since I have been working with this tool heavily for the past several months. You may wonder why a database developer is using Infrastructure as Code, since DevOps engineers typically do that. However, I decided to…

    Continue Reading


  • Reseeding Table Identity from Synapse Pipeline

    Reseeding Table Identity from Synapse Pipeline

    A task I was requested to implement a while ago in an Azure Synapse pipeline was to have the pipeline reseed a table identity column to prepare it for new data that will be calculated and inserted into the table as part of an optimizer solution someone is writing. This request challenged me to learn…

    Continue Reading


  • How to Reset the Azure CLI Virtual Environment

    How to Reset the Azure CLI Virtual Environment

    Have you been in a situation where you were working with the Azure CLI Bash terminal and then something went wrong with the image used to persist your data across sessions and your workspace seemingly got corrupted? I have had that happen to me recently, and I think it was because I updated my computer…

    Continue Reading


View Older Posts

Posts by Tag

ACloudGuru AI Artificial Intelligence AWS AWS Certifications Azure Azure SQL Database Blog Change Management Change Tracking Cloud Cloud Development CloudFormation Coffee Break Conference Cryptography Database Tools Development EC2 Elastic Compute Cloud Encryption ETL Fernet Git Google Google Maps Local Microsoft SQL Server Oracle Organization Postgres PostgreSQL Productivity Python RDS Red-Gate SQL SQL Prompt SQL Server Management Studio SSMS Stress Management Study Synapse Analytics WordPress Work Management

Or search for something specific