Jobs change over time, and database administrator jobs are no different. In this 35 minute recorded Twitch livestream (my first ever!) I talk about threats to DBA jobs and...
2019-01-18
8 reads
Next week, I’m giving a free webcast for Redgate on DevOps fundamentals. DevOps is something I am a big proponent of for database administrators, developers, and company leaders. The...
2019-01-17
3 reads
A magical thing happened this week in the SQL Community Slack (it’s free to join, by the way, sign up here). In the midst of a discussion about the...
2019-01-16
43 reads
I recently participated in a panel discussion for the SQL PASS DevOps virtual chapter. If you didn’t make the meeting, you can catch our 90 minute discussion here about...
2019-01-10
3 reads
I recently spoke at the GroupBy free online conference. It was loads of fun, and the recordings from the event are now available. Here’s the hour long session I...
2019-01-03
5 reads
There’s a lot of information out there on data breaches. I’ve written before about one source that I trust — the Verizon Data Breach Report (DBIR). The 2018 DBIR...
2019-01-02
6 reads
I recently got together with fellow Microsoft Data Platform MVPs Steve Jones, Kathi Kellenberger and Grant Fritchey to discuss the highlights of innovations we’ve seen in 2018 and predictions...
2018-12-27
8 reads
One of the things that brings Microsoft MVPs together each year is complaining about the pains of reporting community contributions to Microsoft. This is a typical first world problem,...
2018-12-26
7 reads
I recently did a bit of research on the source of data breaches. In this post, I’ll talk a bit about my current favorite source for breach information, and...
2018-12-03
14 reads
Update: The survey is now closed, thanks folks! When I began working with databases, nobody talked about DevOps. It was a few years before I heard the words ‘Agile’...
2018-11-27
4 reads
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Jl. Barata Jaya No. 76-76A, Baratajaya, Kec. Gubeng, Surabaya, Jawa Timur 60245
BCA KCP Gatot Subroto Telpon/wa:0813.7887.595.Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit...
Jl. Ngagel Jaya Selatan No.25, Pucang Sewu, Kec. Gubeng, Surabaya, Jawa Timur 60283
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