SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.

How to Restore a SQL Database From a .MDF File. Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure.

Even now, a full workstation backup seems like overkill. As I have recently discovered though, you can use a PowerShell script to back up a SQL Server Express database.

Microsoft offers the tool as part of the Microsoft SQL Server Feature Pack, or you can download just the Provider installation file.