The Perfect is the Enemy of the Good (Again)
I wrote an editorial for SSC back on January 19th about the perfect being the enemy of the good. It’s...
2010-02-17
506 reads
Blog Posts
The Power Grid (No, Not THAT Power)
Yesterday I had the Adversity Index, today it’s the Power Grid from MediaIte. It attempts to score the power of...
2010-02-17
747 reads
Buck Woody on Code Writing Code
I realize I’m prejudiced, being one of those evil DBA’s & all, but I can’t help but agree with him. It’s...
2010-02-16
779 reads
In Vs. Inner Join
This is tightly related to another of my forays into tuning some slowly/poorly performing processes. This process came across my...
2010-02-16
872 reads
Job Quality
Through a circuitous route, I encountered a meaningful, thought-provoking quote lately: "... the best way to predict the future is to...
2010-02-16
1,517 reads
Panic Attack
I had a minor panic attack recently where I was getting ready for bed and all of a sudden thought...
2010-02-16
887 reads
Presenting in Colorado Springs on May 19, 2010
I will presenting at the Colorado Springs SQL Server User’s Group (CSSQLUG) on Wednesday, May 19, 2010. I will be...
2010-02-16
643 reads
Quick Tip Of The Day
Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...
2010-02-16
2,598 reads
Review: Windows Live Writer Backup
Live Writer tends to be one of those applications that you spend a few minutes configuring and then you forget...
2010-02-16
580 reads
SQL Developers Please Use the Table Name/Alias to Prefix Columns
Note: After I completed this post Aaron Bertrand added this subject to his “Bad Habits to Kick” series for myself...
2010-02-16
871 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