Do you want me to tell you the truth or do you want me to tell you what you want to hear?
We live in a Dilbert age.
If you are a DBA and have worked in organizations of any size you are...
2013-09-28
1,725 reads
I am on LinkedIn
I don't know why, but I never "got" LinkedIn and I ended up leaving it in frustration as I was...
2013-09-21
715 reads
Is Microsoft attempting to "de-skill" IT Pros in its attempt to increase its Cloud business?
When I first heard of the MCM program termination discontent, I reacted by sympathizing with my fellow Database Professionals but...
2013-09-05
968 reads
Working Class Hero
I could tell you a story about Green Day's cover of John Lennon's classic "Working Class Hero" that you wouldn't...
2013-08-29
811 reads
2013-08-23
720 reads
OT: privacy
I had a very unpleasant experience a while back when I was commenting anonymously on a web site (not SQL...
2013-08-06
590 reads
energy
Back when I was trying to start a business and unknowingly heading towards a economic cliff, I read all sorts...
2013-07-10
588 reads
freedom
I was thinking back fondly of my Dad - who passed away during Hurricane Sandy - this past Father's Day. Of the...
2013-07-03
561 reads
SQL Server 2000 is unsupported
Microsoft no longer supports SQL Server 2000 in any capacity.
http://youtu.be/A5cneCgNA9U
2013-04-10
819 reads
Carry On
Sometimes the answer is to keep going.
Forget words, figuring things out, and circumstances. Just keep moving your feet.
~Chuck
"Nothing in the...
2013-04-09
617 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