In the last few weeks I've found myself using Azure Data Studio more, specially the notebooks to organize my scripts in a more explanatory and aesthetically way. About a year ago I wrote a SQL script that I use to backup and restore databases from IaaS to PaaS (Azure VM to Azure Managed Instance) using … Continue reading Generate Backup/Restore to URL Azure Data Studio Notebook using PowerShell
Using JSON for Lookup Tables
When creating lookup or reference tables during database design we often run into the problem that the data contained by these tables varies within environments. This can cause problems in the application layer, especially if ENUMS are created based on this table. One of the methods of keeping these tables aligned in a Database Project … Continue reading Using JSON for Lookup Tables
SQL Insights 