SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

In the second part of this series, Brien shows how to import a .CSV file into a PowerShell array, including two methods for zooming in on just the specific data you need and filtering out the rest. In ...

Here's a quick refresher on how JSON files work and how you can use them to configure AWS services. Normally, I like to use my articles on this site to show you how to accomplish various tasks in an ...

Windows PowerShell is probably best-known for its ability to allow Windows admins to operate at scale. For instance, it would take forever to create a thousand user accounts through the GUI, but ...

You don't need to fear imported spreadsheets anymore.

I have zero coding skills, but I was able to quickly assemble camera feeds from around the world into a single view. Here's how I did it—and what it means for all of us. I'm the Executive Editor, ...

Jason Chun is a CNET writer covering a range of topics in tech, home, wellness, finance and streaming services. He is passionate about language and technology, and has been an avid writer/reader of ...