Tampa Code Camp is December 2, 2008
In recent years this event has been held in July, but this year they ran into problems when the planned...
2008-09-17
453 reads
Blog Posts
Business of Software 2008 - Selling 101
I'm starting a series of blog posts from the Business of Software conference
that I attended last week in Boston. If...
2008-09-16
847 reads
Cross Functional Teams & Cross Training
Cross functional teams sounds a lot like a buzzword, and maybe it is to a degree - but still worth talking...
2008-09-16
565 reads
Business of Software 2008 - Pecha Kucha
I'm starting a series of blog posts from the Business of Software conference
that I attended last week in Boston. If...
2008-09-15
747 reads
Kindle - Chapter by Chapter
I haven't done as much reading on the Kindle since I've been home from my last trip, mainly because I've...
2008-09-15
820 reads
Relaunching JumpstartTV.com
We experimented with some video training back in 2004/2005 on SSC, but we just didn't have the time/energy to pursue...
2008-09-15
571 reads
Announcing SQLSaturday #10 - Tampa 2009
Pam Shaw & Wes Dumey are leading the charge for the 2nd annual Tampa SQLSaturday on January 24, 2009. They are...
2008-09-14
479 reads
SQL Code Review - Scalar Variables
One very common mistake I see when reviewing code is the case where the select statement is returning multiple rows,...
2008-09-14
528 reads
Business of Software 2008 - YCombinator - Jessica Livingston
I'm starting a series of blog posts from the Business of Software conference
that I attended last week in Boston. If...
2008-09-12
765 reads
Kindle - The Two Week Followup
It's been two weeks since I got the Kindle. Actually it will be two weeks in a few hours. I've...
2008-09-12
981 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