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

With each new release, SQL Server gets easier to manage. That doesn’t mean the product is growing simpler, however. To make upgrading a compelling prospect, Microsoft naturally introduces new features ...

While data warehouses and cloud-native architectures have grown rapidly, business users are still finding it difficult to reach enterprise data. Even as dashboards and query tools become easier to use ...

Create easier data connections in Power Apps with virtual tables Your email has been sent Low code isn’t new. For decades, business users have turned to Microsoft Access databases and Microsoft Excel ...