Tuesday, February 13, 2007

1,000,000,000,000 is a big number

Chip can do a trillion calculations a second

Intel, the world's largest semiconductor maker, has created a test processor capable of performing a trillion calculations a second, billing the thumbnail-sized chip as the first of its kind.

Ten years ago, the same task would have required 10,000 processors in a 186 sq m computer room, said Intel chief technical officer Justin Rattner.

The device, which isn't for sale, would help Intel test new technologies destined for its mainstream processors in the next five years, Rattner said.

The new chip featured 20 times the processors built into current production models, the type of leap needed to speed technological improvements.

The chip might help Intel play a part in developing products such as cars that know when there's a pedestrian in the road and stop automatically, Rattner said. The test chip has 80 cores.

Code Warning - SQL 2005 mail

-- Create a Database Mail account

EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'Infinity Public Account',
@description = 'Mail account for use by all database users.',
@email_address = 'db_users@Infinity.co.nz',
@replyto_address = 'Andrew.Dixon@Infinity.co.nz',
@display_name = 'Infinity Automated Mailer',
@mailserver_name = 'SMTP.Infinity.Co.NZ' ;

-- Create a Database Mail profile

EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'Infinity Public Profile',
@description = 'Profile used for administrative mail.' ;

-- Add the account to the profile

EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'Infinity Public Profile',
@account_name = 'Infinity Public Account',
@sequence_number = 1 ;

-- Grant access to the profile to all users in the msdb database

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'Infinity Public Profile',
@principal_name = 'public',
@is_default = 1 ;

-- Send the mail

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Infinity Public Profile'
, @recipients = 'Andrew.Dixon@Infinity.co.nz'
, @body = 'The stored procedure finished successfully.'
, @subject = 'Automated Success Message'
, @Query = "SELECT * FROM Customers"
, @attach_query_result_as_file = 1
, @query_attachment_filename = 'Customers.txt'

-- Check the mail

select * from sysmail_faileditems
select * from sysmail_sentitems
select * from sysmail_unsentitems

Monday, February 12, 2007


Have you ever needed a builder, plumber or mechanic and not known where to look?

Sooner or later everyone needs assistance from a skilled tradesperson. But how do you find the right person? You could search the phone book, a newspaper or the internet, but there's really no way of knowing who you can trust. If you're like most you'll call the folks with the nicest-looking advertisement, cross your fingers and hope for the best. Will they show up on time? Will they do a good job? Will they be honest with you? Will they charge fairly?

The truth is, you have no way of knowing. Unless you have a personal recommendation, it's impossible to tell how reliable, honest or fair any tradesperson might be.