Ars Technica

Easiest way to move a lot of SQL databases over to new spindles?

I have a SQL 2008 Standard server running on Windows Server 2008. The server hosts hundreds of databases. I just added 2 shiny new and fast mirrored 15,000 RPM SAS drives to the server, which are much ...
dbta

Upcoming Webinar Shows How to Move MV Data to SQL Server using BlueFinity's mv.SSIS

BlueFinity will demonstrate how to create a simple SSIS transformation to move MultiValue data into Microsoft SQL Server using mv.SSIS in a free webinar on Tuesday, January 31. Microsoft SQL Server's ...
Ars Technica

Move a SQL 2000 database from one server to another

What is the best way to do this? File locations will be different on new server.<BR><BR>Should I SP_DETACH_DB the source DB, copy over the .mdf/.ldf files, then SP_ATTACH_DB on destination server with ...
Computerworld

How to fetch a file from FTP and import into SQL Server automatically

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...