Three Turns On The Road
Huh? My story? Okay. It was never easy for me. I was born a poor black child. I remember the...
2010-02-16
1,119 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
Out Of My Comfort Zone: Building a Web App
If you read Fundamentals of Storage Systems – Stripe Size, Block Size, and IO Patterns you know I built a little...
2010-01-19
1,329 reads
Fundamentals of Storage Systems – Stripe Size, Block Size, and IO Patterns
If you have been following this series we have covered system buses, hard disks, host bus adapters and RAID. Along...
2010-01-04
46,867 reads
A Year In Review
It’s been a busy year for me. Last year I quit traveling and took a 8 to 5 job so...
2010-01-02
772 reads
Fundamentals of Storage Systems – RAID, An Introduction
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-15
4,053 reads
Fundamentals of Storage Systems – Disk Controllers, Host Bus Adapters, and Interfaces
We have covered the Hard Disk and the System Bus. This time around we will cover disk controllers and host...
2009-12-11
3,898 reads
Fundamentals of Storage Systems – RAID and Hard Disk Reliability, Under the Covers
In the last RAID article we covered the basics. This is a little deeper dive into the underlying mechanics of...
2009-12-08
1,523 reads
Fundamentals of Storage Systems – RAID, An Introduction
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-07
8,929 reads
Fundamentals of Storage Systems – Disk Controllers, Host Bus Adapters, and Interfaces
We have covered the Hard Disk and the System Bus. This time around we will cover disk controllers and host...
2009-12-03
6,472 reads
Fundamentals of Storage Systems – Testing IO Systems
12/03/2009 - UPDATE! There were a couple of bugs in the SQLIOCommandGenerator new SQLIOTools.zip has been updated.
------------------------------------
I often tell people one...
2009-12-02
1,577 reads
Blogs
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...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
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...
How do I explain that SQL Server should not be used as a code repository?
This week my BI Developer colleague proudly showed me a new Power BI report...
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