2008-09-01
796 reads
Editorial - WMV
Labor Day Bloopers
With the Labor Day holiday in the US, Steve Jones takes a break from writing and brings you a compilation of mistakes from the past few months.
2008-08-30
61 reads
One Milly-yon IOPS - Database Weekly (Sept 1, 2008)
IBM is testing a new hardware disk array that vastly outperforms any current arrays. What does this mean for the database world?
2008-08-30
484 reads
Un-Wired
This Friday's poll looks at vacation and how you prepare to be unwired. Steve Jones talks about some of the things you can do.
2008-08-28
51 reads
The August 2008 Energy Update
This bi-monthly update on energy news covers quite a bit of wind-related power generation happening around the world.
2008-08-27
521 reads
The Million Message System
Sun Microsystems built a database application that processes a million messages a second. Steve Jones talks about the achievement.
2008-08-26
57 reads
Working Under Pressure
A time of crisis means a lot of things to people in technology, but Steve Jones talks about something that's often forgotten.
2008-08-25
61 reads
Believe in Your Data - Database Weekly (Aug 25, 2008)
As DBAs we must secure and protect data, but what can we do when there are fundamental issues with the way the systems are designed. Steve Jones comments on problems with voting machines.
2008-08-22
238 reads
Managing Security
This Friday Steve Jones comments on the practice of using Active Directory to help manage your SQL Server and what the best practice should be.
2008-08-21
50 reads
The Brainstorm Zone
There are times we all struggle finding solutions to the issues at work. Steve Jones talks about how to make that breakthrough in solving problems when you are stuck.
2008-08-20
63 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