Monday, June 08, 2009

Configuring DB Mail to use GMail

Have you configured SQL DB Mail to use GMail to send mails?
This post shows you how to achieve it.
1. Start the SQL Server Management Studio and login as SA.
2. Expand "Management" and right click on Database Mail and click on Configure Database Mail.

3. Select the first radio button and press Next.
If DB Mail service is not started it will prompt you to enable it.4. Put a profile name, then click on Add to configure the SMTP account.5. Click on the New Account, to create the account.
6. You need to put the account name, email address, display name, server name (smtp.gmail.com), port number (587), check the checkbox for Require secure connection (SSL) and select basic authentication as the SMTP authentication method and provide your user name and password.
When all are done press Ok.

7. Now pressing Next will bring you a screen to select the default profile. Select the newly created profile as default and click Next.
8. Using the Configure System Parameters screen you can change the parameters if required. But in this case defaults are perfect. Press Next.
9. Press the Finish button after checking the actions to create the new profile.
10. You can check whether it is properly setup by right clicking on Database Mail and Sending a Test Mail.

Wednesday, June 03, 2009

Bing - But It’s Not Google

Did you check out the new search engine from Microsoft?
If you used to use Live search you may have noted that now you are redirected to Bing, since Bing is replacing Live.
They have named it as BING and its having some few cool new things to look for.
Soon after the launch on 1st June 2009 Bing is getting bit popular at the moment in the context of search engines.
New Explorer Pane
Helps to filter the search results more or to find more related information.
Categorized Search Results
All the results will be categorized accordingly, so you will be able to find the related things easily.
Results Preview
You don't need to open the web site to view its content, Results Preview will show you a preview of the site so you can decide on it faster.
Image Search
You will be able to sort out the results fast according to things such as size, colour, layout, etc.
Video Search
One cool thing is without opening the site you can preview the video being inside of the Bing which will save lot of time.
There are much more it is better you check the rest of the features your self.
Bing
Travel
Maps
Shopping
Health
Local