Yukon Induced Insomnia
Since I bought my http://www.selectcomfort.com - it's hard to really describe the friggin difference. I really can't describe it. About 4 weeks ago I was telling one of my co-workers that I was really lucky we have such flexible schedules b/c if I actually had to be at work at 8:00, I'd be in a lot of trouble b/c I wasn't getting to be until 4:30 and sometimes 5:30. I'd sleep right through my alarm. I had the Chinese disease [dragon a33] at work and was pretty miserable. Then came my Select comfort bed. The hype is sooooooooo real about them, I really can't describe it. Now, I never sleep past 6:00 and if I try, I get ancy by 7:00 and can't take it any more. Normally I'm up and energized by 5:30 which rocks. So tonight it's an exception.... I started getting ready for my notification services presentation and just got carried away. I started doing something really really naughty with Web Services. Both EDC and Sonny came out of their clocks to egg me on. Well, my better side got to me and I got back into notification services. That was at 11:30. Seems like Insomnia is back and live,although this time It's welcomed b/c I could go to be at any second. Anyway, I got this really cool idea. I could create a program that wakes up and sends a message so my notification sees it. Then I could tell myself to go to sleep in case I was up late and should have been a sleep. Then it dawned on my - why not just use MessageBox.Show(“Go to F~cking sleep already Bill“); but that would of course be too easy.
Right now, I'm having some trouble getting my SqlDependency's to work, but Art Bell is on on the background and some lady is calling in claiming to be from another Universe - she claims there were 500 other universes. Kind of funny that there's a nice round number. Do you remember the joke T-Shirt “Define Universe, Give 3 examples”. Guess the lady never got the joke.
I don't want to steal my own thunder for next week, but to set up Notifications here's essentially what you need:
CREATE DATABASE CuckooGO
USE CuckooGOCREATE MESSAGE TYPE [CuckooRequest] VALIDATION = NONE
CREATE MESSAGE TYPE [CuckooResponse] VALIDATION = NONE
CREATE CONTRACT [CuckooContract]( [CuckooRequest] SENT BY initiator,
[CuckooResponse] SENT BY target)
CREATE QUEUE [CuckooTargetQueue]
CREATE QUEUE [CuckooInitiatorQueue]
CREATE SERVICE [CuckooRequestService] ON QUEUE [CuckooTargetQueue]( [CuckooContract] )
CREATE SERVICE [CuckooResponseService] ON QUEUE [CuckooInitiatorQueue]GO
USE Cuckoo
GO
SET NOCOUNT ON
DECLARE @Conversation UNIQUEIDENTIFIER
BEGIN TRANSACTION
BEGIN DIALOG @ConversationFROM SERVICE [CuckooResponseService]TO SERVICE 'CuckooRequestService'
ON CONTRACT [CuckooContract]WITH ENCRYPTION = OFF, LIFETIME = 400;
SEND ON CONVERSATION @Conversation MESSAGE TYPE [CuckooRequest] (N'Create the Web Service Bill, you know you want to...')
COMMIT
Probably a good point to call it a night.