It is going to depend on your specific requirements.

Do you need all of the data from your OLTP database, or just a portion of the data? Is the structure...

Think of it like physically having a key.

If someone steals your house key, isn't it more secure if they have to steal a second key to get into your office,...

Here are a few things.

1) If someone happens to get the password for one of the services, it is nice if that does not mean they have the password for...

Look at the execution plan. It is going to generate loops for the correlated sub-queries you have. MS SQL is not good at looping and this type of...

- SQL Server includes SSIS - which could be used for this.

- You could create a linked server on your SQL Server to write directly to the access database

- You...

The package source must be a file connection and the file connection must be to the child package location that is within the same solution.

Your developers are wrong. This can be done.

You could either create individual calculated measures or create member calculations similar to how the time intelligence wizard handles "Prior Year" type...

Whatever server login being used must have access to the procedure and the table individually if the procedure is accessing a table in a different database. So, your server...

You either need to give the user access to the objects in both databases, or you need to enable cross-database ownership chaining.

An OLEDB Command component sends rows to the output buffer as they are processed. So, your deletes happen one at a time and then the rows are sent to...

I have had both good an bad experiences with it. Because the bad experiences were things like read/write buffers reporting back incorrectly, I am not comfortable using VMWare for...

Actually, that probably makes your problem even worse. You need to ensure you don't violate constraints that are not actually in the database or you may be producing errors...

Assuming you have foreign key relationships, the top 25 from one table may mean you need every record from another. To add to the issue, you have to add...

There was an article in the newsletter today that may be of use to you.

http://www.mssqltips.com/tip.asp?tip=1584

The import/export wizard is probably going to be less efficient than a backup / restore approach.

Depending on your recovery plan, you probably do not need to do a backup -...