Smart As A Bear?
I got this at Hobby Lobby for $7 on sale, it’s about the width of a license plate and a...
2014-05-14
312 reads
SQLAndy
Warrant Canaries & Transparency
I recently ran across the warrant canary FAQ from the Electronic Frontier Foundation (EFF). The concept is simple – put up...
2014-05-14
550 reads
Announcing the 2014 SQLSaturday Orlando Seminars
On September 25, 2014 we’re pleased to have David Pless presenting an all day seminar on Enterprise Management and Monitoring...
2014-05-13
370 reads
Verizon PCI and Data Breach Investigation Reports
If you deal with security and especially credit cards it’s worth spending an hour or two to read the 2014...
2014-05-13
441 reads
Writing Another Question of the Day
The most recent one I wrote was a “question from error message” pattern. An experienced DBA should get it easily,...
2014-05-12
355 reads
Notes From SQLSaturday #298
The trip didn’t start smoothly for this one. Wed night I was really sick with some kind of stomach flu....
2014-05-12
427 reads
Off to Jacksonville for SQLSaturday #298
I’m looking forward to returning to Jacksonville after missing a year (or two?) to speak at SQLSaturday #298. I’m driving...
2014-05-09
338 reads
Speaking at MagicPASS on May 28, 2014
If you’re wondering who the mystery speaker is – it’s me! I’ll be doing two presentations at Magic Pass on May...
2014-05-08
339 reads
Another User Has Locked My File!
I had an SSIS package fail in a script task this morning. As part of the why process I opened...
2014-05-07
346 reads
Datatypes In Your Mind–Question Of The Day
My latest question Datatypes In Your Mind is live today and it’s generated quite the discussion. I wrote here about...
2014-05-06
470 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 Pulogadung Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Raya Bekasi No.B-C Km.19 No.30, RT.1/RW.6, Wil, Kec. Pulo Gadung, Kota Jakarta...
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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