More Seattle Food
Was browsing on a break and found this, http://www.seattle.com/dining/. Of them I’ve been to Palomino (good) and Ruths Chris (good),...
2009-10-29
751 reads
Blog Posts
My PASS Summit 2009 Schedule
Hooray! The PASS Summit is upon us (finally)! Here's what my plans look like for next week:
Monday
My week starts...
2009-10-29
654 reads
Need an Aircard for a Few Days?
Ran across this, http://daypasswireless.com/, lets you rent an aircard plus service. Don’t know if it’s too late for those of...
2009-10-29
640 reads
OFF-TOPIC: More about the pregnancy
Quite a few folks have commented about my previous post about missing the PASS Summit, whether publicly or in private....
2009-10-29
890 reads
Special Events at the PASS Community Summit
If you’ve ever been to a PASS Community Summit, you know that each day is packed with a ton of...
2009-10-29
464 reads
SQL University: Multiple Paths and Ownership Chaining
Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...
2009-10-29
2,671 reads
Suggested Max Memory Settings for SQL Server 2005/2008
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...
2009-10-29
253,566 reads
There was a rancher who had a DBA.... (Getting prepped for PASS)
and B-I-N-G-O was his game-o.
Maybe not that funny, but I think that SQL Bingo will be a fun time. If...
2009-10-29
824 reads
What Should PASS Strive To Be?
Steve Jones had a good editorial earlier this week entitled, What Do We Want from PASS?. It didn’t generate as...
2009-10-29
930 reads
Amazon.com Author Central Page
If you are a book author, Amazon.com now allows authors to promote their books with a new author’s page. The...
2009-10-28
609 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