Have you ever been tasked with creating test data for an application and then ran into performance problems once the application moves to production? Many of us manage databases...
2024-01-22 (first published: 2024-01-08)
613 reads
When I was 11 I got my first computer, an 8088 with 4.5 mhz. I didn’t know much about computers at the time but I knew it was cool....
2024-01-17 (first published: 2024-01-04)
237 reads
If you’ve ever been a DBA and seen the mess that you get with SQL Agent Jobs without a clean naming standard for your job schedules and job names...
2021-09-06 (first published: 2021-08-13)
306 reads
Azure Purview is a compliance and data governance platform in Microsoft’s Azure cloud. The platform is currently in public preview and has quite a few features; but, does not...
2021-09-01 (first published: 2021-08-11)
391 reads
Is Microsoft’s licensing scheme getting you down? It’s 2020 and there are now plenty of data platforms that are good for running your enterprise data workloads. Amazon’s Aurora PaaS...
2020-12-16 (first published: 2020-12-07)
599 reads
I’m excited and happy to announce that I’m part of the AWS Community Builders. Check out more on Twitter with the #AWScommunity tag. To learn more about the program...
2020-07-31
21 reads
On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows Phone of cloud providers” and what I meant by that is they have a great...
2020-07-15 (first published: 2020-07-06)
386 reads
For the past few months most of the world has been in quarantine and you may think that this is the new normal, especially now that “re-opening” has been...
2020-06-28
125 reads
SQL Server 2019 brings a lot of great new features. Many are introduced by the IQP (Intelligent Query Processing) features and greatly improve query performance. Some time ago I...
2020-06-24 (first published: 2020-06-09)
536 reads
Earlier this week Microsoft released the latest cumulative update for SQL Server 2019 and as you can expect there are quite a few items addressed including a fix for...
2020-06-24
22 reads
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
I'm using PowerQuery in Excel on my desktop. (Yeah, I know you can do...
Here's my data... I am trying to return total days in status for each...
Here's my data... I am trying to return total days in status for each...
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers