Technical How Tos

SATS publishes information on technology cases commonly needed and discussed. These are but snippets of the vast knowledge base SATS has accumulated over the years. Feel free to browse and use. If you need more information or have questions contact SATS or call (650) 889-5533. SATS and its people are not responsible for any errors which may resulted from following the documents published here. All documents are distributed under GNU General Public License terms.

• Practical Oracle Upgrade Guide to Version 12c
• Replacing truncate with partitions rotation in Oracle
• Global database links with Oracle SQL Net
• Taking Oracle database back into manual control mode

• Clone SQL Server database
• Shrink files of SQL Server database

• Speeding up MySQL by using Materialized Views (Sample)

• Materialized Views in Postgres (Sample)