by Robert Buda | Oct 31, 2019 | Best Practices, Data Dictionary, Oracle DBA, privacy
GDPR is complex, and this post deals with only a small part of the law. GDPR is comprised of 99 Articles, of which three (Articles 15, 16 and 17) deal primarily with a consumer’s right to “be forgotten.” This includes the right to access the data that your business...
by Robert Buda | Jun 1, 2016 | Best Practices, Data Dictionary, Oracle, Oracle DBA
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...
by Robert Buda | Jul 12, 2013 | Data Dictionary, Database, SQL Server
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...