2021-03-05 (first published: 2019-02-21)
6,011 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,063 reads
2019-06-06 (first published: 2018-01-04)
6,112 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,176 reads
Blogs
Measuring and Improving SQL Server Query Plan Cache Efficiency
By SQLPals
Measuring and Improving SQL Server Query Plan Cache Efficiency The query...
Communicate to the Individual
By Brian Kelley
I may think I'm trying to reach the crowd, but I'm really trying to...
Monday Monitor Tips: Searching Permission Changes
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
Forums
The Technical Debt Anchor
Comments posted to this topic are about the item The Technical Debt Anchor
Getting the Updated Column List
Comments posted to this topic are about the item Getting the Updated Column List
SSRS: An error occurred during local report processing. The definition of ...
Here's the complete error: An error occurred during local report processing. The definition of...
Question of the Day
Getting the Updated Column List
What happens when I run this code in SQL Server 2022?
UPDATE dbo.CustomerLarge SET CustomerContactFirstName = 'Andy' WHERE CustomerID = 1 SELECT COLUMNS_UPDATED()See possible answers