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: )

230 reads

Blogs

A New Word: Immerensis

By

immerensis – n.  the maddening inability to understand the reasons why someone loves you...

Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault

By

In this post, I will guide you on how to deploy a dockerized simple...

SQL Server Wait Stats

By

Everything in SQL Server is waiting for something…this is by design. And most people...

Read the latest Blogs

Forums

mysql query timeout upped but job still fails about same number of minutes in

By stan

hi, i changed my mysql based linked server's timeout to N'600' instead of N'0'...

Somebody realized to configure Cluster-Aware updating on VMWare nodes

By boskabouter 007

Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File...

is it cache or something else

By stan

hi a few days ago i narrowed down the cause of a new problem...

Visit the forum

Question of the Day

SQL Server Collations

At what levels can we set the collation in SQL Server 2022?

See possible answers