Azure SQL Database has been available for a long time now in its own unique DTU licenced model. As of 4th April it is now also available in a vCore-based Database purchase model, in preview, which will align much more
As many of you know, I am a big fan of Azure SQL Database, the Platform as a Service (PaaS) database solution and that it frequently supports new features such as Active Geo-Replication for Azure SQL Database ALL Tiers and TRIM. A
The other day I was required to find out more about offsets and timezones and I came across a new T-SQL function in SQL Server 2016 AT TIME ZONE. This function gives us the current offset in the target time zone.
I’ve been looking at trying to get some Azure SQL Database wait stats for some time now. We’ve had the useful resource statistics dynamic management views for a while but they only really provided information of utilisation of the CPU, I/O,