Is Air Travel Safe? Yes, air travel remains statistically the safest mode of transportation. In 2024, the global accident rate was 0.80 per million flights, with fatal accidents being extremely rare....
2025-06-13
19 reads
Redgate has been known for many useful tools that are easy to use. We’ve tried to do that in all our point tools. We talk about simplicity all the...
2025-06-13 (first published: 2025-06-06)
284 reads
I can’t believe I’ve been at Redgate long enough to get a third sabbatical. I’ve very lucky to have this job, still enjoy it, and get the benefit. I’ve...
2025-06-13
7 reads
One of the new features in Kubernetes v1.33 is the ability to resize CPU and memory resources for containers online, aka without having to recreate the pod the container...
2025-06-13 (first published: 2025-05-22)
277 reads
Your Cloud Provider is experiencing an outage! Your websites and databases are all down! When local data centers were the primary source...
2025-06-12
2 reads
How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly imposed U.S. tariffs—such as the 26% duty on select Indian exports—don’t directly target India’s IT...
2025-06-12
31 reads
Working with large databases, multi-terabyte in size, I've had clients who have wanted to move to the cloud. However, after testing and...
2025-06-12
1 reads
🌟 Why Microsoft Azure Certifications Are Beneficial for Your Career 🗓️ How to Schedule and Appear for Azure Certification Exams Microsoft Azure Certification Corporate Discounts: How to Save Up...
2025-06-12
59 reads
I’m presenting a free webinar at MSSQLTips.com at Thursday, July 10, 2025 at 6PM UTC (8PM CET or 2PM EDT). The abstract: As you might learn from the abstract,...
2025-06-11
61 reads
I had someone ask me about using triggers to detect changes in their tables. This is a second post looking at triggers, in this case, modifying my trigger to...
2025-06-11
75 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
i have huge table with lot of data and is also wide. i took...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers