Thursday, October 23, 2014

Execute code online

Online compiler and debugging tool which allows you to compile source code and execute it online in more than 60 programming languages.

http://ideone.com/

Monday, October 28, 2013

HTTP Error 503. The service is unavailable.

I started receiving "HTTP Error 503. The service is unavailable" error for localhost after re configuring the default website on local machine.

After some investigation I noticed the Application pool had stopped.

I restarted the Application pool

  • Open the Internet Information Services (IIS 7) Manager
  • Select the Application Pools node under the root node in the left hand side frame.
  • Right Click on the application pool website uses.  If the service is stopped, start it.  If the service is running, restart it.


Ran the website and it gave the "HTTP Error 503. The service is unavailable" error again. Checked the application pool to notice it had stopped automatically.

This turned out to be a custom account issue.
The password for user that application pool was running under was changed some time ago but it kept running until changes were made to the website settings in IIS7.

Reset the identity for the pool and started the application pool.

  • In application pool -> Advanced Settings->Click on Identity->enter username and password when prompted 
  • Restart the Application pool
  • Run the website

That did the trick! Issue resolved!

Thursday, March 14, 2013

Increase Database Mail Size Limit

sp_send_dbmail allows you to send emails with attachments. However by  default, Database Mail limits file attachments to 1 MB per file.

You can configure database mail to allow larger sizes.
Expand the Management tab, right-click on Database Mail,
Click on Configure Database Mail.
Select "View or change system parameters"
"Maximum File Size (Bytes)"  is the option you can change to configure the attachment size.

Friday, March 2, 2012

Websites that can help your business to reach out to local customers

Angies list - Subscription based for consumers, Free for businesses
CitySearch - Free to join, paid upgraded available
Google Places - Free
Yahoo!Local - Free to join , upgrades available.
Yelp - Free to join, upgrades available

Sunday, February 5, 2012

Reference not copied to bin folder when complied in Visual Studio

A reference to third party dll  is not copied to bin folder even when "Copy Local" is set to True.

Make sure project file has following tag in it

<Private>True</Private>

If this does not help try adding a "using" or "import" in your code as dynamically loaded reference could cause this issue.
It seems if you are not using the library directly in the code Visual Studio detects that its not used and does not include in the output.

Sunday, May 15, 2011

Print Excel Worksheet With Comments

Print comments

If your worksheet contains comments, you can print them as they appear on the sheet or at the end of the sheet.
  1. Click the worksheet that contains the comments that you want to print.
  2. To print the comments in place on the worksheet, display them by doing one of the following:
  • To display an individual comment, click the cell that contains the comment, and then on the Review tab, in the Comments group, click Show/Hide Comment.
 Tip   You can also right-click the cell and then click Show/Hide Comments on the shortcut menu.
  • To display all comments, on the Review tab, in the Comments group, click Show All Comments.
Excel Ribbon Image
 Tip   You can move and resize any overlapping comments.

  1. On the Page Layout tab, in the Page Setup group, click the dialog box launcher Button image next to Page Setup.
Excel Ribbon Image
  1. On the Sheet tab, in the Comments box, click As displayed on sheet or At end of sheet.
  2. Click Print.
 Tip   To see how comments are printed, you can click Print Preview before you click Print.

This article is copied from http://office.microsoft.com/en-us/excel-help/print-comments-HP001216408.aspx