Hit and miss, and this one was short. We have some long ones coming at times.

It's a...

I'm not sure, but you might specify which version to which version. Also, I would think many reports would move fine if this is a single version change.

Wow. I'll see if I can bump this to a few people to see if that's occuring on other systems.

+1

Good luck.

MS licensing can only give you an (non-legal) interpretation, which Jared mentioned. However their reading of the EULA for your case, could be legally binding either way.

Nice script, but I'd argue this isn't using T-SQL. It's using a shell command, which isn't allowed in many places.

Interesting concern. AFAIK, the sparse file doesn't actually allocate the space until it's needed, so while it might report 25GB as a size, it isn't using that space.

Fragmentation? Interesting, I...

Robert Davis (2/15/2012)

---

for example, if someone tells me that they didn't prepare at all, that they just walked in and took all of the Pro level exams, then I...

The only way to do this is if you have a way of marking what new data is. Perhaps some column that marks when things have changed.

There are plenty of people using braindumps, plenty that memorize some things, and plenty that use their knowledge.

A certification isn't worthless. You use the interview to determine if someone actually...

Koen Verbeeck (2/15/2012)

---

If it was an interview question, I sincerely hope for him he didn't pick choice 2...

Go here: http://mslicense.com/

Short answer: contact MS. Ultimately they have the final say since they can sue you for non-compliance.

Longer answer: My reading, and understanding, would be that accessing SQL Server through any...

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

Be sure you publish the times of the restores. I assume you'll automate this, which will mean killing connections, so I'd test the restore times of logs, then allow a...