Ever used Google Maps to find the fastest route home? That's geospatial data in action, turning physical locations into digital info so you can navigate efficiently. Spatial databases take...
2024-09-16 (first published: 2024-08-27)
314 reads
Many organizations do not have in-house DBAs. This can be due to a number of reasons. Most commonly it is smaller organizations that cannot justify a full time DBA....
2024-09-16
10 reads
fensiveness – n. a knee-jerk territorial reaction when a friend displays a casual interest in one of your obsessions. I think that some of us have some fensiveness about...
2024-09-13
20 reads
One of the single biggest reasons to go with a Platform as a Service (PaaS) offering like AWS RDS are the things it does for you, like making it...
2024-09-13 (first published: 2024-08-26)
111 reads
I originally planned this post just as an answer to DBA Stack Overflow question: How can I get the list of tables in all the stored procedure? After preparing...
2024-09-13 (first published: 2024-08-26)
266 reads
Make it easier for your audience to engage with you by connecting your site to the fediverse.
2024-09-13
16 reads
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in the Databases module where an unprintable ASCII character was being inserted at the beginning of...
2024-09-12
46 reads
As part of my job, I needed to research how a few things work with Synapse and Fabric. The latter includes the former, mostly. I decided to setup a...
2024-09-11 (first published: 2024-08-26)
149 reads
Are you ready to have conversations with your data? Announced in public preview within Microsoft Fabric is AI Skill, a new capability in Fabric that allows you to build...
2024-09-11 (first published: 2024-08-26)
360 reads
With my new laptop, one of the things I realized I’d forgotten to do in setup is reserve some space. I wrote about this years ago, but I wanted...
2024-09-11
23 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
India’s Leading Testing Laboratory FARE Labs Pvt. Ltd. offers precise OTR and WVTR testing...
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
This is a generic question. To the moderators, I wasn't sure where to place...
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers