Viewing 15 posts - 31 through 45 (of 1,311 total)
I like the distinction between business key and natural key. Usually I have used the term business key. Sometimes the business key has to be an identity. Employee number seems...
August 12, 2019 at 5:41 pm
I'm a big proponent of using natural keys where they exist. But generally for name tables there is no choice but to use some form of identity. For GDPR purposes...
August 12, 2019 at 1:22 pm
By the way, the time required to acquire these skills is not insignificant. The design rules are very different. It would be a big mistake to apply the normal forms...
July 24, 2019 at 3:36 pm
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...
July 24, 2019 at 12:42 pm
I'm posting something as I've had the same issue. I reported it. I just want to see if I can post again.
June 28, 2019 at 7:29 pm
What's the issue? I can't use that number to access the original post.
June 20, 2019 at 1:32 pm
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...
May 28, 2019 at 3:30 pm
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...
May 6, 2019 at 1:26 pm
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...
April 16, 2019 at 1:33 pm
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...
April 3, 2019 at 12:23 pm
Otherwise this “Fact” table as you have it designed will be very wide with a lot of repeated text values.
Agreed.
Regarding the brand dimension, what you likely really need is an...
April 1, 2019 at 2:17 pm
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...
April 1, 2019 at 1:00 pm
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...
March 20, 2019 at 6:45 am
Viewing 15 posts - 31 through 45 (of 1,311 total)