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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2020-09-21 (first published: )

2,996 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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2020-04-06 (first published: )

5,277 reads

Blogs

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

T-SQL Tuesday #203: Risk and Reward

By

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By

You can find the slides and SQL scripts for my session “Spice up your...

Read the latest Blogs

Forums

Alamat Telp BCA KCP Batu +62 838-4945-0961

By layanan 24jam BCA

Wa:083849450961 Jl. Panglima Sudirman No.1, Ngaglik, Kec. Batu, Kota Batu, Jawa Timur 65311

Alamat Telp BCA KCU METRO +62 838-4945-0961

By m4l4mt194

Wa:083849450961 Jl. Jendral Sudirman No.106, Imopuro, Metro, Kota Metro, Lampung 34111

Communication, For Incidents and Life

By Pat Wright

Comments posted to this topic are about the item Communication, For Incidents and Life

Visit the forum

Question of the Day

PostgreSQL psql Meta Commands: Tables

Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?

See possible answers