Infrastructure Archives - Bommarito Consulting

Published On - 2014-05-19

mjbommar Cloud, Consulting, Infrastructure, LawTags: cloud, iaas, paas, saas, state and local tax, tax, taxation

Is there tax in the cloud?

Do you contract for IaaS, PaaS, or SaaS services like Amazon Web Services or SalesForce? Do you provide SaaS services like “cloud-based applications” or “web applications?” What state are you headquartered in? What states are your servers located in? What states are yo...

Published On - 2013-11-14

mjbommar Cloud, Infrastructure, ProgrammingTags: aws, pgbench, postgres, rds

Benchmarking the new AWS Postgres RDS instances

Postgres has finally come to RDS! Want to know how these instances stack up on a naive pgbench test? Below is a table of simple pgbench results taken over a 60 second period. All RDS instances were launched into us-east-1a, and pgbench (9.4devel) was run from an m2.4xlarge in us-east-1a as well...

Published On - 2013-10-29

mjbommar Cloud, Consulting, InfrastructureTags: aws, boto, log, monitor, tunnel, vpc, vpn

Monitoring AWS VPC tunnels

While many Amazon Web Services resources with “state” have CloudWatch sensors available, AWS VPCs and tunnels unfortunately do not. If you’re ever in need of a solution to monitor and log the status of VPC tunnels back to another data center or office, my gist below will be right...

Published On - 2013-10-28

mjbommar Cloud, Consulting, Infrastructure, Programming, ResearchTags: aws, benchmark, cloud, ec2, hi1.4xlarge, hs1.8xlarge, io, oracle, orion

AWS EC2 hs1.8xlarge Oracle ORION benchmark results

Benchmarking I/O with Oracle ORION is an important part of planning, baselining, and performance-tuning Oracle environments. I’ve previously provided ORION results for the hi1.4xlarge SSD-backed instance class, and based on some recent work, I wanted to provide an update for the newer hs1.8x...

Published On - 2012-01-22

mjbommar Consulting, Infrastructure, ProgrammingTags: database, integrity constraint, network, ORA-02292, oracle, OTM

Debugging ORA-02292: integrity constraint (OWNER.CONSTRAINT) violated – child record found

Did you find this post useful? Does your organization need Oracle services? We can help. Working with Oracle databases can be daunting to developers and analysts who lack a deep understanding of relational models and SQL. One excellent example of a mystifying pitfall is the dreaded ORA-0...