Without a doubt a pre-requisite for accepting a permanent position with this company is that you will be in charge of database backups and the Sysadmin should be responsible for...

RS also supports SSL.  It is part of the installation process.  Obviously SSL must be intalled on the web server.

If you are not concerned about "dirty reads" you can use the with (nolock) statement or Set Transaction Isolation Level Read Uncommitted on the select statements being run.

I don't think you can prevent the connections, but you could secure the production systems so that the developers do not have alter/create rights for database objects. This would...

You do not have to allow cascading deletes. I cannot think of an instance where I would use cascading deletes based on DRI because of the issues you raise....

What Phil means is that you need to buld a web page for the report that when you click "Submit" calls the reporting services report directly, bypassing the default reporting...

Mark,

From experience a while loop is significantly faster than a cursor.  Much of the performance gain is due to the resources used in building the cursor.  My experience has been...

My infrared vision did not work on the invisible query so I answered incorrectly.

I liked the article as it was concise and gave good tips for where to start.  Is anyone out there using the SQLH2 tool available from MIcrosoft.  I am using...

Have you tried using the with move command when restoring the differential?