Thanks for the responses all.

The argument came down to, when should a DBA (operations) need to know about the four databases. Development teams say it should be at the...

Thanks for the reply, unfortunately right now the development groups are creating reports and I am slowly trying to get some control of SSRS. I am just wondering if...

Hello opc.three, I apologize for not replying sooner. I been putting out a lot of fires out.

We have run sp_validatelogins on all our servers and found a few orphan logins,...

Hi SQLKnowItAll, when I say hardcoding, our developers were putting the actual server name for example MyServerName.Database instead of using a DNS alias for a connection string or when writing...

Hi Steve, to answer your question about schema, I want to make sure developers don't use the default dbo schema but a more relevant one for example customer.name sales.leads instead...

Gila, what is the best practice to get TempDB equally the same size? Thanks for your help.

Thanks for the replies.

We are not currently having an I/O issues. I just want to ensure having the data in the files not equal in size will not hinder...

Hello Calvo, what if I restrict the growth for the 3 files, will it start filling the rest of the files? Do you think this will work?

You are right but I still need a product for normal backups with compression and encryption. In a couple of weeks I will try both products out. Looks like...

Thanks for the replies all, first time at forums didn't know what replies I would get.

Let me ask you all this, what about Developer/QA servers. What if you have...

Thanks for the response. I been looking at LiteSpeed from Quest. It has Object level Recovery but I'm sure this is pricey.