Notes on the Jacksonville Code Camp 2009
I'm a couple weeks last posting this, but wanted to get my notes down anyway for future use. The goal of...
2008-09-09
465 reads
I'm a couple weeks last posting this, but wanted to get my notes down anyway for future use. The goal of...
2008-09-09
465 reads
I'll define a brown bag lunch as a training event held at lunch time where someone on the team does...
2008-09-08
1,100 reads
Sorry, I couldn't help not including 'Book Review' on the subject line, hopefully you're not too disappointed!
I just finished reading...
2008-09-07
357 reads
Renaming Databases was just published on SSC, another in my lastest effort to expose some of the hidden complexities in seemingly...
2008-09-04
295 reads
If all has gone well I've been on vacation this week, enjoying the world class quartz sand at Siesta Key...
2008-09-04
1,110 reads
I do very little consulting these days, perhaps 4-5 weeks per year, and that only to make sure I maintain...
2008-09-03
295 reads
Creating Databases was actually posted last week, but got distracted with some other stuff. A basis walk through of creating...
2008-09-02
398 reads
Expert trainer and longtime DBA, Andy Warren, tackles the rather simple, but often understood, process of renaming a database. Learn about some of the issues you might encounter when trying to complete this task.
2008-09-02
9,701 reads
When I teach my introductory (and free) Successful Technical Speaking class to try to help beginners enter the world of speaking,...
2008-09-01
407 reads
It's Labor Day here in the US today, a holiday that is tribute to those of us that work, the journey to...
2008-08-31
1,773 reads
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
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...
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