Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-07-10 (first published: 2019-06-26)
733 reads
Date computation
2018-02-23 (first published: 2018-02-19)
120 reads
2017-12-29
1,068 reads
Compute Holiday Day of the Month for any Year
This script provides the day of the month for the standard bank holidays for any given year. This is especially useful for computing the workday after a holiday.
2017-05-24 (first published: 2017-05-10)
445 reads
Blogs
Why I Support Code Automation Tools Like ORMs
I know I’m a weirdo. I’ve always been a weirdo. When I was a...
#PowershellBasics: Run a file and pass it a parameter.
I realized in my last #PowershellBasics post that I was talking about running a...
SQL Undercover TV – Instant File Initialisation
Adrian has a look at the performance benefits of instant file initialisation Below is...
Forums
In-memory database
Hi, Currently i am processing records in SQL Server itself. Any recommended in-memory database,...
Replication CDC -- Cannot Truncate Table
Dear All, We just enabled Replication services (CDC) on few of the databases. Now...
Verify Server online status using sql server query
Team I have populated list of ServerName from the sql server query. I would...
Ask SSC