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
509 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
685 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
490 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
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
BCA KCP KAS BANJARAN TLP/WA 083800209966
Jl. Raya Banjaran, RT.001/RW.007, Banjaran, Kec. Banjaran, Kabupaten Bandung, Jawa Barat 40377
BCA KCP KAS CINUNUK TLP/WA 083800209966
Jl. Raya Cinunuk No.133, Cinunuk, Kec. Cileunyi, Kabupaten Bandung, Jawa Barat 40624
BCA KCP KAS ANTAPANI TLP/WA 083800209966
Jl. Terusan Jakarta No.57, Cicaheum, Kec. Antapani, Kota Bandung, Jawa Barat 40282
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers