Brian Knight

Brian Knight, MCSE, MCDBA, is on the Board of Directors for the Professional Association for SQL Server (PASS) and runs the local SQL Server users group in Jacksonville. Brian is a contributing columnist for SQL Magazine and also maintains a weekly column for the database website SQLServerCentral.com. He is the author of Admin911: SQL Server (Osborne/McGraw-Hill Publishing) and co-author of Professional SQL Server DTS (Wrox Press). Brian is a Senior SQL Server Database Consultant at Alltel in Jacksonville and spends most of his time deep in DTS and SQL Server.

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

The Phoenix Project

By Additional Articles

Comments posted to this topic are about the item The Phoenix Project

T-SQL Fundamentals

By Additional Articles

Comments posted to this topic are about the item T-SQL Fundamentals

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,...

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