Gabe Tower


Blogs

Elevate Your Data Leadership: A Unique Intensive Learning Experience

By

I’ve collaborated with two industry experts to design a transformative course for data leaders:...

A New Word:Maugry

By

maugry – adj. afraid that you’ve been mentally deranged all your life and everybody...

Friday Flyway Tips–Capture the Filegroup for Tables

By

A customer asked recently why Flyway doesn’t detect the filegroup for some changes. I...

Read the latest Blogs

Forums

ssas memory issues even after switching over to table level refreshes

By stan

Hi, we just moved to 2019 std from 2016 std.   We comingle the engine,...

Using R and Python with SQL Server 2022 not possible

By kunigunde.kurzweil

I want to use R and Python with SQL Server 2022, but I get...

is process add available in standard ssas

By stan

Hi, i cant tell from these 2 articles if incremental processing is available in...

Visit the forum

Question of the Day

Daylight Saving Time

I have a Sql Server 2022 instance setup with '(UTC-05:00) Eastern Time (US & Canada)' as timezone and a PostgreSQL 16 cluster setup with 'America/New_York' as timezone; both of them have -05:00 as UTC offset. Given that in New York, in 2024 Daylight Saving Time will begin on Sunday, March 10, at 2 AM, what happens if I execute the following statements in their own environment? Sql Server:

select dateadd(HOUR, 1, cast('20240310 01:00:00-05:00' as datetimeoffset(0)));
PostgreSQL:
select date_add('20240310 01:00:00-05:00'::timestamptz, '1 hour'::interval);

See possible answers