Late yesterday afternoon, Microsoft posted to their download site a Release Candidate (RC1) for the Notification Services Components Package. This is essentially the same package that was released back in February 2007, with one really major exception - it supports SQL Server 2008!
Read more →
As most you already know, Notification Services is not part of Microsoft SQL Server 2008. I think this is a shame since SSNS is really a great product. It may be rather complex at first glance, but it's a great product nonetheless.
Read more →
Last week, I completed an upgrade of a SQL Server 2000 server to SQL Server 2005. Not really a big deal; servers are routinely upgraded to a newer version of software.
Read more →
The old adage "An ounce of prevention is worth a pound of cure" can be applied to many topics and areas of life. And while it has its origins in personal health care, nowhere is it more true than in an IT shop.
Read more →
One the more welcomed enhancements of SQL Server 2005 Notification Services was the new Microsoft.SqlServer.Management.Nmo namespace. The namespace provides classes that may be used develop and administer SSNS instances and applications.
Read more →
In my initial post here on the SQLTeam site, I mentioned that for the prior three years I had blogged on another site. That blog was almost exclusively dedicated to SQL Server Notification Services.
Read more →
Even though SQL Server 2008 does not include the Notification Services (SSNS) component, it seems that companies still consider SSNS a very viable option for upcoming notification projects. I'm planning to write a blog or SQLTeam article in the near future to address some questions I'm frequently asked.
Read more →
Microsoft's Ken Henderson hosted a web cast called “Introducing Notification Services in SQL Server 2005”. It was recorded three years, but it’s still a great material. If you’ve ever sat in on one of his sessions at PASS, you know he’s a great presenter.
Read more →
Thanks to all of you who attended the DevLink Technical Conference in Nashville, Tennessee! It was great to see such a turnout for the event. Big kudos goes to all those who carried the load and championed this event.
Read more →
Have you ever been troubleshooting a SQLNS instance and noticed the status code column in some of the views and underlying tables? For example, the NSSMTPNotifications view has a column named DeliveryStatusCode with a values that range from 0 to 6.
Read more →
As database professionals, we may responsible for dozens, if not scores, of SQL Servers throughout our department or enterprise. Now that Microsoft has announced that Notification Services will not ship as part of the SQL Server 2008 product, how can you readily identify which of the servers in your charge have SSNS instances installed?
Read more →
For the past three years of so, I've been blogging about my experiences with Microsoft SQL Server and the lessons I've learned along the way. During that time, I posted some pretty good tutorials, if I do say so myself.
Read more →