Persisted Datasets and SQL

If extracting data from complex JSON structures is slowing down your queries, or if you find yourself hunting through multiple files just to update a single Group Type ID, you are likely facing a maintenance bottleneck.

This video demonstrates two powerful, field-tested strategies for leveraging Persisted Datasets directly within SQL to solve these problems. You will learn how to "pivot" cached JSON data into high-performance, tabular results using OPENJSON, and discover the "Rigging Pattern"—a design strategy developed at Triumph to centralize your configuration settings. Whether you are building complex reports or simply trying to keep your code clean, you will leave with a technique that makes your SQL faster and your maintenance easier.