Gigging for a Career
The idea of working on just projects is tailor made for a data professional. Or is it?
2023-11-13 (first published: 2017-10-24)
204 reads
Editorials
No Degree Needed
Steve doesn't think you need a degree to work in technology and more companies agree with this all the time.
2023-11-11
95 reads
2023-11-10
244 reads
Does Management Care About the Database?
In the past, Steve hasn't often felt management considered databases to be important, but that is changing.
2023-11-08
173 reads
Don't (Always) Be a Hero
When we need to be heroes in IT on a regular basis, that's a problem for Steve.
2023-11-06
280 reads
A rose by any other name would not be a rose
William Shakespeare once wrote in the play Romeo and Juliet: “What's in a name? That which we call a rose, by any other word would smell as sweet.” It is a beautiful sentiment in that context, and even still you might say that there is some truth to this saying in a lot of ways. […]
2023-11-04
1,643 reads
When Work Isn't Done
Today Steve looks at the case when one software developer finishes their work, but another doesn't. The challenge of reordering work is something that happens more and more as teams struggle to coordinate their efforts.
2023-11-03
122 reads
Not Useless Features
There are some useless features in SQL Server, but Steve Jones wants to know which ones aren't and need investment.
2023-11-01 (first published: 2017-12-01)
318 reads
Degree Apprenticeships
Training more people on the job, while still allowing them to continue their education is something Steve thinks would help more people get started in technology.
2023-10-30
115 reads
Learning with Sample Data
I just had my one-year anniversary working for Redgate, and I must tell you, it’s been one of the best years of my professional career of 25 years. People aside (and there are a lot of really great people!), one of the reasons I’ve enjoyed this year so much is that Redgate understands and believes […]
2023-10-28
147 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
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...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
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:...
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