Presenting in Colorado Springs on May 19, 2010
I will presenting at the Colorado Springs SQL Server User’s Group (CSSQLUG) on Wednesday, May 19, 2010. I will be...
2010-02-16
644 reads
Glenn Berry
SQL Server 2005/2008 Servicing Plans
Microsoft Group Program Manager Matthias Berndt has a post up on the Microsoft SQL Server Release Services blog (which is...
2010-02-13
591 reads
Round Two of Insert Benchmark Tests
After seemingly exhausting my physical file layout and instance configuration options in Round One of testing, I decided to “throw...
2010-02-09
529 reads
Speaking at the Rocky Mountain Tech Trifecta on February 27
I will be giving my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With...
2010-02-09
503 reads
Some Initial Insert Test Benchmarks on SQL Server 2008 R2
They say that imitation is the sincerest form of flattery. I have been following along as Paul Randal has been...
2010-02-07
4,338 reads
Detecting and Troubleshooting Non-Yielding Worker Threads in SQL Server 2005/2008
I had a little bit of excitement with one of my production servers couple of days ago, that I thought...
2010-02-04
3,123 reads
Three Engine Improvements in SQL Server 2008 R2
The upcoming (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI area...
2010-02-02
953 reads
Three Engine Improvements in SQL Server 2008 R2 (Updated)
The upcoming release (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI...
2010-02-02
428 reads
Some BI Related Official Microsoft Related SQL Server Blogs
My other Microsoft blog list was more focused on relational database administration and development, so here is my list of...
2010-02-01
295 reads
Some BI Related Official Microsoft SQL Server Blogs
My other Microsoft blog list was more focused on relational database administration and development, so here is my list of...
2010-02-01
757 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