Calculating Uptime when support window isn't 24/7In some corporates there are permissible down time windows, i.e. in the evenings or weekends or both. And then public holidays need to be factored in as well. You want to work out the number of work seconds between two dates and then use this as your total to divide your actual uptime into.

Content:Administrative:SQL Server 7.x and later

View Database growth over timeThis script uses the backup size as an indication of the real amount of space used by a database. A database with a 1GB mdf that only has 10MB of data is in fact only 100MB in size. This db may grow by 100MB per month. If the mdf size is used, no growth will be observed for 10 months.

Content:Administrative:SQL Server 7.x and later

View any new databases created on multiple serversThis Powershell script uses the native Provider that comes standard with SQL 2008. From one function I can see any new (created in the last 30 days, for example) databases that are created on any server and the database size. Great for capacity planning and billing!

Removal of User Login from ALL databases and SQL ServerNeed to remove a login\user from SQL server and all databases? This script will look for the id in all the databases and generate a script to remove it from all databases and SQL server.
Input - it the login\user name.
Output - Copy/Paste/Execute