Get User In Reporting Services-Question of the Day
Get User In Reporting Services is my newest question to be published at SQLServerCentral.com as a “Question of the Day”....
2014-05-27
508 reads
SQLAndy
It’s Time to End Password Reuse
Last week Ebay announced that some accounts were compromised, including passwords with as yet unstated encryption. Those who aren’t tech...
2014-05-26
684 reads
Building The SQLSaturday Orlando Marketing Plan–Part 12
Meetup.com did refund my $19, good!
Team oPASS added SQLSaturday #318 to their calendar, you can see it here, or here’s...
2014-05-24
554 reads
Building The SQLSaturday Orlando Marketing Plan–Part 11
Just received the first flyer design – thoughts?
2014-05-24
548 reads
Wishing For Error Messages That Are Good Search Terms
Here’s a SQL error you might get:
not able to access the database “SomeDB” under the current security context.
If you don’t...
2014-05-23
522 reads
Building The SQLSaturday Orlando Marketing Plan–Part 10
My experiment with Meetup.com hasn’t worked out well so far. I set up the event site and sent it around...
2014-05-23
532 reads
Writing A Question Of the Day–More Notes
One of the things I’m trying to do now is include a link to a blog(ger) in the explanation. That...
2014-05-22
489 reads
An Sp_addrolemember Gotcha
Over the past few months there have been a handful of times when I had to fix a security problem...
2014-05-22
826 reads
Submitted My Application For the 2014 PASS Nominating Committee
I just finished up the short and not very painful application to be a candidate for the NomCom this year. ...
2014-05-21
496 reads
Building The SQLSaturday Orlando Marketing Plan–Part 9
I’ve heard more than once that Meetup.com is a good way to reach new people so we’re looking at how...
2014-05-21
700 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