June S3OLV Update
This is a real quick update. It has been requested that we go ahead and provide LiveMeeting for tonight as...
2011-06-09
493 reads
SQL RNNR
June S3OLV Update
This is a real quick update. It has been requested that we go ahead and provide LiveMeeting for tonight as well. Thus Charley will be presenting in person but...
2011-06-09
3 reads
Meme Monday – Stupid Questions
This month we have an interesting topic for Meme Monday. This is hosted by Thomas LaRock and the topics revolve...
2011-06-06
575 reads
Meme Monday – Stupid Questions
This month we have an interesting topic for Meme Monday. This is hosted by Thomas LaRock and the topics revolve in some way around SQL Server. As Tom brought...
2011-06-06
9 reads
June 2011 S3OLV Meeting
It’s Grillin’ Time
OK, so we won’t be grilling inside the meeting – or even at the meeting. But it sure sounds...
2011-06-06
462 reads
June 2011 S3OLV Meeting
It’s Grillin’ Time OK, so we won’t be grilling inside the meeting – or even at the meeting. But it sure sounds good. There will likely be Pizza and...
2011-06-06
3 reads
MCITP: 2 Down 2 to go
It’s time for the weekly update. Much like last week, we had more issues with taking this exam today. I...
2011-05-26
585 reads
MCITP: 2 Down 2 to go
It’s time for the weekly update. Much like last week, we had more issues with taking this exam today. I scheduled exam 70-433 for first thing in the morning...
2011-05-26
4 reads
CTE, Recursion and Math
Earlier this month we had a TSQL Tuesday on the topic of CTEs. I bailed on my submission because I...
2011-05-23
1,475 reads
CTE, Recursion and Math
Earlier this month we had a TSQL Tuesday on the topic of CTEs. I bailed on my submission because I already posted some CTE examples and was bone dry...
2011-05-23
12 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