Change(s) of scenery
A career update on moving from Timely to Sharesies to GitLab as an Engineering Manager, lessons learned, and navigating tech layoffs.
Read more →Recent Posts
Interesting times
Practical advice on working from home, managing remote teams, and dealing with isolation during the early days of COVID-19 lockdown.
Read more →
Cloud Engineers - I want you!
Hiring a cloud engineer at Timely to manage Azure infrastructure, implement Terraform IaC, and automate operational workflows.
Read more →
SSIS Data Flow Plus!
Using CozyRoc's Data Flow Task Plus to build dynamic, schema-less SSIS packages that adapt to schema changes without redeployment.
Read more →
BIML, where have you been all my life?
An introduction to BIML (Business Intelligence Markup Language) for generating SSIS packages, with step-by-step examples using BIDS Helper.
Read more →
Azure SQL to Azure Data Warehouse ETL
Exploring options for moving data from Azure SQL Database to Azure SQL Data Warehouse, including Azure Data Factory and SSIS packages.
Read more →
Keeping track of your SQL Server index
Two approaches to tracking SQL Server index changes over time: scheduled jobs with sp_helpindex2 and DDL triggers with EVENTDATA.
Read more →
PowerShell script to update Azure firewall rule
A PowerShell script that detects your current external IP address and automatically updates firewall rules across multiple Azure SQL Servers.
Read more →
SQL Server 2016 & Azure Query Store
Using the SQL Server Query Store to diagnose and fix intermittent performance regressions on Azure SQL Database by identifying and forcing execution plans.
Read more →
Red Gate Azure backup failures
Troubleshooting intermittent Red Gate Cloud Services backup failures on Azure SQL Database, traced to timing issues in the export process.
Read more →