Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: Masking Data

    CAGreensfelder (4/28/2009)


    HIPAA = Health Insurance Portability Accountabilbity Act of 1996

    Under "Wrongful Disclosure of Individually Identifiable Health Information," Section 1177 states that a person who knowingly discloses individually identifiable health information...

  • RE: Masking Data

    Almost every place I have worked:

    - production data is not allowed outside of the production environment

    - pre-production test environment is regarded as a live environment

    - other test enviroments - dev,...

  • RE: A Tale of Broken BI

    "Acceleration, for example, is the time it takes to reach a particular speed, which in turn is the distance that would be covered in that time interval if the car...

  • RE: Dealing with custom date formats in T-SQL

    No mention of ISO date formats?

    If the discussion is around how to present locale-specific date formats I would understand, but when converting dates an international standard must be one of...

  • RE: ETL Magic with SSIS – Part II

    Wot no error flows?

  • RE: Dynamically create and populate staging tables from CSV files

    Jeff Moden (1/10/2012)


    Stan,

    Nice step-by-step article with some timely graphics to show how to do things. Although it wasn't specifically named as such, I believe that folks will come to...

  • RE: Dynamically create and populate staging tables from CSV files

    A great little technique but I would probably only use this kind of thing for an initial Proof of Concept. Rarely would you want to (or be allowed to) create...

  • RE: Formatting Dates with 3 Character Months (SQL Spackle)

    Interesting article. Mal-formed dates are the bane of my professional life; often this goes hand-in-hand with Excel data and/or lack of user discipline and validation.

    I've experienced date-related issues whilst working...

  • RE: Enforcing Data Quality while using Surrogate Keys

    It's an interesting take on surrogate keys.

    I've designed a few data warehouses over the years and I've not really regarded duplicity as a problem, rather inherent in the data, if...

Viewing 9 posts - 1 through 9 (of 9 total)