PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting 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 ...

I need some help planning the creation of a view for auding Active Directory User Account Group Membership. I run a script every night that populates three tables. The first table is the usertable ...

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

Specifies the current catalog name. To change it, type a two-level name or ? to list all possible catalogs. Then make a selection from the resulting Select a Member window. Displays the number of ...