Bloated
What is going on with all this production data? Steve Jones talks about the need to manage data growth and is it really worth the resources.
2008-04-13
28 reads
Editorial - iPod
Behind the Curtain
Commentary on the database related news of the past week. SQL Server 2008 Certification, deep inside SQL Server and the Library of Congress.
2008-04-12
27 reads
Historical Dollars
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
2008-04-10
36 reads
The Social Mesh
Steve Jones talks about some research from Dr. Cross, a professor from his alma mater, into social networks and how work gets done in a company.
2008-04-09
28 reads
The Feature Debate
Is SQL Server keeping up with MySQL or is it the other way around. Steve Jones comments on a few of the differences in the platforms.
2008-04-08
30 reads
Securing Data
It's important that you do more than just implement perimeter security with firewalls. Steve Jones talks about how we can better secure our systems.
2008-04-07
27 reads
The Cost of Support
Microsoft is not planning on releasing Service Pack 3, but what is the best model for supporting software? Steve Jones gives a few thoughts.
2008-04-06
29 reads
Windows 7 and More
A look back at the news of the past week including Windows 7, SSD performance, April Fools, and consistency in SQL Server.
2008-04-05
229 reads
2008-04-03
521 reads
Try To Be More Inefficient
Steve Jones is recommending that you don't work the most efficient way at your job. Sometimes.
2008-04-02
28 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