Quick tip: Zoom in Azure Data Studio
If you finally have given a try to Azure Data Studio, and if you use it on a regular basis, maybe you want to customize it to suit your...
2019-03-13
12 reads
If you finally have given a try to Azure Data Studio, and if you use it on a regular basis, maybe you want to customize it to suit your...
2019-03-13
12 reads
A quick video clip showing how to create a deadlock in SQL Server and find information about it.
2019-03-13
1,120 reads
I often get emails asking the same time of questions about the setup of Telegraf for SQL Server and Windows...
2019-03-13
487 reads
Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data...
2019-03-13
638 reads
This months TSQL Tuesday is hosted by Shane O’Neill (Blog | Twitter) Shane explains the Topic as:
Dipping into the Cookie Jar...
2019-03-12
280 reads
The topic for this months T-SQL Tuesday #112 hosted by Shane O’Neill (Blog / Twitter) is about “dipping into your cookie jar”. This reference...
2019-03-12
237 reads
The Gartner Magic Quadrant for 2019, announced earlier this month, names Microsoft the leader in Analytics and Business Intelligence Platforms....
2019-03-12 (first published: 2019-02-23)
4,334 reads
Redgate is building a library of real-world stories about database development disasters. Your mission: Tell us a true story in 500 words or less about a time when you...
2019-03-12
8 reads
This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...
2019-03-12
3 reads
This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...
2019-03-12
2 reads
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
BCA KCP Kramat Jati Hub.0851•8812•0691 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati,...
BCA KCU MUARA KARANG Hub.0851•8812•0691 Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah...
BCA KCP Kramat Jaya Baru Hub.0851•8812•0691 Jl. Percetakan Negara II No.16 B-C, RT.3/RW.3, Johar...
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