-
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…
-
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…
-
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…
View Older Posts
- April 2025
- March 2025
- February 2025
- January 2025
- November 2024
- October 2024
- September 2024
- July 2024
- June 2024
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
- December 2023
- November 2023
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