SQLServerCentral Article

dbWarden - A Free SQL Server Monitoring Package

dbWarden is a comprehensive monitoring and alerting solution for SQL Server 2005 or newer. It features an emailed Health Report and includes email and text notifications with customizable metrics for alerts such as Blocking, Long Running Queries and SQL Jobs, CPU %, Log file and TempDB growth.

4.68 (47)

You rated this post out of 5. Change rating

2013-04-12

24,230 reads

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

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

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

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