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

Although tables in SQL databases typically contain massive amounts of data, they’re not always in a format that can be used by data analysts. The data records in these tables need to be filtered ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

Use SQL to quickly create a new table from existing records in Access Your email has been sent SQL lets you use one command to quickly create a new table containing a subset of records from a larger ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...