Jeffrey Williams


Technical Article

Fiscal/Retail 4-5-4 Calendar Function

This function returns a 3 year calendar based on a 4-5-4/5-4-4/4-4-5 calendar, also known as a 52/53 week calendar.  The basis of this calendar function was derived from the NRF retail calendar published at https://nrf.com/resources/4-5-4-calendar and the Wikipedia article published at https://en.wikipedia.org/wiki/4%E2%80%934%E2%80%935_calendar. The calendar function requires 2 helper functions.  The helper functions were derived from […]

2020-09-21 (first published: )

1,928 reads

Technical Article

Calculating Easter in SQL

Several months ago someone commented on a calendar thread that you should not even try to calculate Easter in SQL Server because the math was too hard.  That got me to thinking and I decided to see if that was actually the case. I found that there are several well known algorithms available - but […]

2020-04-06 (first published: )

2,647 reads

Blogs

Daily Coping 26 Jan 2023

By

Today’s coping tip is to focus on what’s good, even if today feels tough....

Working With Tags in FlashArray using PowerShell

By

Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...

Using SQL Data Compare from the Command Line with a Project

By

SQL Data Compare (SDC) is a great way to sync data among tables. It’s...

Read the latest Blogs

Forums

SQL Table Issue

By Jobs90312

Hi everyone, In below code I am creating a table and inserting some english...

what does the backup log init do?

By vpmaciel

what does the backup log init do?

Backup Log Init run again by mistake manually.

By vpmaciel

backup log to int run every hour. If a log init backup is run...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers