MS SQL Server 2008 Database mail configuration

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

Import data from csv file into MySQL table

Syntex can be run from MySQL Query Browser:

LOAD DATA LOCAL INFILE 'c:/a.csv' INTO TABLE neighborhood_boundary_Data fields terminated by ',' lines terminated by '\r\n' (neighborhoodid, lat, lon, zz, mm, state, county, city, name, regionid);

[Fields Terminated by ',']: This will be the character used in the CSV file for separating the data
[Lines Terminated by '\r\n']: I put \r to eliminate the enter key

With this particualr table I had an issue, the neighborhoodid field was having duplicate entries (in a MySQL one field with type integer is required to make it a index field) so when I was importing the data it was getting stuck when the value for neighborhoodID field was repeating, so I created an extra field in the table RecID with type integer and was indexed field and did not included that field in the list of fields in the Load data command and it worked.

Adding Webpart from Add a web part does not shows it on the page

http://office.microsoft.com/en-us/sharepointserver/HA011605831033.aspx

# On the page that you want to edit, click Edit Page in the Actions list.
# At the top of the page in the shared view, click Modify Shared Page to modify the shared view.

To add Web Parts to your personal view without affecting the view of other users, click Modify My Page from the personal view.

Note The text for the link at the top of the page changes depending upon whether you are looking at the shared view or the personal view.
# Point to Add Web Parts.
# To add a Web Part from an existing Web Part library, click Browse.

The page opens in design mode, and the Add Web Parts pane appears.
# In the Add Web Parts pane, click the library you want to browse.
# In the Web Part List, find the Web Part you want. Click Next to view more Web Parts.
# To find the Web Part you want without browsing through all of the Web Part libraries, click Search after pointing to Add Web Parts.
# In the Search text box that appears in the Add Web Parts pane, type a word describing the Web Part for which you are looking, and then click Go.

A list of Web Parts matching the search appears in the Add Web Parts pane.

How to change password policy in Membership API

How to enforce strong passwords using membership You can strengthen user password requirements by configuring the attributes minRequiredPasswordLength, minRequiredNonAlphanumericCharacters, and passwordStrengthRegularExpression on your membership provider configuration.

If you are using the SqlMembershipProvider, the default password strength is set to a minimum password length of 7 characters with at least one non-alphanumeric character.

If you are using the ActiveDirectoryMembershipProvider with Active Directory, your domain password policy is used by default, although you can further strengthen password policy by overriding this with your membership configuration by using the attributes listed earlier.

Similarly, if you are using ActiveDirectoryMembershipProvider with ADAM, your local password policy is used, although you can override this with your membership configuration.
=========================

By default membership provider in .net has a password policy that restricts you to have passwords of length 7 (at least) and one character among those 7 must be Alph-Numeric. There are various conditions that you want to overlook this policy. Following are the ways:

Using minimum length and non-alphanumeric character (replace curly bracket with <>)

(membership ...)
(providers)
(add minRequiredPasswordLength=5 minRequiredNonalphanumericCharacters=0 /)
(/providers)
(/membership)

A good article on understanding advanced properties of Membership: http://4guysfromrolla.com/articles/052009-1.aspx

VSTS 2008 could not find Source safe plug-in

Download and install this:

"http://www.microsoft.com/downloads/details.aspx?familyid=0ED12659-3D41-4420-BBB0-A46E51BFCA86&displaylang=en"

http://social.msdn.microsoft.com/Forums/en-US/vssourcecontrol/thread/50ec5dfa-4e6b-4a43-9b19-733eac4a72cd

IIS not serving index.php as default page

Create a web.config file in your application directory

Paste this in the web.config, reset IIS and it works

configuration
system.webServer
defaultDocument
files
add value="index.php" /
/files
/defaultDocument
/system.webServer
/configuration

http://www.ozzu.com/programming-forum/tutorial-how-install-php-and-mysql-iis-t56303.html