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 of a set of applications. Cloud storage costs is something I've almost thought of as free. Naively. Over a short
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(x), YEAR(CreatedUtc) FROM dbo.[Order] GROUP BY YEAR(CreatedUtc)The CreatedUtc data type is datetimeoffset storing zulu datetimes. Even
