An Investment in Knowledge
Inspired by a quote from Benjamin Franklin, Steve Jones talks about investing in your career.
2011-08-30
263 reads
Editorials
A Look Back at Apple
With the resignation of Steve Jobs from Apple this week, Steve Jones looks back at his memories of the tech icon.
2011-08-29
109 reads
Specialists or Generalists: Who are best as Developers?
Should we have specialists or generalists working as developers in our companies? A guest editorial today from Mike Angelastro asks the question.
2011-08-29
251 reads
Would You Rather Work for a Strong or Weak Manager?
Today we have a guest editorial from Andy Warren. Andy asks if you prefer to have a strong manager or weak one, and why.
2011-08-26
187 reads
Keep Data Forever
Today Steve Jones talks about some of the issues with keeping data around a long time and a new archival medium.
2011-08-25
199 reads
Pop Tarts and Hurricanes
Today Steve Jones talks about the relation between hurricanes and poptarts, and why you should be working on your T-SQL skills.
2011-08-24
155 reads
The Talent Crunch
There seems to be no shortage of IT jobs in the US, and Steve Jones reminds us that the shortage is for talented workers, not just workers.
2011-08-23
478 reads
Devil's Advocate
With the one hand, Chris applauds the outstanding work of the SQL Server community, and tentatively raises the other to ask if we're on the cusp of a chance.
2011-08-22
121 reads
Virtual Security
As more and more companies move to virtualized servers, security should be on their minds. Steve Jones talks about that changes that you should consider.
2011-08-22
122 reads
A Flock of SQL Servers
Do you want to integrate Twitter with your database server? Steve Jones asks the question this week.
2011-08-19
129 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