Using Views
Views can be a great way to abstract away details for clients, but they can also make development much more flexible.
2014-08-01
333 reads
Editorial
Monitoring for Non Existent Events
Many DBAs monitor for those events they expect to happen, either successfully or failed. However many DBAs wouldn't be aware of an event never occurring.
2018-02-28 (first published: 2014-07-31)
206 reads
Elevation of Privileges
The elevation of privileges is a large security problem and Steve Jones discusses his fears. Would you know if someone successfully attacked your instance?
2018-03-01 (first published: 2014-07-30)
279 reads
2014-07-29
175 reads
Frustration with Bad Design
It can be very easy for technology experts to get frustrated when they see bad design and practices, but you must be careful with how you go about trying to influence change.
2014-07-28
23 reads
Frustration with Bad Design
It can be frustrating to deal with poorly implemented systems, but Steve Jones notes that you can't take things into your own hands.
2014-07-28
301 reads
Summer, Summer, Summertime
This Friday Steve Jones has a poll about your summertime activities. What have you done away from work that was memorable?
2014-07-25
107 reads
2018-03-02 (first published: 2014-07-24)
197 reads
2014-07-23
749 reads
2014-07-22
258 reads
Blogs
Agentic Architect – Future IT Roles (comparison)
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
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...
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