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)
3,052 reads
2021-03-05 (first published: 2019-02-21)
6,088 reads
In this piece, learn about changes in UK holidays and get a script to calculate them.
2019-07-15
3,074 reads
2019-06-06 (first published: 2018-01-04)
6,191 reads
Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.
2017-03-14
3,230 reads
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
Running AI and data pipelines on the edge instead of the cloud has gone...
By Steve Jones
While writing another post I realized my UNION query didn’t work as one might...
Unfortunately I'm using SSMS 22. It didn't come with maintenance plans by default. I...
Comments posted to this topic are about the item Secure Cached Plans
Comments posted to this topic are about the item Complex Data Processing with dbt...
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers