Conservative or Risky?
What type of leadership do you want in your company? Steve Jones asks who you want to help steward you through these tough economic times.
2009-02-12
513 reads
Editorial - iPod
Global Warming and Business Intelligence
What does global warming have to do with BI? Steve Jones explains.
2009-02-11
623 reads
The New Office
A tour of the new Red Gate Software offices from Steve Jones, looking at how a modern software company has set up it's space.
2009-02-10
625 reads
Trust
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
2009-02-09
66 reads
The Oscars
As Steve Jones heads off for holiday, he asks a Friday poll question that should distract you from work for a few minutes.
2009-01-29
548 reads
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
2009-01-28
535 reads
Earning Credit
The topic of plagiarism rears its head at SQLServerCentral and Steve Jones has some comments and an apology.
2009-01-27
537 reads
The January 2009 Car Update
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
2009-01-26
477 reads
2009-01-22
573 reads
Risk and Assumptions
Building software always involves risk, but in these tough times, Steve Jones thinks we should be working to lower the risk of IT projects.
2009-01-21
428 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