The case of the Mysterious Azure Storage spikes Recently I noticed a significant increase in Azure costs on a client project. For this particular client cloud storage is used for virtual machine disks, a few assets and hosting
Switching the offset for a UTC date in SQL Server I was doing some work recently where I needed to group some data from SQL Server by year, month, week, etc. The simplified version was something like this: SELECT COUNT(