That can be a lot to ask of a DBA.  It's not inherent in the job description.  On the other hand, I began a journey from being a DBA to...

I'm posting something as I've had the same issue.  I reported it.  I just want to see if I can post again.

What's the issue?  I can't use that number to access the original post.

I found that striping the database backup significantly improved both the backup and restore times.  That is the multiple files that is referred to in the article, but doesn't provide...

It's whatever you designated as the key in the source.  If you scroll down to the bottom of the properties menu you are in, you will see it.  In the...

I use natural keys when available, and sometimes they are available.  Assigning numbers to states when OH will always mean Ohio makes perfect sense.  And in this case it often...

test

I'm not sure my posts are getting through. I can't see them. But on one resubmission, I received a warning saying I'd already posted one with the same...

Agreed.

Regarding the brand dimension, what you likely really need is an...

I'm not positive, but a Brand dimension doesn't really work here. I've done survey data in a DW before. I had an answer dimension. Depending on how...

I read something that asymmetric encryption was resource intensive and that the recommended solution is symmetric encryption with the key encrypted using asymmetric encryption.  Any comment?

Regarding "salt", if...

For all of you advocating encryption, how do you stored SSNs?  Fortunately I don't deal with data requiring this level of protection, but I'm curious how you do it.

I like to practice "defensive" programming and so I want the system to fail if I accidentally hit "execute".
Just having CREATE prevents this accidentally replacing the original version...