Cloud based multi-site hosting in a single web server

Recently I’ve set up cloud based shared web site system, which is hosting several customers’ web site in a single server. To do that what I’ve chosen stack is as follows; Amazon Web Service EC2 micro instance Windows Server 2012 Softaculous AMPPS WordPress / Joomla Our company uses Amazon Web Service as production server so… Continue reading Cloud based multi-site hosting in a single web server

Open sources for web map and geo location

Here are pure open source based web map and geo location database resources. Google map or Bing map is wonderful, but they require business contract for commercial use. It is said that Foursquare recently switched their map tool from Google map to open source based Leaflet API which looks like the picture below. This map… Continue reading Open sources for web map and geo location

Bulk data import to MSSQL

I was about to upload 2 million record of data using NHibernate’s default save method, which will transact every record independently. It estimated almost 2 days to upload all data. In this mass data upload, bulk import utility, bcp is pretty useful. It takes 10 minutes for 2 million record to import. Related well written article. http://lostechies.com/jimmybogard/2010/06/24/bulk-processing-with-nhibernate/ And… Continue reading Bulk data import to MSSQL

Published
Categorised as DB