A frequent question that I have received from many DBAs is: my undo tablespace is almost full, how can I be sure that the space will be reused?
Well, First you have to know that there are two kind of...
Data preparation (data prep) is the thought given to how stored data in any system will be utilized by the target audience. Data availability presents some interesting challenges.
This blog identifi...
While the SQL standard allows multiple NULLS in a unique column, and that is how Postgres behaves, some database systems (e.g. MS_SQL) allow only a single NULL in such cases. Users migrating from othe...