The new data governance features in Microsoft Purview are now being made generally available as they are gradually rolled out across various regions. You can view the deployment schedule...
2024-10-02 (first published: 2024-09-19)
147 reads
I’m leaving again tomorrow for a trip. This time I head back to Boston for a Redgate DevOps in a Day on Thursday and SQL Saturday Boston 2024 on...
2024-10-01
1 reads
I’m leaving again tomorrow for a trip. This time I head back to Boston for a Redgate DevOps in a Day on Thursday and SQL Saturday Boston 2024 on...
2024-10-01
14 reads
Most of us who work with data have, at least a few times, been presented with a challenge to explore and attempt to make sense of a poorly-defined set...
2024-10-01
27 reads
Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...
2024-09-30
5 reads
Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...
2024-09-30
130 reads
A reader of one of my previous posts pointed out that the legend order and segment order in my core visual stacked column chart did not match. I had...
2024-09-30
4 reads
A reader of one of my previous posts pointed out that the legend order and segment order in my core visual stacked column chart did not match. I had...
2024-09-30
2 reads
A reader of one of my previous posts pointed out that the legend order and segment order in my core visual stacked column chart did not match. I had...
2024-09-30
2 reads
A customer recently wanted to know if any of their instances were too old and out of support. This was for a compliance purpose, and they had the need...
2024-09-30
1 reads
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers