a script to import all database sizes from a list of servers into a table using powershell for trending purposes
YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.
2014-08-29 (first published: 2012-05-23)
Find all storage including mount points and show' free and used available. Needs powershell.
2014-08-25 (first published: 2011-12-15)
works two different ways using sql for 2000 and 2005 and powershell for 2008.
2012-05-23 (first published: 2012-05-01)
Create a c:\servers.txt list of servers. No spaces or it wont work. Then copy the code into a ps1 file and edit the directroyfilename to show where you want the files to end up.
2012-02-17 (first published: 2012-01-23)
Find drive, freespace, usedspace and percent free for all drives and mounted volumes.
2012-02-16 (first published: 2011-12-15)
easy way to migrate DTS packages to another server
2012-02-07 (first published: 2011-12-15)
short script but another way
2012-01-25 (first published: 2011-12-15)
find and replace text in a text file using tsql
2012-01-23 (first published: 2011-12-16)
will create jobs script for backup or DR purposes to install on another server.
2012-01-18 (first published: 2011-12-15)
This script will backup your files that have changed only. old files will not be copied just newer ones.
2012-01-17 (first published: 2011-09-20)