New SQL-NS 2005 Book RRS feed

  • General discussion

  • Folks,

    I want to let everyone know that the 2005 update to my Notification Services book is now available for order. You can get it from http://www.amazon.com/gp/product/0672327791/.

    This book has been completely updated for the 2005 release:

    - All source code examples are now designed to work with the 2005 programming model and tools

    - New chapters have been added to cover the new 2005 features (such as the NMO API, Hostable Execution Engine, and User-Defined Matching Logic)

     I hope you find this useful. As always, I appreciate receiving any feedback you may have.



    Wednesday, February 22, 2006 7:25 PM

All replies

  • Hi Shyam,

    I bought your book, and it's really good book which can tell me more detail.

    Right now I met a problem when I was testing SMTP delivery channel in chapter 10. with local smtp service, the musicStore worked as expected, but if I changed to use another computer in the same domain, nothing happened. Checking the application event view, it said:

    Notification Class Name: NewSong

    Notification Status Info: The e-mail address or SMTP server value is not valid.

    SMTP Server:

    Message Recipients: emily@work.com

    I have tried other setting for SMTPServer in InstanceConfiguration.xml, like "\\myServer", "myServer.myDomain" and "myServer.myDomain.local", but all got the same result. I have checked online book and some forum, but nothing helpful. Could you help it out? Thanks in advance.





    Wednesday, April 19, 2006 2:03 AM
  • HI shyam,

    Just got the book this week and im finding it very useful and helpful.  The std MSDN examples are very short on documentation.  I dont seem to have one issue though, Im currently going through chapter 6 and am finding that the scheduled subscriptions for the Music Store sample are not working.

    Working through the database i can see that my NewSongByGenreSubscriptionProcessingTimes table is not being filled in.  I looked a little deeper into the SQl statements and ran this

     SELECT  subscriptions.SubscriptionId, subscriptions.Created
                FROM    [SongAlerts].[NewSongByGenre] subscriptions

    This unfortunately returns nothing, which looks to be the problem as my chronicle always stays empty.  I've used your tool to add the scheduled subscriptions and unfortunately that does seem to work, its adding subscriptions, so i cant understand why the query above doesnt fire.

    A little deeper and i see the two tables NSCurrentNewSongByGenreSubscriptions  and NSFiringNewSongByGenreInterval  are empty?  dont really know what they do.

    Dont suppose you can test and confirm that Chapter 6 does work correctly.  I've been over it 3 times and am about to get a work mate to try on their machine, but so far no luck.

    Aside from that little niggle, its an excellent book, the chapter on Custom Delivery Channels was worth it alone. :)






    Wednesday, June 14, 2006 3:08 AM

    For those who consider buying this book to prepare for their new project on SQL Server Notification Services, here's what I have to say:

    1. I bought the author's previous book (on SQL NS 2.0 - for SQL Server 2000). Before I got it, I had only a very dim idea about what NS is and what it can do.

    2. Two weeks later, I had a fully functional prototype of my application. It had only a subset of the real huge project's functionality (the project is truly HUGE!..), including a custom content formatter and a custom event provider. But it worked, and we are now just extending it. I mean, no need to refactor the code or start from scratch. Well, to tell you the truth, in those 2 weeks I worked quite a bit more than 8 hours a day, but it was worth it. My boss is still trying to throw some tricky questions on me (like, "What happens with our application IF..."), and there have been no questions so far that I was unable to answer. The book is just great!

    3. My advice to you: work through all the samples (at least, in the first half of the book, or until you get a clear idea on how all the pieces of NS fit together). It's not nearly as bad as it sounds: the explanations and step-by-step instructions on how to do every little thing are so good that even a complete moron would be able to get it (and none of us are morons... I think... ;-)

    4. I usually buy technical books only when I need to get up to speed with a particular technology as fast as possible. Shyam Pather's book exceeded all my expectations. The book reads as easily as my favorite science fiction books (and way easier than "The Lord of the Rings"). And almost as interesting as they are.

    Friday, November 10, 2006 1:36 PM