skip to main
|
skip to sidebar
AI Rumman with the Systems
Facebook
Code Repository
RSS Feed
Pages
Home
Contact Me
Contact Me
Loading...
Subscribe to:
Posts (Atom)
Popular
Category
Recent
Popular Posts
Python Script for Remote Server Connection through SSH2
To make an ssh connection to remote server and scp files from that server through Python script, I used the python package " paramiko &...
Scheduled VACUUM instead of AutoVacuum
Once I found in Postgresql 9.0.1 that one of the report queries was hanged in the DB server while it was perfectly running on the developmen...
Dynamodb restore using datapipeline with newer emr version
We faced an interesting issue here. We had a task to restore dynamodb from backup stored in s3. We took the backup using AWS pipeline. Bu...
Exclude tables during pg_restore
Let we have a database like: postgres=# \c testdb You are now connected to database "testdb" as user "postgres". test...
AWS Athena to read Dynamodb backup data
Our data scientists wanted to read some data from Dynamodb. In order to do this, we had to increase the Read Capacity of the table to a hi...
Baseball Statistics Data Model
A few months ago I was working in a sports portal project. As a database developer, my first task was designing data model for Baseball spor...
Postgresql failover with Pgpool II replication
Postgresql failover with Pgpool II replication can be configured for 24x7 database system where no downtime is allowable. The followings des...
Understanding XID Wrap around
A few days back, I faced a disaster with one of the databases with xid wrap around issue. I started to dig into the details about the actu...
Mysql function to remove non-alphanumeric character from a string
"remove_non_alphanum_char_f" - this function is used remove non-alphanumeric character from a string Input: varchar(255) Output: v...
PowerShell Password-less SSH to Linux
Using Powershell version 3: PS C:\Windows\system32> $PSVersionTable Name Value ---- ...
Labels
Athena
(1)
AWS
(2)
Case Study
(2)
Data Model
(1)
Dynamodb
(2)
Failover
(4)
Linux
(11)
Mysql
(12)
Nagios
(1)
Oracle
(3)
Pgpool
(2)
Postgresql
(51)
PowerShell
(1)
Python
(7)
Query Tune. Wordpress
(1)
Sql
(7)
Sql Server
(3)
Wordpress
(5)
Blog Archive
▼
2017
(1)
▼
January
(1)
AWS Athena to read Dynamodb backup data
►
2016
(1)
►
December
(1)
►
2015
(1)
►
August
(1)
►
2014
(5)
►
September
(1)
►
July
(1)
►
February
(1)
►
January
(2)
►
2013
(15)
►
December
(3)
►
October
(1)
►
September
(1)
►
August
(1)
►
June
(2)
►
March
(2)
►
February
(1)
►
January
(4)
►
2012
(18)
►
December
(4)
►
November
(1)
►
October
(1)
►
July
(2)
►
June
(5)
►
April
(3)
►
February
(2)
►
2011
(22)
►
December
(1)
►
October
(1)
►
August
(1)
►
July
(1)
►
June
(2)
►
April
(1)
►
March
(4)
►
February
(9)
►
January
(2)
►
2010
(17)
►
December
(4)
►
November
(2)
►
October
(11)
Contact us if you have any question or anything else
AI Rumman with the Systems
© 2011
DheTemplate.com
. Supported by
Tips for Life
and
Blogging Tips