PowerGUI – Powershell SQL Server Database Information Script Node

This short script will prompt you for the name or IP of the server you wish to connect to. As long as you have the correct rights to that server you can use this script. Hope this helps Fernando!

[System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.SMO’) | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.VisualBasic’) | Out-Null
$name = [Microsoft.VisualBasic.Interaction]::Inputbox(“Enter the IP or Name of the server:”)
$server = New-Object(‘Microsoft.SqlServer.Management.Smo.Server’) $name
$server.Databases | format-table Name,Size,RecoveryModel,PrimaryFilePath -AutoSize

If you found this useful, subscribe.

Advertisements

Silent Install of Firefox 3.6

So if you are like me, I had trouble figuring out how to do a silent install of Firefox. This is how you do it:
Go to Run & type %temp%
Run the setup file that was downloaded from firefox.com, wait for the files to extract.
Once the files are extracted, look for a folder at the end of the list.
In the folder there should be a file named setup.exe, in its properties you will see that it is the Firefox installer.
Copy the contents of the folder to your scripting directory.
You can then run setup.exe -ms to run the silent install.
Have a great day!