What's Your Favorite Trek Episode?
Most of my posts here are reasonably serious, and really this one is too, but a but of humor mixed in....
2008-09-18
661 reads
Most of my posts here are reasonably serious, and really this one is too, but a but of humor mixed in....
2008-09-18
661 reads
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
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
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
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
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
One of the big decisions around vacations is whether it should be a 'do something' vacation or a 'do nothing'...
2008-09-11
1,253 reads
It's pretty common to see a mild plea from blog authors asking for feedback, or ideas about which to write...
2008-09-10
418 reads
One of the less used commands in T-SQL, the UNION command can come in very handy in a number of situations. SQL Server expert trainer, Andy Warren, discusses how you can use UNION.
2008-09-10
10,684 reads
PASS asked all speakers to update their blogs with news about the event (a good idea), so here's my post!
I'll...
2008-09-10
385 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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