Technical Article

Finding first/last day of month by a date

This script finds the first day of previous, current and next month as well as last day of previous, current and next month.The calculation is based on the ISO date format which makes it independant of the date format used on the SQL Server.The calculation is performed from a date - it can be altered […]

You rated this post out of 5. Change rating

2004-12-02 (first published: )

246 reads

Blogs

Claude Code Helps Analyze Test Data Manager Log Files

By

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Read the latest Blogs

Forums

Huge frustration - Database watcher with two elastic pools

By bjorn.c.w

Think there's a reason why this is still in preview, but have someone manage...

SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance

By Site Owners

Comments posted to this topic are about the item SQL Server 2025 Query Performance...

Is it uncommon for Dev's to have a data model of the source data

By Coffee_&_SQL

This is a generic question. To the moderators, I wasn't sure where to place...

Visit the forum

Question of the Day

Creating JSON I

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

See possible answers