Roundup: Un-SQL #001 – Branding
Hi-ho all, and a wonderful Un-SQL event it’s been! We had at least twenty-six entries!! First, the recap:
While T-SQL Tuesday...
2010-11-23
792 reads
SQL Awesomesauce
Branding, my ass! (Un-SQL Friday 001)
Here is my contribution to my blog party, Un-SQL Friday 001: Branding. Join in the fun, won’t you?
I have a...
2010-11-19
1,003 reads
What’s New in SQL Server “Denali” CTP1
Denali. No, not that one...
How many of you have heard that the Community Technology Preview (CTP1) for the next version...
2010-11-18
734 reads
Un-SQL Friday 001: Branding
In the spirit of T-SQL Tuesday, I hereby declare this Friday Un-SQL Friday. While T-SQL Tuesday is “…the SQL Server...
2010-11-17
606 reads
Inspiration, and the Joy of the Hive Mind
PASS Summit 2010 is over, and we are suffering from the lack of chatter and SQL celebrity sightings. Bloggers are...
2010-11-15
584 reads
PASS Day 3: Keynote Live Blog
I’m live blogging the PASS keynote…it’s 8:44 local time.
Me: Tuesday is #SQLSat shirt day, Wednesday is #sqlkilt day, Thursday is...
2010-11-11
672 reads
SQLPASS Day 2: WIT Luncheon Live Blog
12:42pm local time at the live streamed Women in Technology luncheon…let’s blog. I’ll italicize my comments, to differentiate betwee that...
2010-11-10
1,126 reads
SQLPASS Day 2: Keynote Live Blog
Them's some SEXY DBAs...
I’m live blogging the PASS keynote…it’s 8:44 local time.
Here’s the PASS website description of the day 2 keynote...
2010-11-10
515 reads
SQLPASS Day 1: Keynote Live Blog
Day 1 Keynote Jumps the Shark with Tina Turner Impersonator
I’m live blogging the PASS keynote…it’s 8:38 local time.
You wouldn’t guess...
2010-11-09
762 reads
MERGE Statement Corrected, or, How to Eat Crow in Public
Better pull out the excuse-o-meter
I have no excuse, none whatsoever.
In my T-SQL Brush-Up presentation to the North Texas SQL Server...
2010-11-03
840 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
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:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
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