Make weekday logic independent of DATEFIRST with a normalized offset or a known Monday, then test every date in a full year.
Custom Date Format Strings in SQL Server: MM Is Not mm
Custom date format strings tell FORMAT exactly which parts of a date to show. This post compares CONVERT styles with FORMAT, lists the standard and custom letters, and shows the traps: MM against mm, YYYY against yyyy, month names that sort wrong, and a culture that changes with the session. Every result comes from SQL Server 2025.
Designing a Date Dimension
A date dimension makes reporting calendars explicit with fiscal periods, holidays, weekdays, and a repeatable SQL Server build script.
SQL SERVER – Difference Between CURRENT_TIMESTAMP and GETDATE() – CURRENT_TIMESTAMP Equivalent in SQL Server
Is there a difference between CURRENT_TIMESTAMP and GETDATE()? No. One is ANSI SQL and the other is the T-SQL version, and both return the same value.
Validate a Date With Regex in SQL Server 2025: Shape Is Not Enough
To validate a date with regex in SQL Server 2025, pair REGEXP_LIKE with TRY_CONVERT. The tests here show impossible dates that pass a strict pattern, spellings that convert but break the format, and how to enforce both checks with a constraint.
A Calendar Table With Holidays for Date Math
Build a calendar table with weekdays, fiscal months, and American holiday flags, then count working days and find useful date boundaries.
SQL SERVER – Fix Error: Microsoft OLE DB Provider for SQL Server error ‘80040e07’ or Microsoft SQL Native Client error ‘80040e07’
Error 80040e07, syntax error converting datetime from character string, usually means a bad date value. In one case a reader had simply misspelled September.