JSON Archives - Jonathan Crozier

Working with JSON functions in SQL Server

JSON has become the de facto standard for data interchange and its ubiquity in modern software applications makes the support that SQL Server offers for working with JSON more relevant than ever. Whether you’re developing APIs, dealing with semi-structured data, or storing configuration, the ability to handle JSON natively at the SQL level will help…

Formatting JSON with proper indentation using PowerShell

InScripting

PowerShell is a powerful scripting language that makes working with data a breeze, allowing you to import and export to a variety of common file formats such as CSV, XML, and JSON. However, when it comes to JSON, the formatting applied by the built-in ConvertTo-Json cmdlet leaves a lot to be desired. While this may…

How to paste JSON as Classes in Visual Studio: A hidden gem!

InProgramming Tools

In the increasingly fast-paced world of software development, efficiency is a critical factor for success in the marketplace. Visual Studio, Microsoft’s flagship IDE (Integrated Development Environment), is packed full of features designed to make your programming experience as productive as possible. Among these is a lesser-known feature that is extremely useful; the ability to paste…

Tag: JSON

Working with JSON functions in SQL Server

Formatting JSON with proper indentation using PowerShell

How to paste JSON as Classes in Visual Studio: A hidden gem!

Working with JSON functions in SQL Server

Using AzCopy to transfer a large number of files between Azure Blob Storage Containers

How to output inserted and source IDs when cloning SQL Server table data