Where in the world are Jen and Sean?
Updated with more SQL Saturdays! Well hi there, folks. A month slips by so very fast. Here is your January...
2016-01-28
1,037 reads
Jen McCown
Fun with Operator Precedence
Let’s have some fun with operator precedence today. Specifically, logical operator precedence. Specifically, how is it evaluated when your where clause...
2016-01-06 (first published: 2015-12-31)
2,814 reads
Issues and opinions on the PASS anti-harassment policy (#sqlpass)
PASS just published an anti-harassment policy reminder, quickly followed by a blog by Wendy Pastrick (about a bad experience at last...
2015-11-25
945 reads
A Data Age proclamation
Twice in two days now, I’ve gotten in discussions with people about the state of data usage…the idea that we have...
2015-11-12
697 reads
Improved #MinionBackup and #MinionReindex – new versions!
We released Minion Backup 1.1 and Minion Reindex 1.2 this week! We’ve got a some great new features, and a number of bug fixes....
2015-10-23
667 reads
Attending PASS Summit? Take a great Tuesday precon!
We’re just two weeks away from the PASS Summit in Seattle, and there is most definitely still time to get...
2015-10-12
608 reads
You DO have outstanding, free backup and maintenance, right?
It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on...
2015-10-07
663 reads
Today at 12pm Central: #MinionEnterprise Talk – Backup Management!
Register here. In our monthly series about Minion Enterprise – the new SQL Server management solution – Sean and Jen will show you how...
2015-10-06
641 reads
PASS Summit 2015: Recommendations and Invitations (#sqlpass #Summit15)
The last week of October, we’ll be at the PASS Summit in Seattle, WA. As some of you already know – and as I...
2015-09-28 (first published: 2015-09-09)
1,262 reads
SQL Saturday San Diego tomorrow! (September 18)
This weekend we’re going to hit SQL Saturday San Diego for the first time ever! We are the excited. Come and...
2015-09-18
809 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