Cloud Engineers - I want you!
Hiring a cloud engineer at Timely to manage Azure infrastructure, implement Terraform IaC, and automate operational workflows.
Read more →Recent Posts
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 →
Head in the clouds
Reflections on moving from Trade Me to Timely and the shift to running SQL Server infrastructure entirely on Microsoft Azure.
Read more →
SQL Server version information from build numbers
A T-SQL function that converts SQL Server build numbers into readable version strings showing edition, service pack, and cumulative update level.
Read more →