It strikes me as somewhat amusing to see someone post a question, which is obviously not a "help me fix this" but is instead a "help me understand why this,"...

I...

margo.taylor (9/19/2013)

---

I am new to the SQL world. My problem is that there are just too many choices. How do I know where to start? I have had no formal...

TravisDBA (9/19/2013)

---

There is merit to what you say, but the hard cold reality today is most HR departments require the piece(s) of paper (college degrees, etc.) for technical positions. You...

Thanks for the suggestions, and I'm still working on this. I did come up with something to give a very quick-and-dirty overview of the tables / columns / datatypes...

Ron, that may do some good. One question on the report, does it only go back to the last time the SQL Server service was restarted? I'm presuming...

Oops. I was (partially) confusing server side traces with Profiler Traces...

With this particular trace and the rules, no. The goal behind it is if something needs to be investigated later, we're able to dig into the trace files.

Between the...

Where I work has similar requirements, and actually provides the script to create the trace. Downside is, they write the trace to disk and default it to 1GB files...

Another option for preventing connections to the DB so you can restore in peace, would be to set it to offline, rather than single_user or restricted_user.

See this topic:

"What can I...

I'm using the following WMI to trigger alerts based on disk free space (the size is set per disk):

select * from __instancemodificationevent within 1 where targetinstance isa 'CIM_LogicalDisk' and targetinstance.freespace...

I would almost say, in that situation, if you've got the disk space, it might be easiest to do the following:

1. Backup the TLog

2. Shrink it down as...

Steve Jones - SSC Editor (9/16/2013)

---

jasona.work (9/16/2013)

---

...

When people say "cloud" most automatically think of the big commercial offerings (Azure, Amazon, etc.) But it doesn't have to be. It...

GilaMonster (9/16/2013)

---

jasona.work (9/16/2013)

---

Right up until I...

For myself, I've been using a "personal" cloud at home (a couple Hyper-V Servers, load whatever OS and application I feel like playing with / learning) and find it to...