New MVPs
Today's the day that new MVPs are notified for Q3 and two longtime community members, Jeff Moden and Michael Coles,...
2008-07-01
709 reads
Blog Posts
Quick and Dirty Code Compare
MS Word 2007 (and probably earlier versions) have the ability to do a basic document compare, useful if you're at...
2008-06-30
1,328 reads
Slacking and data quality (in that order)
Well, I almost missed blogging for the entire month of June. I'm sure that this fact didn't go unnoticed by...
2008-06-30
1,395 reads
Why Format TSQL?
Recently I had the chance to help a student debug a problem on a production server. It appeared to be...
2008-06-29
1,456 reads
More Kindle
I'm still on the fence here about a Kindle. I pinged someone that bought one and he said they're returning...
2008-06-26
1,500 reads
Volunteering
Recently I was visiting with an old acquaintance and one of the topics that came up was volunteers. At some...
2008-06-26
2,217 reads
One Note - Part II
Apparently other people like One Note. Microsoft is using it for learning content, and I think that's a cool idea....
2008-06-25
1,574 reads
SQLSaturday Call for Speakers - Cleveland & Olympia
Call for speakers is open for SQLSaturday #5 in Olympia, WA on Oct 10 (note that the MS BI conference...
2008-06-25
1,466 reads
Employee or 1099?
My friend Wes Dumey does a lot of work in the business intelligence sector as a contract employee and has...
2008-06-24
1,618 reads
SSWUG Virtual Conference II
Today is day one of the SSWUG SQL Server Virtual Conference II. This has been really fun so far. Our...
2008-06-24
1,516 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