ALL POSTS

Pythian at Oracle OpenWorld 2014

Calling all Pythian fans, clients, and partners! It’s that time of year again with Oracle OpenWorld 2014 fast approaching! Pythian is excited to be participating once again with our rockstar team of experts in all things Oracle including Database 12c, Oracle Applications (EBS, GoldenGate) and engineered systems, MySQL, and more. We are thrilled to have…

Fixing Windows RAC Listener to Listen On IP Address of Hostname

Recently, there was an issue after a node was added to an existing Windows RAC cluster. After everything was set up, the local listener was not listening to the IP address (192.168.0.37) corresponding to the node’s hostname. Oracle version was 11.2.0.4. The listener.ora was configured properly with the following line: LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by…

Loose Coupling and Discovery of Services With Consul — Part 1

Today I would like to demonstrate the use of Consul to help achieve loose coupling and discovery of services, two important principles of service-oriented architecture (SOA) present in modern, elastic infrastructures. If you have ever designed an architecture to be deployed in a cloud computing environment, then you are probably already familiar with the idea…

Data Profile: Better Knowing Your Data

Have you ever needed to start a new data analysis project or create a report for the business users querying a database you never worked before? Or simply know the data distribution of a database to create better indexing strategies? Working as a consultant, I constantly face this challenge where I have to work with…

Oracle Database: Script to Purge aud$ Table Using dbms_audit_mgmt Package

With an increase in requirements on database security, database auditing is part of most production databases nowadays. The growth on Oracle database audit table”‘aud$” always add spice on a DBA’s life. Since this table growth directly impacts the database performance, this table got special place on every DBA’s heart. Traditionally we follow many methods to purge…

Azure Storage: Creating, Maintaining, and Deleting SQL Server Backups

This post covers how to create, monitor, maintain, and automatically delete SQL Server backups. What is Azure Storage and why should you use it? Microsoft Windows Azure is Microsoft’s cloud offering for offsite storage. It offers the ability to seamlessly enable massive storage, Virtual Servers, SQL Server database instances, and many other options without having…

Page 5 of 257« First...34567...102030...Last »