2008-11-03
81 reads
Editorial - WMV
Life is Like a Manure Spreader
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about.
2008-11-02
67 reads
Dead LINQ - Database Weekly (Nov 3, 2008)
Steve Jones comments on a few pieces of interesting SQL Server news this week.
2008-11-01
471 reads
Happy Halloween 2008!
Steve Jones is taking a break on this fine holiday, enjoy a few bloopers before you head out with the kids for trick-or-treating.
2008-10-30
595 reads
The October 2008 Energy Update
The bimonthly update on the world of energy from Steve Jones talks about wind power.
2008-10-29
545 reads
2008-10-28
75 reads
Data Trust
How much do you trust companies with your data? Steve Jones finds a couple new web sites that offer great services, but is it worth the price?
2008-10-26
70 reads
Absolutely (Not?)
For this Friday's poll, Steve Jones asks about what absolutes you might have in your job.
2008-10-23
70 reads
A Virtual Database World
Steve Jones talks about virtualization with databases, but not in the way you might think.
2008-10-22
71 reads
36 Changes
Agile, or maybe even hyper-agile. Steve Jones talks about some challenges in the web 2.0 world.
2008-10-21
63 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