783
Chapter 30: Confi guring and Managing SQL Server with PowerShell
30
■ (^) The SSIS folder enables you to see the SSIS PackageStore. This feature works only
with SSIS 2012.
■ (^) SQLAS enables you to traverse any SSAS instances you may want to connect to.
■ XEvent enables you to see your Extended Events.
■ (^) The SQLPolicy folder provides access to policy-based management using the DMF
and Facets DLLs.
■ (^) The DataCollection folder enables access to the Data Collector objects provided with
the Management Data Warehouse feature of SQL Server 2008 and above.
■ (^) Utility enables you to connect to Utility Control Point.
■ DAC. The authors have nothing good to say about this product.
You can browse the SQLSERVER fi le system just like a disk fi le system. Issuing the com-
mand cd SQL (or Set-Location SQL) and running the Get-ChildItem cmdlet returns
the local server and any other servers that may have been recently accessed from the
PowerShell session. Changing to the local server and running Get-ChildItem returns
the names of the SQL Server instances installed on that server. Changing to one of the
instances and running Get-ChildItem returns the collections of objects available to that
server, such as BackupDevices, Databases, Logins, and so on. Changing to the Databases
collection and running Get-ChildItem returns the list of user databases, along with some
of the database properties. The results look something like Figure 30-1.
FIGURE 30-1
Navigating the SQL Server fi le system.
c30.indd 783c30.indd 783 7/31/2012 9:46:22 AM7/31/2012 9:46:22 AM
http://www.it-ebooks.info