2021-03-05 (first published: 2019-02-21)
5,891 reads
Pete Revell
Politics makes for bad databases - plus calculate British holidays
In this piece, learn about changes in UK holidays and get a script to calculate them.
2019-07-15
3,037 reads
2019-06-06 (first published: 2018-01-04)
5,928 reads
Adding Years, Months and Days
Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.
2017-03-14
3,031 reads
Blogs
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Forums
Drop or delete a existing partition
Hello, so I was reading on partitioning a large table, Which i successfully did,...
PostgreSQL authenticated against Microsoft Active Directory
Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...
Compare all tables row counts for 2 server instances?
USE [DBName] SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount]...
Ask SSC