Forum Replies Created

Viewing 15 posts - 76 through 90 (of 1,353 total)

  • Reply To: Disappearing posts

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

  • Reply To: Migrating Cubes from SQL 2008 to SQL 2016 issues

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

  • Reply To: Restore DB

    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...

  • Reply To: Dimension property : OrderBy Key

    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...

  • Reply To: Is it a good practice to mix surrogate and natural keys?

    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...

  • Reply To: Design Fact Table for survey

    test

  • Reply To: Design Fact Table for survey

    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...

  • Reply To: Design Fact Table for survey

    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...

  • Reply To: Design Fact Table for survey

    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...

  • RE: trimming SSNs

    Jeff Moden - Wednesday, March 20, 2019 7:01 AM

    RonKyle - Wednesday, March 20, 2019 6:45 AM

    March 20, 2019 at 7:26 am

    #2025012

  • RE: trimming SSNs

    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...

  • RE: trimming SSNs

    ScottPletcher - Tuesday, March 19, 2019 2:23 PM

    RonKyle - Tuesday, March 19, 2019 1:30 PM

  • RE: trimming SSNs

    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.

  • RE: Building Better Stored Procedures

    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...

  • RE: Building Better Stored Procedures

    I'm assuming you're also only talking about the starting BEGIN and ending END around the whole procedure.

    Yes.  I certainly use the combination as part of portions of...

Viewing 15 posts - 76 through 90 (of 1,353 total)