Author Archives: deepakmurthy

Table Partitioning – Greenplum and Netezza Differences

Greenplum Data Warehouse Partitioning Table Partitioning in Greenplum Database Greenplum Database divides tables into parts (also known as partitions) to enable massively parallel processing. Tables are partitioned during CREATE TABLE using the PARTITION BY (and optionally the SUBPARTITION BY) clause. … Continue reading

Posted in Uncategorized | Leave a comment

Working with Regex

Cool website where you can play on regex http://www.regexr.com/ Grabbing HTML Tags <TAG\b[^>]*>(.*?)</TAG> matches the opening and closing pair of a specific HTML tag. Anything between the tags is captured into the first backreference. The question mark in the regex … Continue reading

Posted in Uncategorized | Leave a comment

Monit – Cool way to monitor services

Monit is a helpful program that automatically monitors and manages server programs to ensure that they not only stay online consistently, but that the file size, checksum, or permissions are always correct. Additionally monit comes with a basic web interface … Continue reading

Posted in Uncategorized | Leave a comment

Install packages from EPEL (Extra Packages for Enterprise Linux)

What is EPEL EPEL (Extra Packages for Enterprise Linux) is open source and free community based repository project from Fedora team which provides 100% high quality add-on software packages for Linux distribution including RHEL (Red Hat Enterprise Linux), CentOS, and … Continue reading

Posted in Uncategorized | Leave a comment

Splunk LDAP Configuration

LDAP Configuration: First perform ldapsearch to make sure ldap search working so splunk can perform the same: ldapsearch -h xxx.xx.xx.61 -p 389 -D”CN=SVCACC_CDH,OU=ServiceAccounts,DC=prod,DC=wudip,DC=com” -b “DC=prod,DC=dom,DC=com” -W | grep ‘do_group’ Go to Settings–> Access Controls –> Authentication method -> Configure splunk … Continue reading

Posted in Uncategorized | Leave a comment

Writing PostgreSQL Functions in C

Writing PostgreSQL Functions in C Introduction PostgreSQL is a powerhouse in its own right, but it is also extensible. You have a lot of options when it comes to extending PostgreSQL. You can use SQL, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, and … Continue reading

Posted in Uncategorized | Leave a comment

Linux find command with examples

First, create the following sample empty files under your home directory to try some of the find command examples mentioned below. # vim create_sample_files.sh touch MybashProgram.sh touch mycprogram.c touch MyCProgram.c touch Program.c mkdir backup cd backup touch MybashProgram.sh touch mycprogram.c … Continue reading

Posted in Uncategorized | Leave a comment