Speaking at Colorado Springs SQL Server User’s Group on June 15
I will be speaking at the Colorado Springs SQL Server User’s Group, live and in person, on Wednesday, June 15,...
2011-05-09
516 reads
Glenn Berry
PASS 2011 Summit Abstract Submissions
Today is the last day to submit session abstracts for the PASS 2011 Summit. I was lucky enough to speak...
2011-05-04
478 reads
A SQL Server Hardware Nugget A Day – Series Recap
Writing a month long series is always a lot more work than you initially expect. You would think that I...
2011-05-01
630 reads
A SQL Server Hardware Nugget A Day – Day 30
For Day 30 of this series, (which is the last day), I am going to talk a little about RAID,...
2011-05-01
932 reads
A SQL Server Hardware Nugget A Day – Day 29
For Day 29 of this series, I am going to talk about some of the basic things that you should...
2011-04-30
1,394 reads
A SQL Server Hardware Nugget A Day – Day 28
For Day 28 of this series, I am going to talk a little bit about some upcoming developments in Intel...
2011-04-28
1,643 reads
A SQL Server Hardware Nugget A Day – Day 27
For Day 27 of this series, I am going to talk a little bit about disk performance and one easy...
2011-04-27
1,319 reads
A SQL Server Hardware Nugget A Day – Day 26
For Day 26 of this series, I want to talk a little about laptop processor selection (since I get a...
2011-04-26
1,240 reads
A SQL Server Hardware Nugget A Day – Day 25
For Day 25 of this series, I want to talk about how you go about picking a CPU for your...
2011-04-25
538 reads
A SQL Server Hardware Nugget A Day – Day 24
For Day 24 of this series, I want to talk a little bit about the TPC-E OLTP benchmark.
The TPC...
2011-04-24
746 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
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...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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