Posts

Pointing GoDaddy domain to an AWS EC2 instance

You just bought a domain on GoDaddy and if you would like to leverage the same with your AWS EC2 instance then just follow these easy steps to make it possible: First setup AWS to provide an IP address for your DNS settings. On EC2 Management console you will have a vertical menu on the left hand side. Under “NETWORK & SECURITY” group click on “Elastic IPs”. On the top menu you will see a blue button “Allocate New Address” click on it. Just be sure “EIP used in” is set to “EC2″ then click “Yes, Allocate”. A new IP address will be created on the table, select it by clicking on the empty square by the left of the name. Now click on “Associate Address” on the pop-up click on instance and select the instance you would like to associate to this IP. Finally click “Associate” and that’s it. For now to access via SSH, FTP, etc. you will need to use the new elastic IP. On the GoDaddy side we will set up the points to address with the new elastic ip. Login into your godaddy ...

Office365 - Set up the device to synchronize with Microsoft Exchange

You can use a mobile phone, tablet, or other supported device to access information in your mailbox. Here is great article from Microsoft to enable this for Office 365 Exchange accounts:  set up the device to synchronize with Microsoft Exchange

Web Sitemap Generator Tools

List of tools that generate or maintain files in the XML Sitemaps format, an open standard defined on  sitemaps.org  and supported by the search engines such as Ask, Google, Microsoft Live Search and Yahoo!. https://code.google.com/p/sitemap-generators/wiki/SitemapGenerators

Android Fix: "Insufficient storage available"

If you have Android phone for few months which is running on version 4.2 or less,  while updating your apps  you might have faced issue of  "Insufficient storage available" . Resolution : Try to clear data from the play store in the application manager.  If that doesn't work, clear it again along with Google services framework.  You need to sign in to your Google account again. But this helps for sure. Enjoy updating apps on android.

Could not load file or assembly 'Microsoft.SharePoint.ApplicationPages'

Recently I received following error on SharePoint: Could not load file or assembly 'Microsoft.SharePoint.ApplicationPages, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. Access is denied. … In the error, we can see that obviously we do not have permission, but who is trying to access the DLL? It is not the Application Pool account, but the Anonymous IIS account.  Simple fix, check to see what account is running in Directory Security, give read permission to that user for the _app_bin folder, and recycle the application pool. Should be fixed. 

Sql Script Generator

During project development you might have come across a situation where you need Insert script along with values from SQL Table. Found a very useful tool  SQL Script Generator   at CodePlex.  SQL Script Generator is a tool for generate INSERT/UPDATE statement SQL script. With SQL Script Generator you can create script to copy data from one database to another.

Shrink LDF file in SQL SERVER 2005

I recently encountered an issue on one of our development box, where SQL log files on C:\ and transaction logs grew to 13GB, on the other hand the DB size is just 29 MB. Used following SQL query to reduce the size of log file to free up the space ALTER DATABASE [DBNAME] SET RECOVERY SIMPLE; GO --Shrink the truncated log file to 1 MB. DBCC SHRINKFILE ( [DBNAME_LOGFILE_NAME] , 1); GO --Reset the database ALTER DATABASE  [DBNAME] SET RECOVERY FULL; GO