Free SQL Server Dashboard
Greg Larsen, a SQL Server DBA, and the owner of the website SQLServerExamples.com, has released a free plug-in for SSMS...
2009-09-23
831 reads
Blog Posts
Free SQL Server Dashboard
Greg Larsen, a SQL Server DBA, and the owner of the website SQLServerExamples.com, has released a free plug-in for SSMS...
2009-09-23
4,152 reads
Fun with Firewalls
We have a couple of boxes at a local Denver co-location facility for the training business, SQL Share. Our firewall...
2009-09-23
911 reads
MVP Profile of the Week.....
It’s time for the MVP Profile of the Week!
You’ve probably seen his work, as he’s been busy producing content for...
2009-09-23
1,403 reads
PASS Virtual Chapters
If you’re not a member of the Professional Association of SQL Server users, PASS, why not? No, I’m sorry. I...
2009-09-23
866 reads
Powershell and Passionate Evangelism
Back in July we had Chad Miller visit oPASS to do a presentation on Powershell. It was well received and...
2009-09-23
857 reads
Presentation Skills from Brent Ozar
If you present at any level, read this. If you’re thinking about presenting, read this. If you’d like to start...
2009-09-23
1,075 reads
SQL Lunch – Pick your favorite Logo
We have been working on the logo for a month now, but instead of making the final decision I have...
2009-09-23
772 reads
SSIS - Data Provider Does Not Allow Parameters in OLE DB Source
I recently worked on a project that involved loading a Data Warehouse from a DB2 source. In this project we...
2009-09-23
1,834 reads
Travel for 2010
Lately I’ve been thinking that I need to try harder to focus on doing the things I both want to...
2009-09-23
574 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
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