2021-03-05 (first published: 2019-02-21)
5,588 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,010 reads
2019-06-06 (first published: 2018-01-04)
5,015 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
2,795 reads
Blogs
SQL Server on Linux Storage Secrets on Microsoft Channel 9
By kleegeek
I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel...
Daily Coping 29 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Server vs Instance. A rant.
It’s a SQL Server Instance not a SQL Server. The product is SQL Server....
Forums
How to limit SQL Job Success events
Hi, We have a monitoring tool that reads Windows Event Log entries for Failure...
SQL Server Agent producing unreproducible error
I've built a Powershell script, which I want to run through SQL Server Agent....
Replace hexidecimal value wih '§' or blank in a TEXT field
I have a DB with a field defined as: dag_text text allow nulls I...
Ask SSC