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 →Posts
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 →
Customising SQL Management Studio 2012
Tips for customizing SQL Server Management Studio 2012, including dark themes, keyboard shortcuts, and syncing templates via symbolic links.
Read more →
What's in your toolbox?
How to organise your SQL Server utility scripts using SSMS Template Explorer, snippets, and other tools for easy retrieval.
Read more →
SQL script of HTML status codes
A downloadable SQL script that creates a lookup table of all HTTP status codes and their descriptions, sourced from Wikipedia.
Read more →