Friend of Redgate 2016
I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and...
2016-02-07
9 reads
I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and...
2016-02-07
9 reads
I’m proud to announce that I will be speaking at SQLSaturday Chicago on March 5th 2016! This will be my...
2016-01-29
849 reads
I’m proud to announce that I will be speaking at SQLSaturday Chicago on March 5th 2016! This will be my first SQLSaturday event and I’m really excited that I...
2016-01-29
4 reads
This past week I had the pleasure of speaking for my first time professionally to the Chicago Suburban SQL Server...
2016-01-25
503 reads
Update for T-SQL Tuesday #84
Well, this year I was challenged with the goal of speaking publicly three times, well I blew that out of the water and have spoken...
2016-01-25
4 reads
2016-01-15
4 reads
What I’ve noticed this year is that there’s really not another group of people like the SQL Community. Earlier this...
2015-12-29
888 reads
What I’ve noticed this year is that there’s really not another group of people like the SQL Community. Earlier this year Paul Randal ( b | t ), in...
2015-12-29
2 reads
In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to...
2015-10-07 (first published: 2015-09-29)
7,721 reads
In our final post in our “Load Testing Your Storage Subsystem with Diskspd” series, we’re going to look at output from Diskspd and run some tests and interpret results....
2015-10-06
5 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...
Telp/WA.0821°3111°179 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta...
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
Hi to all We have situation at a client where someone is illegally changing...
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