2016-03-14
106 reads
Editorial
2016-03-11
131 reads
Building Better Software
Steve Jones discusses the idea of building software better, and why that's a challenge for many of us.
2016-03-10
109 reads
The Slack Integration
Slack has become a popular phenomenon in the technical world, especially for software developers. Should we join in?
2016-03-09
224 reads
The Data Driven Event
In a couple of days, Microsoft is holding Data Driven, an event that will highlight SQL Server 2016.
2016-03-08
106 reads
2016-03-07
292 reads
Testing times with SMO
SMO gives every appearance of being a great example of over-reliance on automated testing at the expense of manual exploratory testing.
2016-03-07
64 reads
Spousal Surcharges
Today we have a guest editorial from Andy Warren that examines the costs of family at work.
2016-03-04
173 reads
Open is Not Necessarily More Secure
Just because we can view the source code for software doesn't mean it is more secure.
2016-03-03
98 reads
Learning from Microsoft
Microsoft has changed their engineering to do amazing things in the cloud, especially with SQL Server. We could all learn from this.
2016-03-01
263 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU SOEKARNO HATTA TLP/WA 083800209966
Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat 40227
BCA KCP TAMIM TLP/WA 083800209966
Jl. Dulatip No.26 & 26A, Kb. Jeruk, Kec. Andir, Kota Bandung, Jawa Barat 40181
BCA KCU BANDUNG TLP/WA 083800209966
Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
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