Database Blog

• GDPR Right to Be Forgotten and Other Access Rights

  Oct 31, 2019

  Reading Time: 7 minutes To ease compliance with Article 15, 16, and 17 of GDPR, and to support compliance with other GDPR Articles, we recommend the following steps with regard to handling of personal data.

  Read more Add new comment

• Ever Dropped an Oracle Table and Wish You Hadn’t?

  Jun 1, 2016

  Reading Time: 2 minutes If you’ve ever dreamed of going to a recycle bin like you can on Windows, and “undropping” an Oracle database table… Oracle has made your dream come true! Introduced with Oracle 10g, Oracle’s recycle bin works a lot like what you’re used to in Windows. When this feature is enabled (the default setting), dropped tables don’t actually get deleted. Instead, they “land” in the recycle bin and can be restored. The recycle bin is actually…..

  Read more Add new comment

• Using the Data Dictionary to find hidden data in SQL Server

  Jul 12, 2013

  Reading Time: 2 minutes A client asked me recently how he could find a string in his SQL Server database without knowing what table or column it was in. The string was a translation of a code that appeared on one of the UI screens. This was a packaged CRM database and he had no documentation on the schema. With hundreds of tables whose names were not obvious, he had no idea where the translation might be kept, but…..

  Read more Add new comment