The Costs and Rewards of Speaking
Steve has had a good time sharing knowledge with others at events. He gives you a few thoughts on why you might join him at a future event.
2024-05-24
133 reads
Editorials
Invisible Downtime
Steve has a few thoughts on invisible downtime, a term he had never heard until recently.
2024-05-22
200 reads
Kubernetes is Cool, But ...
Steve has a few thoughts on Kubernetes and how much data professionals should care about the technology.
2024-05-20
217 reads
Realities of Predictive Analysis
Or for short, “Why you have to play the game” “Don't tell me the odds”, cried out Han Solo just before doing something that seemed impossible. How on Coruscant did he do that? Well, as a certain director said about a certain floating door in a galaxy we all call home. ”It was in the […]
2024-05-18
87 reads
The Evolving DBA
Steve thinks the DBA job is evolving and we will always need people to manage data.
2024-05-17 (first published: 2019-12-16)
525 reads
2024-05-15 (first published: 2019-11-12)
385 reads
Crazy Interviews
Today Steve has a few thoughts about some of the nightmare interview processes tech workers are going through.
2024-05-13
251 reads
Honeybee Swarms
I love honeybees. This will be my seventh year as an amateur beekeeper, and aside from family or data, there are few other topics that I could easily spend an afternoon talking to you about. They’re amazing creatures. This past winter I had to move my beehives temporarily to the apiary of a friend. With […]
2024-05-12 (first published: 2024-05-11)
80 reads
Multiple Display Productivity
How many monitors do you need? Steve notes that having multiple ones seems to be a standard these days for tech workers. Do more make you more productive? Answer the poll today.
2024-05-10
188 reads
Are IT Certifications Still Relevant?
Steve talks about certifications today, after watching a video that showcases the benefits of why they are good for your career.
2024-05-08
310 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers