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.

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

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.

Free software for remote controlling a computer

http://www.teamviewer.com/en/index.aspx

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.

 Tip   You can move and resize any overlapping comments.

3. On the Page Layout tab, in the Page Setup group, click the dialog box launcher next to Page Setup.

4. On the Sheet tab, in the Comments box, click As displayed on sheet or At end of sheet.
5. 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 

Referencing Custom Master Page Properties From Content Pages

To reference master page properties from content pages

• Create a public property in the master page code-behind file
• Add the @ MasterType declaration to the ASPX content page
  <%@ MasterType VirtualPath="~/Site.master" %>
  
• Reference the master page property from content page as
  Master.[property_name]



Connecting to FTP server via IE7 or up

When you try to connect to ftp server via IE 7 or up you may get "Internet Explorer cannot display the webpage" error.

Try steps below to be able to connect FTP via IE.

1.            Start Internet Explorer.

2.            On the Tools menu, click Internet Options.

3.            Click the Advanced tab.

4.            Under Browsing, click the Enable folder view for FTP sites check box.

5.            Click OK.

6.            Close IE

7.            Restart and Test

If above is selected and you get the  page that give “Internet Explorer cannot display the webpage” message,

Click “View”  from top menu of IE. ( If View is not visible click Alt key to make it appear under address bar) 

Click  “Open FTP site in Windows Explorer” menu option,  to open up your ftp folder in windows explorer.