At Pythian, we embody and value diversity in every form—in our religion (or lack thereof), our geography, our culture, and of course the location we’ve chosen for our home. We deeply believe that the best teams are diverse and we are committed to increasing our diversity in all these areas.
If your system meets any of the following criteria:
– Oracle 184.108.40.206.0 or higher
/> – Partitioned tables
/> – Parallel query heavily used
/> – Bind variables in use, as they should be
and, you’re seeing unusually high “cursor: pin S wait on X” waits, then you may want to know that this week, patch 21834574 was released.
When running several different hive instances, we found the process of maintaining/confirming synchronization to be quite time consuming. While several tools made available by Cloudera and other frameworks do provide a visual interface for an individual instance of hive, there was no available tool for comparing across clusters. We came up with a useful way to compare hive schemas between clusters.
Our process contains 3 main steps:
This Log Buffer Edition covers some of the niftiest blog posts from Oracle, SQL Server and MySQL.
Pythian has been closely following the developments in the EU relating to the invalidation of the US-EU Safe Harbor Framework.
On Friday, November 6, 2015, the European Commission issued guidance on the cross-border data transfer issues. This guidance spoke more to “alternative transfer tools” available to legitimize data flows to jurisdictions deemed “not adequate,” like the United States.
If you do transfer data and rely on Safe Harbor principles, we recommend you:
I recently experienced a problem when upgrading an old Oracle 10.2.0.4 database to 220.127.116.11 that had no matches in a My Oracle Support (MOS) or Google search. The problem presented itself initially when upgrading as the following error was reported by the upgrade script:
Recently I have been looking at the href="https://vaultproject.io/" target="_blank">Vault project as a means to manage secrets for applications and end-users. One of the use cases that immediately drew my attention was the ability to create dynamic role-based MySQL credentials.
There are a few reasons why dynamic credentials would be beneficial, all of which can be handled by Vault, including:
Oracle OpenWorld is always an exciting and energizing experience. This year was no different! There are always a big laundry lists of new service offerings and upcoming release information during OpenWorld. This year, the major buzz is Oracle Cloud. Oracle Cloud offerings actually shadowed lot of other imported product updates at OpenWorld.
Fuzzy Search in SQL Server is not done very well. This post will cover how to implement Fuzzy Search capabilities using several approaches.
Fuzzy Search is the process to locate records that are relevant to a search, even when the search criteria doesn’t match. Fuzzy Searches are used to: