Not blogging yet? Around 1.5 years back, I wrote a post about what i call Slumdog Blogging, and I think you should read it. I learned a few things during my blogging journey and reading around which I would like to share today. Choose your seat and stick to it. I started blogging in late 2011 on URL: jsinh.in. At the time of starting I never thought of other things I might like to do with the domain. In few years I decided to put out a page or two where I can meta-link to well-known sites where I can be found. This was with the intention to give "More information" links to people who are interested in what I do or I don't. This would be about me and more direct, blogging content and articles is about what I write or wrote and shared with » Read more

 Jsinh        

Once you have your PostgreSQL database server installed, up and running, due to security reasons by default remote access to connect with your database instance is disabled. If you try connecting with your PostgreSQL database server from client machine, you will encounter error. could not connect to server: Connection refused (0x0000274D/10061) Following screenshot displays error I received when trying to connect from a windows client machine using pgAdmin III Following below steps you will be able to enabled remote access to PostgreSQL database server. Before even we start it is important to know that there are two configuration files (and others) which control how your database server works. This configuration files contains settings that needs to be tweaked or changed to make your database instance run as per your needs. postgresql.conf (Used to set various parameters that affect the database) pg_hba.conf (Used to control client authentication, » Read more

 Jsinh        

Ok so you know the blah blah of how PostgreSQL is awesome relation database (RDBMS) and great for reliable transactions, good for so many things, lots of enterprise features and gives concurrency without read locks and stuffs. If you are not aware of this RDBMS, then I would recommend you search for advantages of using PostgreSQL and what is served in its plate. PostgreSQL is pronounced mostly as "post gray sequel" or "post ge are ee as que el" (I am sounding very dramatic here). Back to the post now, Fire up your Ubuntu 14.04 to start the installation. It would almost follow the same for most of the Ubuntu flavors out there. First step - you know the drill :) sudo apt-get update Next step: sudo apt-get install postgresql postgresql-contrib postgresql installs the core PostgreSQL engine and RDBMS around which everything else is build. The » Read more

 Jsinh        

Recently one of my family member ran into trouble when trying to fill an admission form online. As part of this form filling process, we had to upload scanned copies of previous study's merit sheet. We got it scanned but the scans where big in size. One of the scan image was around 2.5 MB. The online form filling site only allowed maximum 900 KB of file size to be uploaded. The way to compress or reduce size of an image is using Microsoft Office Picture Manager. This program / feature is part of Microsoft Office 2010 and prior editions. For some reason this program is been discontinued and is not part of later versions of Office packages. You can download this as part of Microsoft SharePoint Designer 2010. As an example I have a minions-party.jpg file which around 1.35 MB on disk. While installing Microsoft SharePoint Designer » Read more

 Jsinh        

I guest most of us are using cloud storage for taking backup of our precious data. No you say? Then my friend you will be in big trouble soon and you will repent for this act. I have lost few of my precious data in past because of this mistake and from that day I have never skipped taking backup of my data every week. Local hard disk can fail anytime, no one can give any gaureentee for that for sure. Anything stored on cloud is fail safe and secure unless you decide to share it to public. One thumb rule you should follow for all your important data is always backup your data at least at three different place. Primary storage where you keep it and access it daily or easily available. Take a backup to a local detachable - portable drive or something. This is your local quickly » Read more

 Jsinh