Product Marketing Manager for DPP

• 
  Hello James,
  
  I'm starting a GDPR and data compliance quest.
  
  Eduardo Piairo
  

  eduardopiairo November 30, 2017 00:21

  - 0 +
• 
  Hello Eduardo,
  
  Thanks for replying and for the email!
  
  James

  James_Murtagh November 30, 2017 08:35

  - 0 +
• 
  Hi James. Good luck in your new role. A couple of my friends (Business Analysts) were given vague remits to try and track down sensitive data as part of fact finding mission for GDPR. One of your rivals had a really good free tool to get them started, Idera SQL Column Search. Its not as complete as what you were looking at with SQL Atlas but it was simple enough for them to use with their fairly limited database experience. cheers, Ben

  ben_b November 30, 2017 10:39

  - 0 +
• 
  Hi Ben,
  
  Thanks for the good wishes, and for the info - I'll check out Idera SQL Column Search. Do you know how they progressed the project?
  
  Cheers, James

  James_Murtagh November 30, 2017 16:43

  - 0 +
• 
  I'm not too sure how the projects progressed to be honest. All of these projects seem to be driven using a top down approach originating at board level and the tasks I mentioned earlier were just part of the 'discovery' phase. What I am seeing from a lot of companies in this industry (London market insurance) is that GDPR working groups are not really involving BI teams (who probably understand the data flows pretty well) but are currently concentrating on generating lots of Policy Procedural Documents and readiness assessments.
  
  My current company are about to enter what they call the 'remediation phase' so hopefully we will start seeing some concrete steps. These sort of tools will definitely come into play although I do think a massive house-keeping exercise first will really simplify everything (deleting/rationalising applications, servers, databases, reports, file-servers etc.)
  
  I personally like wetherspoons approach
  
  http://www.wired.co.uk/article/wetherspoons-email-database-gdpr
  

  ben_b December 01, 2017 15:25

  - 0 +
• 
  Thanks again Ben - the Wetherspoons approach is interesting, i wonder how many others will do this in the lead up to the deadline?!

  James_Murtagh December 05, 2017 10:59

  - 0 +
• 
  I think a lot of companies will be dropping GDPR-exposed data from their systems.

  TheSQLGuru January 10, 2018 14:41

  - 0 +
• 
  https://blogs.technet.microsoft.com/dataplatforminsider/2018/02/20/whats-new-in-ssms-17-5-data-discovery-and-classification/
  
  I just saw this and thought it may be of interest if you haven't already seen it - similar to the free idera offering but looks better at first glance.

  ben_b March 05, 2018 14:52

  - 0 +
• 
  Thanks for sharing Ben, we've been looking at this too. When you get a chance to use the new discovery and classification features further it'd be great to hear your views.

  James_Murtagh March 06, 2018 09:26

  - 0 +

Add comment

Please sign in to leave a comment.