jcrawf02 (9/20/2012)

John/Bob, while not an expert, I would have to say no, they are...

(my XML is rusty and I need to brush up, so excuse the lack of detail in the reply).

At this level it appears that way, but when you get into...

Very Nice Article, a great introduction to covering the concept and touching all the bases!

Hey Peter really enjoyed the article, nice job.

Hey Jeremiah Thanks for some additional reading, looking forward to diving into it!

Hmmm between Bill, Travis, and myself I'm sensing a trend 🙂 Keypass is indeed a wonderful thing.

Nice editorial Steve! The last 2 places that I have worked with large production systems, internal company accounts were all Windows AD accounts.

The lone exception, 3rd party vendors software. ...

I haven't found a better option, but this article sums it up pretty good. Basically you will need to re-create the table import the old data, drop the old...

No need to worry, everything is fine, just the page verify option setting.

If you right Click on your Database go to properties, go to Options, scroll down to Recovery (option...

Sorry about that guys,This is my first Published Question, I'll make sure to write in a Check All that Apply next time!

Thanks Mohammed! 😀

Yep you'll have to roll your own.

Central Management Server, Policy Based Management, works great with versions below 2008, Management Datawarehouse is 2008 on up.

Arron Nelson has a great powershell script...

It changes the set of rules that the Optimizer uses to validate your queries and to create execution plans.

Here is the MSDN take

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

It is a Myth that functionality is reduced,...

Good question, I'm suprised there are so many wrong answers.

TDE is a Physical Data Encryption on Disk. The Data is not encrypted in memory when the pages are read...

Since they will be a manager don't forget that aspect as well.

How do you learn?

Are you active in/or have you ever participated in User Groups?

How do you encourage others to...

Loving The questions Steve, knew it was >2, but the last option made me read after the fact. Always fun to learn something new!