The Ten Commandments for DBAs
What should a good DBA do? Steve Jones came across a list he likes that showcases those things that should guide your efforts on a daily basis.
2014-09-15
409 reads
Editorial
The DBA Team Wants You!
There's a new contest going on, giving you the chance to win some software, SQL training, and a vacation, all at once.
2014-09-11
179 reads
Prepping for 2015
Steve Jones looks ahead at the new year and how you might want to begin shaping your career.
2014-09-10
191 reads
Estimates
Software estimates are often wildly off from the actual amount of time and resources that are required. Today Steve Jones looks at a few reasons why.
2014-09-09
198 reads
2014-09-08
367 reads
Misconfiguration is a Problem
The configuration of server systems matters. Not just to ensure software runs smoothly, but also for security.
2014-09-08
90 reads
Titles Matter – Part 2
In a followup to his previous piece, Andy Warren looks at job titles again and they can affect the people he works with.
2014-09-05
193 reads
2014-09-02
257 reads
On the importance of a complete break
If you’re the type who habitually checks work email and thinks about work while on holiday, here’s Gail Shaw's challenge for next time: don’t.
2014-09-01
179 reads
2014-09-01
78 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 KCU SUDIRMAN Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi, Kota Jakarta Selatan,...
BCA KCU KEBAYORAN BARU Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru, Kota Jakarta...
BCA KCU PONDOK INDAH Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, 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