I Love Entity Framework
I love Entity Framework. I also like (not love) nHibernate. That’s right, as a DBA and data professional, I’m telling...
2017-07-17 (first published: 2017-07-05)
2,777 reads
I love Entity Framework. I also like (not love) nHibernate. That’s right, as a DBA and data professional, I’m telling...
2017-07-17 (first published: 2017-07-05)
2,777 reads
SQL Server provides multiple ways to perform most functions. In order to maximize your understanding of how SQL Server works...
2017-07-06 (first published: 2017-06-26)
1,993 reads
I want to take a moment to thank a few people for being amazing.
First up, Thomas LaRock is wrapping up...
2017-07-06
329 reads
2017-07-06
3,083 reads
I just read several more horror stories that include, among other things, failed backups. I’ve said it before (at volume,...
2017-06-26 (first published: 2017-06-19)
1,815 reads
Thank you to everyone who participated in T-SQL Tuesday #091 which was on databases and DevOps. As I anticipated, this...
2017-06-23 (first published: 2017-06-15)
1,714 reads
It’s worth noting that a lot of people will never need to create their own database. You may never create...
2017-06-20
492 reads
One of my favorite things about being a technologist is constantly learning new things, but, this can lead us to...
2017-06-15 (first published: 2017-05-31)
2,791 reads
The hardest part about implementing DevOps is not the tools you choose, but the processes you use to make DevOps...
2017-06-13
1,132 reads
The best way to learn any software is to start using it. There are a bunch of software tools in...
2017-06-12
1,086 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. Pluit Karang Blok D-7-U. 211A Kav.1 & No. 211, Kav 2, Daerah Khusus...
Jl. Samanhudi No.57 B, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat, Daerah Khusus...
Untuk menutup kartu kredit Bank UOB, Anda dapat hubungi UOBCall melalui WhatsApp (6288220114008): atau...
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