Database Mail Architecture

There are four components to the Database mail Architecture
(These will be on exam 70-431) :

• configuration components
  database mail account - contains the smtp information you have entered for the server (I use my normal email account to play around with)
  database mail profile - a generic name you choose for other applications to handle email routing. "use profile that I called 'main' "... "I want to use the 'my alternate' email profile"...

• messaging components
  this is the host database that holds all teh objects. (hint-hint: host database is is msdb).


• 
  

• executable adn logging & auditing components

enable database mail

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO

---
to keep an eye on the emails going in and out, what is failing, try these (found at databasdsournal.com)

sysmail_allitems – This view allows you to return a record set that contains one row for each email message processed by Database mail.

sysmail_event_log – This view returns a row for each Windows or SQL Server error message returned when Database Mail tries to process an email message.

sysmail_faileditems – This view returns one record for each email message that has a status of failed.

sysmail_mailattachments – This view contains one row for each attachment sent

sysmail_sentitems – This view contains one record for every successfully email sent

sysmail_unsentitems – This view contains one record for every email that is currently in the queue to be sent, or is in the process of being sent.
-------
to clean up messages:
sysmail_delete_mailitems_sp – This SP permanently deletes email messages from the msdb internal Database Mail tables

sysmail_delete_log_sp - This SP deletes Database Mail log messages

Excel: Find last row in a spreadsheet

Sub xlCellTypeLastCell_Example_Row()
Dim LastRow As Long
With ActiveSheet
LastRow = .Range("A1").SpecialCells(xlCellTypeLastCell).Row
End With
MsgBox LastRow
End Sub

The Pygmalion Effect

The Pygmalion Effect

aka:Self Fulfilling Prophecy , The Rosenthal Effect

Praise with vision goes a long way.

People tend to live up to what's expected of them and they tend to do better
when treated as if they are capable of success.

These are the lessons of The Pygmalion Effect.

Pygmalion first appeared in Greek mythology as a king of
Cyprus who carved and then fell in love with a statue of a woman, which
Aphrodite brought to life as Galatea.

Much later, George Barnard Shaw wrote a play, entitiled Pygmalion, about Henry Higgins (the gentleman) and Lisa Doolittle (the cockney flower girl whom Henry turns bets he can turn into a lady).

So the Pygmalion Effect has come to mean "you get what you expect." If you expect disaster, your expectations may well be met in a kind of "self-fulfilling prophecy," yet another catch phrase about the pressure of expectations.

from :
http://www.envisionsoftware.com/articles/Pygmalion_Effect.html

Big Oven Recipe software

The only user-data files that BigOven uses are the ones in the "My BigOven Recipes" folder. The application itself installs to c:Program FilesLakefront SoftwareBigOven.

---
Make a copy of the recipe and shopping list data. Locate your "My BigOven Recipes" folder, and check the "last modified" dates to make sure you've got the most recent ones. You can search for the files named "*.crb" to locate them easily. Usually, they are either under your "My Documents" folder or your "Shared Documents" folder. If you've updated multiple times, you may have a couple copies -- you can check the "last modified" date in Windows Explorer to make sure you have the most recent set.


Make a copy of the recipe and shopping list data. Locate your "My BigOven Recipes" folder, and check the "last modified" dates to make sure you've got the most recent ones. You can search for the files named "*.crb" to locate them easily. Usually, they are either under your "My Documents" folder or your "Shared Documents" folder. If you've updated multiple times, you may have a couple copies -- you can check the "last modified" date in Windows Explorer to make sure you have the most recent set.

for detailed instructions, you can go to http://www.bigoven.com/cs/forums/t/1665.aspx

confirm pop up in javascript

if (confirm('Are you sure?')==false) return false;

hit the easy button!!

SSRS: What Reports do you have out there?

list all the reports you have on your server:

use ReportServer


select ds.name as datasourcename ,
ct.name as itemname ,
ct.path
from dbo.catalog ct (with nolock)
inner join dbo.datasource ds
on ct.itemid = ds.itemid
where type = 2
order by datasourcename ,
itemname