Always Canary
One way to make deployments smoother is to use a second system, but that's a challenge for databases, as Steve Jones notes.
2018-07-24 (first published: 2014-12-03)
144 reads
Editorial
The Value of Code
What's the value of code to your organization? Steve Jones thinks it's much larger than many people believe.
2014-12-02
138 reads
Facebooking Up to Your Social Responsibilities
Phil Factor argues that as terrorists and criminals exploit the new opportunities that open up as technology develops, technologists must work with Governments to ensure thoughtful custodianship of data, and sensitivity towards legitimate privacy.
2014-12-01
89 reads
Your Best Work
Interviewing people is hard to do well. Steve Jones talks about a technique that might help you better choose good employees for your organization.
2014-12-01
141 reads
How Often Does Production Drift?
Database drift is the difference between two database schemas. Today Steve Jones discusses the concept and wonders how often it happens.
2014-11-24
146 reads
2014-11-24
167 reads
Real World T-SQL Tricks
This week Steve Jones wonders if you're taking advantage of the changes in the T-SQL language.
2014-11-21
717 reads
Achievement Unlocked: Balance 0
Steve Jones completed a task this year that he's rarely completed in the past.
2014-11-20
115 reads
The SQL Server Container
There's an interesting idea that exists for lightweight, application separation on a host that's different from virtualization. It's Docker, and Steve Jones talks about it today.
2014-11-19
264 reads
MY Data
As we gather more and more data about individuals, not only does security become an issue, but also the morality of using the data.
2019-01-08 (first published: 2014-11-18)
147 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
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