Devil's Advocate
With the one hand, Chris applauds the outstanding work of the SQL Server community, and tentatively raises the other to ask if we're on the cusp of a chance.
2011-08-22
121 reads
With the one hand, Chris applauds the outstanding work of the SQL Server community, and tentatively raises the other to ask if we're on the cusp of a chance.
2011-08-22
121 reads
As more and more companies move to virtualized servers, security should be on their minds. Steve Jones talks about that changes that you should consider.
2011-08-22
122 reads
Do you want to integrate Twitter with your database server? Steve Jones asks the question this week.
2011-08-19
132 reads
Benefits for workers seem to be on the decline. Steve Jones talks about the issue, which might be something you give more weight to when choosing your next job.
2011-08-17
144 reads
Solid State Drives are becoming more commonplace in database systems. eBay and Facebook have implemented large SSD systems in their environments. Steve Jones thinks DBAs should be learning more about how SSDs affect SQL Server.
2011-08-16
248 reads
This week Steve Jones reminds us that the basic skills we may take for granted might need some refreshing or updating.
2011-08-15
328 reads
How much do you need to sacrifice to succeed in business? It might be a lot, but Steve Jones says a lot of financial success is not worth losing your soul over.
2011-08-15
122 reads
This Friday Steve Jones is looking for help with interview questions. What questions have been hard in an interview or surprised you? Let us know and help others be prepared for their next interview.
2011-08-12
435 reads
Today we have a guest editorial from Andy Warren that looks at commuting to work.
2011-08-11
307 reads
Data is important, but today Steve Jones notes that what we do with it is even more important.
2011-08-10
113 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...
BCA KCU PLUIT Telpon/WA.0853•5504•2311 Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit,...
Gedung Sutrado, Jl. Kenari 2 No.5 Lt. 1, Kenari, Kec. Senen, Kota Jakarta Pusat,...
BCA KCU SUNTER Hub.0853•5504•2311 Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18,...
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