TSQL Tuesday – But I was Late
I was late to the game having discovered the Blog Post the day after entries were allowed. Despite that, I...
2010-01-14
835 reads
Jason Brimhall
Primary Key Discovery II
In Part I, I discussed a couple of scripts that could be used to help discover some vital information about...
2010-01-13
639 reads
Professional Communications
This past week I had the opportunity to have lunch with a vendor at his clients’ site. As a part...
2010-01-10
519 reads
Goals For 2010
Like a lemming in the DBA community, I too am going to post my 2010 goals. I am looking to...
2010-01-08
466 reads
SSC Syndication
Steve Jones at SqlServerCentral.com has created a Blog for me over there at SqlServerCentral.com. I will be syndicated there and...
2010-01-07
605 reads
Primary Key Discovery
As a part of my DB documentation process for a large database, I needed a method to quickly show me...
2010-01-05
705 reads
Users Group Participation
I have been pondering over my local PASS chapter and participation. And more specifically about why I should participate, and...
2010-01-04
992 reads
2009-12-21
5,099 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...
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...
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