Wednesday PASS Keynote–Tom LaRock
We’re live at the opening keynote for the PASS Summit, on Wednesday, Nov 5, 2014. Tom LaRock opens the conference...
2014-11-05
851 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
2014-11-04
99 reads
2014-11-04
1,771 reads
A Fundamental Security Mistake
Steve Jones thinks Microsoft is making a fundamental security mistake in the way they build features for the various editions of SQL Server. Read today's editorial and see if you agree.
2014-11-03 (first published: 2009-12-21)
432 reads
Normalizing Performance
Determining the best performance value you can get for your effort is not as straightforward as you might think.
2014-11-03
212 reads
Setting Expectations–T-SQL Testing
I don’t know who started this pattern, as I’ve seen it in a few places. It could have been Sebastian...
2014-11-03
881 reads
The Geek Costume
This Friday Steve Jones has another fun poll. A question on the geek costume that might excite you the most.
2014-10-31
177 reads
2014-10-31
2,414 reads
Quick Schema Auditing
I was working on a demo recently and needed to show that a little monitoring can help you catch schema...
2014-10-29
1,128 reads
Stuck in a Rut
What do people do when their job doesn't require a lot of technical skills? Steve Jones has a few thoughts.
2014-10-29
168 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
Kantor BCA KCP Siliwangi Telp/wa 085169998803
Telp/wa 085169998803 Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah...
BCA KCP Ngaliyan Telp/wa 085169998765
Telp/wa 085169998765 Ruko Ngaliyan Square, Jl. Prof. Dr. Hamka No.17 No. 3A, Purwoyoso, Kec....
Kantor BCA KCP Ngaliyan Telp/wa 085169998803
Telp/wa 085169998803 Ruko Ngaliyan Square, Jl. Prof. Dr. Hamka No.17 No. 3A, Purwoyoso, Kec....
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