PASS Elections 2013
Yesterday the slate of candidates for the PASS Board of Directors was announced. Seven candidates for three open positions this...
2013-09-24
845 reads
SQLAndy
Finding The Active Sharepoint Databases
This was a task from last week. There was a server where we wanted to make some adjustments to security...
2013-09-23
956 reads
Notes from SQLSaturday #232 in Orlando
Our seventh annual SQLSaturday here in Orlando went well. To the casual observer it might appear to happen without effort,...
2013-09-16
662 reads
My 2013 PASS Suggestion Tsunami List
Back in August I posted about an approach that Aaron Nelson and I thought of to try to get more...
2013-09-09
796 reads
Log Backup Failing–A Simple Mistake
Last week I was checking on some stuff and noticed that a couple databases were in simple mode – unusual, but...
2013-09-05
701 reads
Skills I Used Last Week
Ever thought about what your average week looks like? What are the real core skills your environment uses every day...
2013-09-09 (first published: 2013-09-03)
2,424 reads
Building a Better Litter Box
First, I know as I write this that my friend Kevin will be emailing me later today that I’ve jumped...
2013-08-30
1,428 reads
Notes From The August 2012 OPASS Meeting
Luis Figueroa did a nice job presenting on Master Data Management. It’s nice to see the tools evolving, though I’ll...
2013-08-23
616 reads
Need Recommendations on Being a Better Listener
This past weekend I’ve been reading The Zen of Listening by Rebecca Shafir, part of my ongoing efforts to be...
2013-08-19
684 reads
Interview Candidates for Skills, Aptitude, Maybe Both
Over the years I’ve been primary a skills interviewer. In theory I know what skills are needed and in theory...
2013-08-20 (first published: 2013-08-15)
2,444 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
Forums
BCA KCP Ciputat TLP/WhatsApp 08218573837
Jl. Ir H. Juanda No.5, Ciputat, Kec. Ciputat, Kota Tangerang Selatan, DKI Jakarta 15411
BCA KCP Rawasari Telpon/wa:0813.7887.595
BCA KCP Rawasari Telpon/wa:0813.7887.595.Jl. Rawasari Sel. No.24 A, Rawasari, Kec. Cemp. Putih, Kota Jakarta...
BCA KCP Kopo Bihbul Telp/wa 085169998765
Telp/wa 085169998765 Komplek, Kopo Mas Regency, Blok 09C, Margasuka, Kec. Babakan Ciparay, Kota Bandung,...
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