Simon Fraser University

Using a Pass-Through Query in a Subquery

Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...
Chris Webb's BI Blog

Power BI, Parallelism And Dependencies Between SQL Queries In DirectQuery Mode

As I described here, Power BI can send SQL queries in parallel in DirectQuery mode and you can see from the Timeline column there is some parallelism happening here – the last two SQL queries ...
Simon Fraser University

Retrieving DBMS Data with a Pass-Through Query

This section describes how to retrieve DBMS data by using the statements and components of the SQL Procedure Pass-Through Facility to access DBMS data. The Pass-Through Facility uses the SAS/ACCESS ...

dbForge 2025.3: AI Assistant in SQL Complete, Expanded Connectivity, and Smarter SQL Workflows

Forge 2025.3 adds AI Assistant to SQL Complete, supports SSMS 22, Visual Studio 2026, MySQL 9.5, MariaDB 12.2, and ...