2020-04-25
134 reads
Career Growth
2020-04-11
133 reads
2020-04-10
174 reads
More Time to Certify
You have more time to earn that MCSA, MCSE, or MCSD, thanks to Microsoft and the pandemic.
2020-04-08
191 reads
Next Person Up
Steve wonders today about the need to compete in our jobs, especially with employers that view us as resources.
2020-04-02
130 reads
Now Is a Good Time for Choices
The whole world is going through some interesting times. Chances are pretty high that you’re working from home and your principal interaction with others is through virtual means. I know I’m that way as is my company, Redgate Software. It can be challenging or rewarding, depending on how you go about it. What’s even more […]
2020-03-28
128 reads
Taking Stock of Your Career
With almost a quarter of 2020 gone, Steve notes it's be time to stock of your career.
2020-03-27
498 reads
The Challenge of Contracting
The nature of work might be changing, and Steve has a few thoughts on thinking about your job as always contracting.
2020-03-25
116 reads
SQL Is Always Going to be Popular
Steve thinks that learning more about the SQL language is always a good career investment.
2020-03-18
356 reads
The WFH Challenges
Working from home can be hard and Steve has a few ideas that might help you transition during these challenging times.
2020-03-16
254 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