Recover database encrypted modules code with dbatools

• Cláudio Silva

  SSC Eights!

  Points: 886

  More actions

  August 18, 2020 at 12:00 am

  #3778320

  Comments posted to this topic are about the item Recover database encrypted modules code with dbatools

• Eirikur Eiriksson

  SSC Guru

  Points: 182593

  More actions

  August 18, 2020 at 9:57 am

  #3781213

  Thank you Cláudio for sharing this, keep up the good work.

  😎

   

• Jeff Moden

  SSC Guru

  Points: 999090

  More actions

  August 18, 2020 at 2:02 pm

  #3781275

  Agreed... thanks for sharing this.

  As a bit of a sidebar, there have been many cool hacks to decrypt encrypted code in SQL Server since very shortly after the method came out.  I'll never understand why people even bother with the encryption because it won't even stop a rank neophyte if they know how to use a search engine.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
  "Change is inevitable... change for the better is not".
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  Intro to Tally Tables and Functions