Jack Corbett (12/29/2010)

---

Hey, did you know that SSC is now a dating site? Here's a PM I got from lord.god90:

Hello My New Friend.

Good Day and How are you today.

Please...

ankur_libra (12/29/2010)

---

Hi All,

The similar case is with one of our clients which are using the Symantec Backup Exec 12.5. They have also purchased SQL Agent license from MS. Now...

Since SQL Server is turned off, yes, those backup files are useful. They can be used to reattach a database in the event of a disaster. Now, you won't have...

check sys.dm_exec_sessions to be sure you're seeing all connections. sys.dm_exec_requests only shows active connections.

Ha! You'd get a few, for...

Brandie Tarvin (12/29/2010)

---

Okay. WIT 24 hours of PASS is accepting abstracts for March. I'm assuming this is Pre-Rally 24 hours of PASS (haven't had a chance to double-check the dates)....

Apologies. I think that might have sounded more argumentative than I meant for it to.

I agree. There are a number of ways to skin this particular cat. None of them...

If it's all for a single application, I'd go with schema's to seperate out storage, access, security. This way you can have referential integrity across the schema's as needed, something...

For the absolute best PowerShell training, I recommend tracking down Don Jones and seeing when he's offering a class in your area. His training is excellent.

I'm not sure what the problem might be, but why are you taking a differential backup at one minute intervals, but only backing up the log once an hour. It...

I think the error you're getting is "fallback certificate initialization failed"

I've never heard of this error myself, but it seems that it's not uncommon[/url]. It may have something to do...

If you want to capture performance counters in TSQL, instead of using extended calls, which can be very problematic, and require different security settings that might not be all that...

2005 or above, I'd go to sys.dm_exec_requests to see which processes are running slow, which ones have wait states, which ones are blocked. You can combine it with sys.dm_exec_sessions to...

Agreed with Pradeep. However, the best way to be sure the backup is valid is to have tested it against another server in an actual restore. For some of our...

You can use Profiler to capture statement starts, but if a statement errors out, Profiler doesn't catch that completion event because it didn't fire. I agree with everyone else. I'd...