The Age of Data and Software Development
I am so excited to be a data professional in the modern era. Yeah, 15-20 years ago, it was cool...
2017-04-17
403 reads
I am so excited to be a data professional in the modern era. Yeah, 15-20 years ago, it was cool...
2017-04-17
403 reads
In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However,...
2017-04-04
624 reads
I’m working on a technical blog post that I hope to be putting up soon. I’ve run into a number...
2017-04-03
425 reads
The winner is: Everyone.
Hey, the challenge was random. I didn’t promise a prize or a winner. Instead, I suggested everyone...
2017-03-29
645 reads
I made a mistake the other day. For some reason I got it into my head that I was flying...
2017-03-28
448 reads
I’ve written several times about the Cost Threshold for Parallelism and it’s relationship to your execution plans, how to determine...
2017-03-23 (first published: 2017-03-13)
3,007 reads
I believe in DevOps.
Actually, that’s a pretty horrible way to put it. It’s not about belief, like keeping Tinkerbell alive.
I...
2017-03-20 (first published: 2017-03-07)
1,837 reads
Redgate has released a new product, SQL Clone. I’ve already talked about how excited I am about it. Now, it’s...
2017-03-13 (first published: 2017-03-06)
1,755 reads
In the previous post, I showed how you can get full listings of your execution plan costs. Knowing what the...
2017-03-09 (first published: 2017-02-28)
1,953 reads
Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server...
2017-03-06 (first published: 2017-02-27)
2,145 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...
Telp/wa 085169998765 Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah, Kec. Purwakarta,...
Telp/wa 085169998803 Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah, Kec. Purwakarta,...
Jl. Daan Mogot No.KM. 11, Wisma SSK, Kecamatan Cengkareng, Kota Jakarta Barat, Daerah Khusus...
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