PowerShell offers a lightweight and efficient solution for backing up SQL Server Express databases on local workstations without the need for full system backups.

Microsoft's upcoming SQL Server 2005 Express is restricted for use on one processor, up to one gigabyte of addressable RAM and a maximum four-gigabyte database size.

Microsoft Wednesday rolled out SQL Server 2005 Service Pack 1, featuring crucial database-mirroring capabilities left out of the initial launch of the database late last year.

Microsoft will only support SQL Server 2005 running Service Pack 2 on its upcoming Vista and Longhorn server operating systems, a move that an analyst said isn’t surprising, but shouldn’t have ...