• 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


  • Deploying A DACPAC to Azure SQL Server

    Deploying A DACPAC to Azure SQL Server

    One of the easiest ways to duplicate SQL Server database objects from one database to another–such as in a situation where you want to copy the structure of a production database down to a development database to help with testing and development–is to create a file called a DACPAC from the database you want to…

    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