DATA step views are very versatile because they can harness the power of SAS DATA step processing, including DO loops and IF-THEN-ELSE statements. DATA step views do not have write capability, that is ...

There are lots of ways to create MSSQL databases via PowerShell. We could invoke a T-SQL query using the CREATE DATABASE term, we could write some code to use the [Create() method with SMO] or, if ...

A Version 6 PROC SQL Pass-Through view does not need to be updated to be used in Version 7 or Version 8. The conversion of PROC SQL Pass-Through views is automatic and does not require you to use the ...

We have a need to have a view be able to reference columns in another database on another MS SQL 2000 server. Is that going to require linked servers, or is there another syntax or facility? Thanks!

I'm using bcp to dump large quantities of data into a table that has several indexed views built on top of it. It seems to work fine for a while, but on ...

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