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!
Oracle:
Alberto illustrates the algorithm used by Oracle (in 11.2.0.3) 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.
MySQL:
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.
No comments