BuboFlash - helps with learning

Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.

Presentation
Question

Answer

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

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

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.