This Log Buffer browses through Oracle, SQL Server and MySQL spaces and brings forth some of the useful blog posts for this week.
Oracle:
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
SQL Server:
Amazon Web Services (AWS) : Relational Database Services (RDS) for SQL Server
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
MySQL:
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!
No comments