• Interests: Reading, Movies, Poker, Web 2.0, Physics, Social Sciences

Technical Article

Number of Weekdays between two dates - Set Based

Inspired by a post here at SQLServerCentral, I wrote this function to calculate the number of days between two dates that are weekdays. In order to achieve this I used a common SQL table that contains a sequence of number for 1 to X. This was used as an input to the datediff function, and […]

You rated this post out of 5. Change rating

2004-12-24 (first published: )

298 reads

Blogs

Speaking at SQL Saturday South Florida 2024

By

I’m heading to SQL Saturday South Florida 2024 next week. This is my second...

The Next Phase & A Fresh Start

By

As of June 1, I am no longer an employee at 3Cloud. I am...

How do you restore a SQL Server 2000 database in the year 2024?

By

A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I...

Read the latest Blogs

Forums

The Secondary Database Name in an AG

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Secondary Database Name in...

Cloud Transformation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud Transformation

How I Used PostgreSQL RLS To Avoid Code Changes During a Migration

By shwets.ven@gmail.com

Comments posted to this topic are about the item How I Used PostgreSQL RLS...

Visit the forum

Question of the Day

The Secondary Database Name in an AG

I am setting up a SQL Server 2022 Availability Group and I am ready to restore the database on the secondary. The primary database is named Finance. However, we also use this instance for QA and already have a database named Finance. How do I configure the AG to use a different database as the secondary?

See possible answers