Accessing results in a random order: Towards the automated Thank-you letter
Phil shows how 'CROSS APPLY' can be useful for writing thank-you letters or thinking of excuses as to why your project has failed....
Avoid Transact-SQL's Column Alias Limitations
A column alias seems like a great tool for referencing complex expressions, but SQL Server doesn't work that way. Learn a simple workaround.
Handling Service Broker Errors
The previous installment of the 'SQL Server 2005 Express Edition' series discussed using transactions to protect the integrity and consistency of Service Broker-based communication. Depending on the type of issue encountered by our code, the outcome might be different from expected. This article demonstrates a more robust approach to error handling and applies it to our target.
How to create indexes on computed columns in SQL Server
There are certain requirements for creating indexes on computed columns and this tip shows you want needs to be done.
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
SSIS Custom Error Handling
This article from Zach Mattson shows how you can set up custom error handling in your SSIS packages. Learn how to direct those error rows to another component for separate processing.
Using Intersect - SQL School Video
This SQL School video will introduce you to the INTERSECT command in T-SQL. MVP Andy Warren explains how this command allows you to find matching rows in a join and a UNION.
Adding a UI to the Standalone SQL Agent
In a recent blog post, SQL Server expert Denny Cherry discusses adding a user interface to his Standalone SQL Agent, a replacement for the SQL Server Agent service.
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