This Log Buffer edition covers Oracle, SQL Server and MySQL blog posts from all over the blogosphere!
Oracle:
Hey DBAs: You know you can install and run Oracle Database 12c on different platforms, but if you install it on an Oracle Solaris 11 zone, you can take additional advantages.
Here is a video with Oracle VP of Global Hardware Systems Harish Venkat talking with Aaron De Los Reyes, Deputy Director at Cognizant about his company’s explosive growth & how they managed business functions, applications, and supporting infrastructure for success.
Oracle Unified Directory is an all-in-one directory solution with storage, proxy, synchronization and virtualization capabilities. While unifying the approach, it provides all the services required for high-performance enterprise and carrier-grade environments. Oracle Unified Directory ensures scalability to billions of entries. It is designed for ease of installation, elastic deployments, enterprise manageability, and effective monitoring.
Understanding Flash: Summary – NAND Flash Is A Royal Pain In The …
Extracting Oracle data & Generating JSON data file using ROracle.
SQL Server:
It is no good doing some or most of the aspects of SQL Server security right. You have to get them all right, because any effective penetration of your security is likely to spell disaster. If you fail in any of the ways that Robert Sheldon lists and describes, then you can’t assume that your data is secure, and things are likely to go horribly wrong.
How does a column store index compare to a (traditional )row store index with regards to performance?
Learn how to use the TOP clause in conjunction with the UPDATE, INSERT and DELETE statements.
Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns?
Tim Smith blogs as how to measure a behavioral streak with SQL Server, an important skill for determining ROI and extrapolating trends.
Pilip Horan lets us know as How to run SSIS Project as a SQL Job.
MySQL:
Encryption is important component of secure environments. While being intangible, property security doesn’t get enough attention when it comes to describing various systems. “Encryption support” is often the most of details what you can get asking how secure the system is. Other important details are often omitted, but the devil in details as we know. In this post I will describe how we secure backup copies in TwinDB.
The fsfreeze command, is used to suspend and resume access to a file system. This allows consistent snapshots to be taken of the filesystem. fsfreeze supports Ext3/4, ReiserFS, JFS and XFS.
Shinguz: Controlling worldwide manufacturing plants with MySQL.
MySQL 5.7.7 was recently released (it is the latest MySQL 5.7, and is the first “RC” or “Release Candidate” release of 5.7), and is available for download
Upgrading Directly From MySQL 5.0 to 5.6 With mysqldump.
One of the cool new features in 5.7 Release Candidate is Multi Source Replication.
Learn more about Pythian’s expertise in Oracle , SQL Server and MySQL.
No comments