2010-05-20
770 reads
Blog Posts
New SQL Standard Article
A new article for the SQL Standard is now available. You can find the article here. The article is by...
2010-05-20
605 reads
Plagiarized
Today I ran into an interesting website. While I was trying to locate information concerning a SQL Saturday event, I...
2010-05-20
536 reads
Plagiarized or Copied
Today I ran into an interesting website. While I was trying to locate information concerning a SQL Saturday event, I...
2010-05-20
715 reads
PowerShell Week at SQL University – Post 3
Providers
What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and...
2010-05-20
808 reads
PowerShell Week at SQL University – Post 3: Providers, PSDrive
Providers
What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and...
2010-05-20
1,273 reads
PowerShell Week at SQL University – Post 3: Providers, PSDrive
Providers What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and traverse-able just like a directory structure hard drive....
2010-05-20
17 reads
Preparing for SQLSaturday #49
We’re still in the early stages so the pace is comfortably slow. We’ve got about 30 sessions in already (plenty...
2010-05-20
517 reads
SQL Server MasterClass – London
Further to my post on May 18th regarding the above event – I have been able to secure a further £50...
2010-05-20
527 reads
Using PATINDEX to Split Column Data
A colleague of mine received an Excel file that he needed to load into a table for future lookup values....
2010-05-20
1,178 reads
Blogs
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...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
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
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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