2017-11-13
74 reads
Editorials
How Long Before You Upgrade?
This Friday Steve Jones wants to know about the lifetime of your instances. Do you have some idea on how long you'll run a particular version of a platform?
2017-11-10 (first published: 2014-04-11)
342 reads
Introverted vs Extroverted
A lot of us are introverted, so is there anything that can be done about it?
2017-11-09
112 reads
Should We Move to Azure?
This week Steve Jones asks about moving to the cloud and how interesting that might be to the community?
2017-11-08 (first published: 2014-05-23)
238 reads
Software Patents
Patents are one way that governments can spur innovation. However many people think software patents should be eliminated. Steve Jones doesn't think so, but would like reform.
2017-11-07 (first published: 2014-01-30)
161 reads
What are you worth?
When negotiating your salary, it helps to know what the ranges are for your experience and area. Steve Jones gives a little advice today.
2017-11-07 (first published: 2014-05-19)
423 reads
2017-11-06
67 reads
The Importance of Clear Data Displays
An accident on a ship is being blamed on unclear data visualization.
2017-11-06
71 reads
Core T-SQL
Steve Jones thinks there is a list of core skills that any database developer or DBA needs. This week he asks you for a list of those things you think should be included.
2017-11-03 (first published: 2013-11-22)
782 reads
Good Practices for Software Development
We always want to follow the best, or at least good, practices for software development. However do you know what those are? Steve Jones notes there's at least one that isn't often followed.
2017-11-02 (first published: 2014-04-24)
384 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