How to Clean Sensitive Data from SQL Server Dump Files
2
votes
0
answers
638
views
**How do I clean a SQL Server dump file of confidential/PII/PHI information so I can prepare it for third party analysis?** What am I looking for in the dump files and are there any automated tools to obfuscate things? I have looked on Microsoft and other sites but the information is focused on how to diagnose SQL dumps rather than what is actually contained within.
In the most recent release of SSMS they have the "SQL Server Diagnostics (Preview)" (https://blogs.msdn.microsoft.com/sql_server_team/sql-server-diagnostics-preview/) which offers to "Analyze Dumps - Customers using this extension will be able to debug and self-resolve memory dump issues".
I'd like to utilize this new tool but confidentiality is paramount, hence the question.
Asked by DBADon
(325 rep)
Aug 1, 2017, 06:20 PM