Log Buffer #334, A Carnival of the Vanities for DBAs

Posted in: Technical Track

This Log Buffer Edition starts with an awesome post by Dana Pylayeva from Rakuten LinkShare, a long term Pythian client, about her deep and insightful reflections about security. And as usual, it also brings together all the sparkling gems of Oracle, SQL Server, and MySQL. Enjoy!


Alberto illustrates the algorithm used by Oracle (in to fast refresh a materialized view (MV) containing only the SUM aggregate function.

Tim Hall writes about Oracle 12c Multitenant Option : CDBs and PDBs.

Tanel Poder blogs about Scalar Subqueries in Oracle SQL WHERE clauses.

Here, you can see SQL joins visualized in a surprising way.

If you want to create a CDB without the help of dbca, the “generate scripts” option is the right approach.

SQL Server:

This is just a quick post to summarize the Power BI-related information that has come to light over the last few weeks.

Dinesh Asanka lists five myths about Big Data.

This short posts shows some of the functions available to you for FileTables and FILESTREAMING.

When monitoring SSIS package execution, it is common to record the execution times of SSIS tasks. However, this will only give insight into how long a task takes to complete and not the workload.

One of the most buzzed-about topics of 2013, Big Data, gets a lot more interesting when we see how it intersects with the SQL arena.


If you have thread_concurrency, innodb_additional_mem_pool_size, or innodb_use_sys_malloc in one of your my.cnf or my.ini files, please remove it at your next opportunity unless an unlikely exception applies.

This blog post contains a simple INFORMATION_SCHEMA statement that will identify and verify tables that have no rows.

The MySQL Utilities Team is pleased to announce the latest GA release of MySQL Utilities.

Tungsten-Replicator 2.1.1 is out and provides better installation and built-in security.

MySQL Connector/Net 6.6.6, a new version of the all-managed .NET driver for MySQL, has been released.



Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *