SQLSaturday in Orlando
I imagine many of you have seen or attended a Code Camp, a one day free mini conference type event...
2007-07-23
1,500 reads
I imagine many of you have seen or attended a Code Camp, a one day free mini conference type event...
2007-07-23
1,500 reads
This turned out to be a nice event, better venue than last year. Well organized is always appreciated even at...
2007-07-18
1,370 reads
Not a happy story, but if you've got a child I suspect it will be easy to decide to buy...
2007-07-12
1,389 reads
NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its...
2007-07-09
907 reads
Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be...
2007-07-09
601 reads
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
715 reads
I just got my author copies of the Sybex book for exam 70-444 and have to say the book looks...
2007-07-05
733 reads
My friend and former co-worker Chris Rock just posted at article over at SQLTeam.com that has a pretty good walk...
2007-06-27
1,366 reads
I'm at the bookstore today alternating some work with some professional development time and was reading some of Celko's SQL...
2007-06-20
1,414 reads
SSC had a fairly routine article up recently about The GO Command the Semi Colon Terminator which I read, and...
2007-06-18
1,371 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