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
Career Growth
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
Action Over Knowledge
A big part of success is making an effort. Steve discusses the need to do things and not passively let life pass you by.
2024-05-01
199 reads
When is it time for a new job?
Steve asks the question today about when you might think about changing employers. He has some advice for you, whether you're happy or in need of a new position.
2024-04-05
203 reads
The Journey to Change
Many of us have a journey, either to SQL Server, or in today's world of many databases, perhaps away from SQL Server. Steve looks at his, and another's, journies.
2024-03-29
132 reads
An Experimental Mindset
Steve wonders how many of you have an experimental mindset. He finds those that embrace this do better in their careers.
2024-03-22
173 reads
Growing Skills at Work
We all need to grow our skills at work. It can be challenging, but we can find ways, as well as advocate to management that resources are needed.
2024-03-15
199 reads
Navigating the Database Landscape
Today Steve has a few thoughts on his keynote topic today at the Redgate Summit.
2024-03-13
179 reads
2024-03-08
242 reads
2024-03-04
244 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
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