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 ...

I'm only a programmer by necessity (unix sysadmin). Far more of my time is spent taking apart other people's code than putting things together from scratch. This is nice as far as seeing how others do ...

When you insert new records into an SQL database, you may run into issues where you accidentally overwrite records that are already present due to a duplication issue. You can use a simple alteration ...

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So as ...