I'm sure you'll pass me. I am down to about 150 posts a month, too busy with other stuff and most questions are being handled.

Rafael A. Colon (11/8/2011)

---

Hi Steve:

This is so true that I shared the editorial with my whole IT Department, I will resume your entire article in these phrase: Fast never beat...

Lowell is correct. A view is nothing more than a query. If someone wants data refreshed, you need to move the data in the underlying tables.

It's not clear what you mean. Would the view in test not be more recent and the one you want to work with?

To move a view, you just compile the...

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...