A New System

We've had our own system for sending some internal notifications and low volume messages for some time. We bought a component that allowed us to generate an SMTP message and send it to a server. Using the IIS SMTP mail service, we've sent some messages from the site, like registration messages, for years.

Earlier this year we got our maintenance renewal from Lyris for their software. A thousands of dollars for yearly maintenance and looking at many thousands more for a mailing upgrade, we decided to write our own mailer.

This system uses some software from Quiksoft to generate and send lots of messages, but in a queued fashion. We essentially duplicated quite a bit of Service Broker functionality in building this system, but I think we've ended up with something that runs well.

In some future articles we'll discuss the detailed design of the high volume transactional system that we've built.

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.