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-05-01
977 reads
Scripts
2019-04-30
1,849 reads
Random Lottery Number Generator
This script will generate 5 lottery numbers plus one mega and you can set how many tickets and the range for the numbers for the different types of lotteries.
2019-04-27 (first published: 2016-07-13)
2,068 reads
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-04-25 (first published: 2019-04-18)
717 reads
SQL Server System Audit Report
SQL Server System Audit Report Rudy Panigas, 2018-05-25 (first published: 2016-02-02) With every technology, security is in the forefront of the minds of professionals around the world. Ensuring that your SQL Server is secure is the job of every Database Administrator (DBA). The DBA(s) needs to configure the system to minimize the “attack surface” (reducing […]
2019-04-18
4,077 reads
2019-04-16 (first published: 2019-04-12)
11,695 reads
Date Calendar
Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
2019-04-15 (first published: 2009-10-06)
16,889 reads
2019-04-15 (first published: 2009-11-18)
2,072 reads
2019-04-15 (first published: 2018-06-01)
2,075 reads
Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
546 reads
Blogs
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
Forums
Contact BCA KCU WISMA ASIA | Tlp/Wa:0818751777
Info & kontak:0818-751-777. Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Contact BCA KCU BANDUNG | Tlp/Wa:0817866887
Info & kontak:0817-866-887. Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat...
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers