Powershell – Useful Resources

Apr 1, 2010 | Powershell, Scipts, Scripts | 0 comments

One of my aims at the start of the year was to improve my Powershell and scripting skills. I run a few Google searches looking for resources and had plenty of results returned, but finding the ‘wheat from the chaff’ proved difficult. So I turned to twitter and asked...

Scheduling backups in SQL Server Express

Mar 29, 2010 | Backup, Scipts, Scripts | 0 comments

I have seen many forum posts asking how do you schedule backups for SQL Express databases and the answers always have similar responses that go something like: “There is no SQL agent in Express…the only way to backup databases on a schedule is to write a script and...

Managing Your Backup Files

Mar 23, 2010 | Backup, Scipts, SQL Server 2005 | 0 comments

I recently posted a couple of  scripts that backup all databases on your SQL Server instance to disk with a date and time stamp, so you know from the file name when it was taken and hopefully helps you identify how useful those backup are to you. The second...