hey ya, started working on the obvious - what ratbak said, just haven't had time to finish
so basing it on the logic that
SELECT substring(current_utc_offset,2,2) FROM sys.time_zone_info WHERE NAME = 'GMT Standard Time'
will update to +00:00 when we get to end of summer time rather than current "GMT Standard Time +01:00"
i think ill just need a simple function to do the time zone addition for me, so that it can be used in the data view
below, _Timestamp is the GMT field, T2 is what i plan to be the UTC field
declare @t2 as int
set @t2 = (SELECT substring(current_utc_offset,2,2) FROM sys.time_zone_info WHERE NAME = 'GMT Standard Time')
, ROW_NUMBER() over (partition by _name,convert(varchar,[_TIMESTAMP],111) order by _timestamp desc) as r