Compensation
Employee compensation is more than just salary. Steve Jones talks about how you might look at building more effective compensation plans for workers.
2008-02-05
97 reads
Editorials
2008-02-04
46 reads
More Layers
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
2008-02-04
56 reads
2008-02-01
339 reads
The January Car Update
The bimonthly update looks at a compressed air car, the X-Prize, daily rentals, and hybrid pickups.
2008-01-31
159 reads
Fixing SQL Server
If we will get a new version of SQL Server every 3 years, how can we make the process smoother.
2008-01-30
223 reads
The Mistake
SQL Server 2008 has been delayed and Steve Jones thinks the entire process of building this version has been poorly handled.
2008-01-29
433 reads
Lost in Translation
Common sense guidelines, removing local administrators and too much money in IT. Steve Jones comments on a few headlines from the week.
2008-01-28
79 reads
Tell Me What You Need
Ever worked on a software project where you didn't get all the requirements? One where the functions and features change in midstream? Steve Jones comments on some possibilities on why this happens.
2008-01-28
91 reads
2008-01-25
79 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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