If you want to change selection, open document below and click on "Move attachment"
Documenting SQL Server with PowerShell - Simple Talk odule that I built to gather the required SQL Server metrics, and ExcelPSLib, a PowerShell module avaible on CodePlex, for exporting our data to Excel. Let’s take a brief look at each, in turn. <span>PSSQLLIB: Custom PowerShell Functions to Return Server Information I’d rather program for a few hours than do anything twice, so I created a PowerShell module called PSSQLLib that has all the functions necessary to retrieve the following information: Host hard disk information Host hardware Host operating system information SQL Server instance settings SQL Server instance configuration settings SQL Server login server privileges SQL Server databases SQL Server database files SQL Server database users SQL Server database user privileges SQL Server Agent jobs SQL Server disk latencies Load-Assembly Before you can use SMO you have to load it into your environment so PSSQLLIB contains a function called “Load-Assembly” that if supplied the assembly name will load SMO, a
Summary
status
not learned
measured difficulty
37% [default]
last interval [days]
repetition number in this series
0
memorised on
scheduled repetition
scheduled repetition interval
last repetition or drill
Details
No repetitions
Discussion
Do you want to join discussion? Click here to log in or create user.