It is hard. I can't quite decide how much to build and how much to integrate. I do like the "custom metrics" in SQL Monitor[/url], which solve some of the...

Thanks, I'll take a look.

SuzSQL (11/14/2012)

---

I still think cloud is super buzzy. Private cloud is the top of buzz. Hosting, distributed processing, cycle sharing, VM....whatever you want to call it have all...

I wish. Not sure we'll see this anytime soon.

A lot of truth here....

Disk is my vote, perhaps striped to multiple physical locations for speed. Then copy over to tape/DR.

The SAN stuff can work, but you better check this carefully. Not all SAN...

Tammy, we don't mark answers as correct. Arguably, you or a person asking a question, doesn't know what is the best way to do things. You can let us know...

This SELECT * wasn't bad, but not as good as last year's. 😛

Bob, great to see you last week, even if it was for 2 min.

A squeaker for sure. I was watching the game last night and kept thinking Bowe would keep dropping them, just to annoy me.

My luck that Bowe won't get me 2 pts tonight. Probably pop a hammy on the first play, where he'll catch a 10 yard pass and leave the game

doesn't work.

http://connect.microsoft.com/SQLServer/feedback/details/333593/allow-activation-of-application-role-in-logon-trigger

My apologies for not checking this out first. I was thinking in text here.

The idea of preventing some users from changing things would be in a DML trigger, not...

You need to read about how Application roles work.

http://msdn.microsoft.com/en-us/library/ms190998.aspx

You would invoke the role for certain people from the login trigger.

You need to be sure more detailed logging is capture from the job. In the job steps, you can capture output to a table.

If this is VBS, you could also...

You could do this. My understanding of Windows Backup in the modern OSes is that it is VSS aware and you get a real SQL backup.

However the problem is granularity....

A login trigger may help you here, but in conjunction with an application role. You might be able to trigger an application role as part of the login trigger, whic...