Evolution of code The thing with any bit of code that has been around for a while, is that when change comes along, the tendency is to cater for the change by adding new stuff, while nothing gets taken away. Some stuff has definitely been taken away from this Date Dimension, but some historical artefacts […]
2025-09-02 (first published: 2025-08-05)
2,990 reads
2021-03-05 (first published: 2019-02-21)
6,029 reads
In this piece, learn about changes in UK holidays and get a script to calculate them.
2019-07-15
3,066 reads
2019-06-06 (first published: 2018-01-04)
6,135 reads
Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.
2017-03-14
3,187 reads
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Comments posted to this topic are about the item Create an HTML Report on...
We have an issue where SSIS packages are failing with a status of "ended...
Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...
What does a slipstream installation mean?
See possible answers