In the fast-paced world of IT, Database Administrators (DBAs) are the unsung heroes who ensure that data flows securely, efficiently, and reliably. But what if we viewed database environments not just...
2025-07-23
15 reads
PostgreSQL 17 introduces a new era of innovation in open-source database technology. This release focuses on performance, scalability, developer productivity, and enterprise-grade reliability. Each feature in PostgreSQL 17 is...
2025-07-21
1,040 reads
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that has evolved over decades. It is known for its reliability, feature richness, and strong community...
2025-07-17
104 reads
In today’s data-driven world, organizations rely on skilled professionals to design, build, and maintain scalable data solutions. The DP-203: Data Engineering on Microsoft Azure certification is your ticket to...
2025-07-16
110 reads
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up your first cloud environment is a valuable skill, and you can begin without spending any...
2025-07-15
34 reads
What is Artificial Intelligence? Understanding Predictive vs. Generative AI Artificial Intelligence (AI) is transforming how we live, work, and interact with technology. From personalized recommendations to AI-generated art, the...
2025-07-14 (first published: 2025-06-23)
399 reads
The internet relies on IP (Internet Protocol) addresses to identify devices and route traffic. Two versions of IP exist today: IPv4 and IPv6. While IPv6 was introduced to overcome...
2025-07-14
49 reads
🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT and Agile In the realm of IT operations and software development, not all tasks are...
2025-07-10
31 reads
As data becomes the backbone of modern business, understanding how to manage and analyze it in the cloud is a must-have skill. The DP-900: Microsoft Azure Data Fundamentals certification...
2025-07-09 (first published: 2025-06-22)
317 reads
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that has evolved over decades. It is known for its reliability, feature richness, and strong community...
2025-07-08
81 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Comments posted to this topic are about the item Creating JSON III
Comments posted to this topic are about the item Testing is Becoming More Important
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers