Fine, Il bite. In my day to day work as a production DBA a typical day looked like:

-Reiew alerts in monitoring tool, and act upon any that may signal potential...

Bill Talada (7/3/2014)

---

Like a boa constrictor, you just have to keep tightening your grip on it. I've converted hundreds of databases over the years. First I start out...

dan-572483 (7/3/2014)

---

Of course if you're a good DBA, not only will put out the fires, you will put processes in place to prevent fires from occurring, and eventually the late...

Apologies if I offended, Im not saying BI guys dont work...

I think some may benefit from Thomas Kejser's fantastic blog explaining when to use a Heap vs Clustered index.

http://kejser.org/clustered-indexes-vs-heaps

To try to distill it down to a few points ( probably...

Ignore me and my laziness. I tested this and the Virtual File Stats do not follow a database after its restored.

Update:

There was windows patching of the VM occurring at the time of the issue. The Virtual Disk Service was flickering between stopped and started. I "guess" this could cause an...

Perry Whittle (5/7/2014)

---

Do you understand the ramifications of the below??

winston Smith (5/7/2014)

---

Repair: Deleted off-row data column with ID 562825134080, for object ID 1076927654, index ID 1, partition ID 72057594039566336, alloc...

There was windows security patching performed, and an unexpected shutdown.

Unexpected shutdown is worrying, but i assumed SQL can handle these by...

Yep, thats the crux of the post, i want to resolve this...

crap, typo, meant to say the MDM front end. ive updated the original post.

Joie Andrew (4/23/2014)

---

Don't think that will work. The instances involved in mirroring need to be able to tell each other apart. Plus if you use a monitoring server how would...

Spot on Greg, granfathering has allowed us to continue using Server+Cal.

Jeff Moden (1/20/2014)

---

smitty-1088185 (1/20/2014)

---

There is so many variables to your question I'm not sure where to start. How do you know it's SQL verses some other process?

How much available...

Login trigger wont work.

If a user logs on but then changes database context to another database, a login trigger wont capture that.

I need the most recent time a database was...