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 →Recent Posts
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 →
Combining different database technologies
Exploring when to combine SQL Server with NoSQL technologies like Redis and MongoDB for workloads such as search and recommendations.
Read more →
Putting Humpty together again
Progress report on rebuilding a 1980 Kawasaki KH-125 motorcycle, from painting the frame to reassembling the chassis in a freezing garage.
Read more →
Elbow grease
A personal update on restoring a 1980 Kawasaki KH 125 motorcycle -- stripping the frame, rebuilding the carb, and polishing chrome.
Read more →