The Bones of SQL - The Holiday Table
This second part to a previous article on Calendar table generation shows how to create a holiday table containing both fixed-date and variable-date holidays.
2018-12-25 (first published: 2016-09-19)
6,562 reads
calendar
Bones of SQL - The Calendar Table
This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined.
2017-11-24 (first published: 2016-09-08)
16,688 reads
Calendar Table Function
This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently
2016-08-08 (first published: 2014-12-29)
6,896 reads
Calendar Table by Year
Populate a calendar table with user set interval start and end datetime values.
2014-03-11 (first published: 2014-02-21)
1,312 reads
Calendar Table by Month
Populate a calendar table with user set interval start and end datetime values.
2014-09-16 (first published: 2014-02-21)
1,993 reads
Calendar Table by Day
Populate a calendar table with user set interval start and end datetime values.
2014-09-15 (first published: 2014-02-21)
1,959 reads
Calendar Table by Interval Minutes
Populate a calendar table with user set interval start and end datetime values.
2015-03-24 (first published: 2014-02-21)
1,888 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)
15,119 reads
RE: Revoke Permissions on Failed Logins
forgive me if I'm on the wrong tack here. but with windows authentication, there is no inputting of the password into SQL....so there is no failed SQL logon (for password reasons anyway).There may be a failed logon, because the windows logon is not registered in SQL....but if that's the case then there is no permissions […]
2005-04-27
RE: Transactional replication. distribution agent failing
As soon as the distribution agent starts delivering all transactions the log will be clearing but the size won't be reduced.
2005-04-01
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers