Re: best way to scrub data

Hassan,

I've seen a post lately from Martin Bell on the topic you need pointing to
this nice article:
http://www.windowsitpro.com/Article/ArticleID/25876/25876.html.

--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender. This message does not imply endorsement from Solid Quality Learning,
and it does not represent the point of view of Solid Quality Learning or any
other person, company or institution mentioned in this message

"Hassan" <Hassan@xxxxxxxxxxx> wrote in message
news:OcpN4QbGGHA.208@xxxxxxxxxxxxxxxxxxxxxxx
> We are not allowed to restore databases to the test environments that have
> sensitive data like user info ,credit card info,etc..
>
> Whats the best way to scrub this data that can be automated as opposed to
> deleting these values ? Just want to hash them ..
>


.

Relevant Pages

  • Re: clearing concept
    ... and Extents" chapter. ... >> Dejan Sarka, SQL Server MVP ... >> Solid Quality Learning ...
    (microsoft.public.sqlserver.clients)
  • Re: Change sql agent login user
    ... Dejan Sarka, SQL Server MVP ... Solid Quality Learning ... "shivi" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: predetermine size of differential
    ... You can try with the undocumented DBCC PAGE command - see ... Dejan Sarka, SQL Server MVP ... Solid Quality Learning ...
    (microsoft.public.sqlserver.server)
  • Re: how to order by string data type that is actually numeric?
    ... Dejan Sarka, SQL Server MVP ... Solid Quality Learning ... "Bobby" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Abfrage aus 2 Tabellen
    ... SQL ServerT 2005 T-SQL Querying ... by Itzik Ben-Gan - (Solid Quality Learning), Lubor Kollar, Dejan Sarka ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)