In the world of database architecture, the need to dynamically create complex objects conflicts with the demand for subsecond response time. Oracle's answer to this dilemma is the materialized view.

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...