Use this batch file to automatically backup a database on one instance of SQL Server and restore it on a different instance of SQL Server.

My SQL Server migration philosophy consists of two priorities: (1) Avoid disasters and (2) Minimize production downtime.

Here's the Select Case statement I use to convert common Access field default calculations--Now(), Date(), etc.--to their SQL Server equivalents.

The SQL Server equivalent of an Access Yes/No field is the "bit" data type. Or is it?