Database is in Transition
One of my clients called saying they were receiving the following error when trying to access a database: "Error 952...
2009-08-12
7,037 reads
Blog Posts
Design can be too simple
I've advocated simple design for years, trying to give users less choice, help lead them down paths to get their...
2009-08-12
548 reads
Excellent Blog List
For the one or two you that are not reading Buck Woody’s blog (and why aren’t you), you may not...
2009-08-12
704 reads
Getting Security Vulnerability Information
Staying abreast of security vulnerability alerts can be a daunting task because there are so many each day. One source...
2009-08-12
1,161 reads
LinkedIn For Business
Ran across this recently, 33 Ways to Use LinkedIn for Business and thought I’d post it since I’ve talked about...
2009-08-12
319 reads
LIVE MEETING REMINDER - Baton Rouge SQL Server User Group
Reminder: The Baton Rouge Area SQL Server User Group will be broadcasting its user group via live meeting. If you...
2009-08-12
453 reads
No Training Budget Still No Excuse
When I first started by career in IT and SQL Server about 10 years ago I lived in a small...
2009-08-12
458 reads
PASS Connector Editorial for August 12, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-08-12
414 reads
So many topics, so many blogs.......What says you?
So, what should I talk about next? There's so much going on in the world of SQL Server (ie: 2008,...
2009-08-12
730 reads
SQL Quiz 5: SANs Mirroring
My turn to answer Chris Shaw’s questions “Do I feel I have a reliable SAN solution?” and “Describe Database Mirroring...
2009-08-12
631 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