Custom folders SSMS Add-In slightly delayed
I am desperately trying to finalize this add-in and it is very very close. I was performing another testing on...
2011-07-17
540 reads
I am desperately trying to finalize this add-in and it is very very close. I was performing another testing on...
2011-07-17
540 reads
While playing around with Denali, I came across a function that I believe should have been included in SQL for...
2011-07-17
1,671 reads
Here are two samples showing that SQL Injection is still here and dangerous !!!
source:xkcd.com
This use case is especially insidious
2011-07-16
668 reads
The eternal challenge with games, and free/cheap software in general, is knowing what’s out there, especially since you don’t always...
2011-07-15
660 reads
I just had my first encounter with having to write a PowerShell script. The request seemed pretty harmless when I...
2011-07-15
2,039 reads
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-15
751 reads
As I play with the recently released CTP3 of SQL Server Denali, I wanted to point something out about installing SSAS, since...
2011-07-15
1,917 reads
If your looking for presentations, demos, hands-on labs and videos to help you better understand SQL Server 2008 R2, then...
2011-07-15
486 reads
I am going to describe quite forgotten feature in SQL Server 2008. It is Change Data Capture (CDC) – powerful feature...
2011-07-15
2,529 reads
Yesterday I posted about manipulating group membership to get access to a SQL Server. Today comes attack vector #2: stealing an...
2011-07-14
1,192 reads
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...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Jl. Danau Agung 2 No.1A Blok E2, Sunter Agung, Podomoro, Jkt Utara, Daerah Khusus...
Blk. B, Komplek Rukan Kelapa Gading Square, Jl. Boulevard Bar. Raya No. 21 &...
Jl. Ir. H. Juanda 3 No.34, Kb. Klp., Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
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