I used to use VBScript as well. Here is a search on this site of a few scripts that might help: http://www.sqlservercentral.com/search/?q=delete+backups&t=s

You mentioned it, but be sure that you keep...

I'd stick SSIS questions in the Integration Services forum: http://www.sqlservercentral.com/Forums/Forum364-1.aspx

*groan*

It's very hard to tell. Some people want...

Someguy (11/7/2011)

Maybe the power consumption of individual work stations should be considered? One wasted watt spread over 10 million machines adds up. On the other hand, it often adds up...

There is Transparent Data Encryption or column encryption, no database level encryption. Whichever one you choose, you will need to be careful about backing up and managing the encryption keys....

Esp in an article. If you want to write it up, show a scenario and...

Use Gus' advice. You could use a function, but a simple select works just as well. Depends on how you want to encapsulate this for developers.

Ha, as long as we have people, I think security is holds water like a colander.

Can you run a backup manually?

I've done what I think Gail suggests and used a table as a global variable store, or a definition table. You store values in there that are needed in the...

I think he just did :w00t:

Alien ship attacking Beijing skyscraper?

+1 with what JonFox said.

Shared password changes shouldn't be frequent, if they are, then you have other HR issues and security is likely compromised in many ways.

A shared password system (KeePass, Password Safe, etc)...