Conner throws it out of the park. As we all (hopefully) know, we should always deploy named program units (procedures/functions) within packages. Its a great method of encapsulation of logic.
Pythian’s Gleb talks about Azure on RAC. Microsoft Azure provides an acceptable and affordable platform for a training environment.
There are some performance improvements that require physical storage options to be set on tables or indexes. One particular technique that I will take as an example for this article is index compression.
To call Oracle Reports from Oracle Forms application, the most secure approach is to use the RUN_REPORT_OBJECT built-in.
Introducing Asset Physical Inventory with PeopleSoft Asset Tracking
SSIS: Case sensitivity may expose issues with change deployment
Foreign Key Indexes and Binding
In SQL Server 2016 we have new compression functions to compress and uncompress specific data.
Database Continuous Integration
VividCortex is all about optimizing your queries. Many of our users asked us to analyse their queries, searching for common errors and mistakes.
RocksDB vs the world for loading Linkbench tables
Measuring Docker IO overhead
MariaDB 5.5.48 and Connector/J 1.3.5 now available
EXPLAIN FORMAT=JSON: buffer_result is not hidden!
Interested in working with Fahd? Schedule a tech call.