In our JSON data, we have the main array with only one customer to simplify the explanation. So, as you can see we have a main array (root) composed by objects e nested arrays (orders and items), as ...

Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...

Getting good at SQL for interviews can feel like a puzzle. You know the basics, but putting them together in a way that impresses people is another thing entirely. Luckily, there are great tools out ...

A php package to flatten nested json objects and nested arrays. It also allows you to create csv files from the flattened data. The package allows you to select a specific node of the json object or ...

Organizations are using generative AI to stay ahead of the competition, but the real advantage lies in harnessing the power of your own data securely and at scale. One of the most exciting new ...

Is Path of Exile 2 down? Dungeon crawling is the spice of life, but PoE 2's servers crawling to a halt certainly isn't. Troubleshooting network issues is a pain at the best of times, but it's even ...

In our previous article, we discussed handling JSON arrays stored as strings. Today, we are going to dive into a different scenario, working with JSON array data that is stored as an actual array ...

At today's kickoff for Microsoft Ignite, the company announced that SQL Server 2025 is finally coming. No timing was announced for the release, but based on prior versions, I would expect to see a ...

The increasing adoption of AI technologies is presenting new challenges for our customers’ data estate and applications. Most organizations expect to deploy AI workloads across a hybrid mix of cloud, ...

In announcing SQL Server Management Studio (SSMS) 21 Preview 1 this week, Microsoft revealed Copilot AI for the tool is also being previewed, privately. A Copilot for the tool that helps users manage, ...