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?

Sql Agent Mail and SQL Mail are 2 different processes.  SQL Agent Mail does NOT use xp_sendmail.

IN the properties of Sql Server Agent ther is a place to assign the...

If they allow you to install a new instance that only you have control over that would work, but who is then responsible for performance monitoring, backup and reocery, etc... ...