Data

A lot of organisations approach backups the wrong way round. They decide they need backups, they put backups in place,..

OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that..

Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some..

Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL..