Configure MSSQL database mail

MSSQL 2005 Enterprise or Standard versions provide mail feature integrated in the database, so that one can send bulk [:)] emails from the database.

Step 1
One should enable Database mail on the server, before setting up the Database Mail profile and accounts. Either can be done by using Transact SQL to enable Database Mail or the second method to use a GUI.
In the SQL Server Management Studio 2005, run the following statement.

use master
go
sp_configure 'show advanced options',1
go
reconfigure with override
go
sp_configure 'Database Mail XPs',1
--go
--sp_configure 'SQL Mail XPs',0
go
reconfigure
go

OR

















Step 2
One can enable the Configuration Component Database account by using the sysmail_add_account procedure.
You’d execute the below query.

EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'TestMailAccount',
@description = 'Mail account for Database Mail',
@email_address = 'tanmaya@mydomain.com',
@display_name = 'MyAccount',
@username='tanmaya@mydomain.com',
@password='1qwe432',
@mailserver_name = 'mail.mydomain.com'

Step 3
Now one should create a Mail profile.
You’d execute the below query.

EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'TestMailProfile',
@description = 'Profile needed for database mail'

Step 4
Next will be the sysmail_add_profileaccount procedure, to include the Database Mail account which is created in step 2, along with the Database Mail profile in step 3.
You’d execute the below query.

EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'TestMailProfile',
@account_name = 'TestMailAccount',
@sequence_number = 1

Step 5
You’d execute the below query.

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'TestMailProfile',
@principal_name = 'public',
@is_default = 1 ;

Step 6
After all these settings done, try to send a test mail from MSSQL Server.
You’d execute the below query.

declare @body1 varchar(100)
set @body1 = 'Server :'+@@servername+ ' Test DB Email '
EXEC msdb.dbo.sp_send_dbmail @recipients='tanmaya@mydomain.com',
@subject = 'Test',
@body = @body1,
@body_format = 'HTML' ;

Step 7
You’d configure the Database Mail profile and its account using MSSQL Server Management Studio by right click Database Mail > Configuration.





































Step 8
You can review the logs linked to Database Mail.
You’d execute the below query.

SELECT * FROM msdb.dbo.sysmail_event_log

Vipassana : Indian Meditation Technique

विपस्सना (पाली) or विपस्याना means approaching into the impermanent nature, or अनिच्का, of mind and body विपस्सना is one of India's most ancient techniques of meditation, skilled to गौतम बुद्ध It is a way of self-transformation through self-observation and introspection। In English, विपस्सना meditation is referred to simply as "insight consideration"

In a broader sense, विपस्सना has been used as one of two poles for the categorization of types of Buddhist meditation, the other being समथा(पाली) is a focusing, pacifying and calming meditation, common to many traditions in the world, especially योगा. It is used as training for विपस्सना, pacifying the mind and intensification the concentration in order to allow the work of insight. This is also sometimes discussed as "stopping and seeing." While समथा can peaceful the mind, only insight can reveal how the mind was uneasy to start with, which leads to प्रग्न्या (wisdom) and ग्याना (knowledge) and thus accepting, preventing it from being uneasy again।

The term is also used to refer to the Buddhist विपस्सना movement (modeled after थेरावदा Buddhism meditation practices), which employs विपस्सना meditation as its primary techniques and places emphasis on the teachings of the सतिपठाना सुत्ता। The primary initial subject of investigation in that style of meditation is sensation and feeling (वेदना)

विपस्सना is a पाली word from the संस्कृत prefix "vi-" and verbal root √paś. It is regularly translated as "insight" or "clear-seeing," though, the "in-" prefix may be misleading; "vi" in Indo-Aryan languages is corresponding to the Latin "dis." The "vi" in विपस्सना may then mean to see apart, or discern. Instead, the "vi" can function as an intensive, and thus विपस्सना may mean "seeing deeply". In any case, this is used metaphorically for a particularly powerful mental self-perception.

A synonym for "विपस्सना" is पच्काक्खा, "before the eyes," which refers to direct experiential observation. Thus, the type of seeing denoted by "विपस्सना" is that of direct observation, as opposed to facts derived from analysis or argument.

विपस्सना [in Tibetian language lhagthong] means in English as "superior seeing", "great vision" or "supreme wisdom." This may be interpreted as a "superior manner of seeing, and also as "seeing that which the essential nature is". Its nature is lucidity, clarity of mind.

Four Foundations of Mindfulness highlighted in the सतिपत्थाना सुत्ता; namely: काया (body or breath), वेदना (emotion or sensation), सित्ता (psyche), and धम्मा(mind objects). These phenomena differ from the खान्द्हस (aggregates) because the सित्ता factor is not connected to any aggregate, as it is the basic mood of the mind-body aggregate, while the धम्मा encompasses all mind objects that are fruits of कम्मा (i.e., the विन्नाना, सन्ना and संखारा aggregates), and also all mind objects that are not a fruit of कम्मा, such as the Four Noble Truths.

Large Hadron Collider

Physicists start experiment to recreate Cosmic phenomenon in hope of finding How Universe began...

After 14 years and $8 billion, scientists at the European Center for Nuclear Research [CERN], outside Genava, succeeded in turning on the most powerful microscope ever built for investigating the elemental particles and forces of nature. Early on Wednesday (09102008) morning, the protons made their first circuit around a 17 mile long long racetrack known as the Large Hadron Collider, 300 feet underneath the Swiss French border, and then made a return journey.

Lyn Evans is the Project Director, an ocean and half a continent away from Geneva, several dozen physicists, journalists, students and just plain citizens gathered here at the Fermi National Accelerator Laboratory outside Chicago, to watch the dawn of a new generation in high energy physics, applauding each milestone of the night as the scientists at CERN slowly wrestled the beam into shape.

The collider is designed to accelerate protons to energies of 7 trillion electron volts and then smash them together, recreating conditions in the primordial fireball only a trillionth of a second after the big bang. The only thing physicists agree on is that they don't know what will happen - what laws prevail - under those conditions.

Many physicists hope to materialize a hypothetical particle called the Higgs boson, which according to theory endows other particles with mass, or identify the nature of the mysterious invisible dark matter that makes up 25 percent of the universe and provides the scaffolding for galaxies. Some dream of revealing new dimensions of space-time.

But those discoveries are in the future. If the new collider is a car, then what physicists did on Wednesday was turn on engine, that will now sit and warm up for a couple of months before anybody drives it anywhere. The first meaningful collisions, at an energy of 5 trillion electron volts, will not happen until late fall.

NYT NEWS SERVICE