Monthly Archives: December 2010 Is Live!

You heard right, I’ve finished with the 1.0 release. It isn’t pretty but it works. If you need a primer check out my last post. If you need a list just fill out the form and I’ll get you taken care of.

I’d like to thank Scott Stauffer(blog|Twitter) for helping me out with some tools.

I’d like to thank Sean McCown for providing me with an MSDN subscription so I could finish this project! If you aren’t following the MidnighDBA’s (blog|Twitter) you should!

If you would like to test things out then please sign up to

Lets take a look at the features:

  • Create custom list <mylist>
  • Send to list via email or web site.
  • Only list owners can send emails to list.
  • View number of replies and who has replied.
  • Manage subscriptions and list owners.
  • See who has unsubscribed and how.
  • Automatic bounce detection and auto unsubscribe from list.
  • Automatic “out of office” detection and ignore.
  • Export subscriber list.
  • Subscribe or unsubscribe via email or web.

Lets take a quick tour.

On the front page you can see a list of recent emails that have gone out.


You can update your account information.


You can manage your subscriptions.


You can email your list.


Check to see if anyone has replied to a mailing.


Manage your subscribers.


The goal is to keep it simple as possible. I hope I have done that. There are some features I would still like to have just for managing my own lists. If you have any thoughts please leave me a comment, who knows if you use SQL Meetings I’ll probably add anything you want that makes it useful to you.

Version 1.1~1.4
Cleanup and bug fixes. I’m a believer that Great is the enemy of good. This is good, so I’m launching it. That doesn’t mean it won’t have bugs and there are a few outstanding code cleanup tasks I have already scheduled. Remember, isn’t my day job at all, this was and is a learning experience for me.

Version 1.5 features(Possible):
Posterous friendly emails.
Tweet with link to message from @SQLMeetings.
Re-email a send message, you send out a mail and want to send that same mail again.

Version 2.0 features(Possible):
Linkedin integration.
Facebook integration.
Schedule reminders using generic template, you may not have your details hammered out yet but still want to send out a reminder say one week before the meeting.

Giving Back, Is Going Live Soon

I’ve been pretty quite since the PASS Summit and with good reason. Every year we have a chapter leader meeting. Every year, there is a laundry list of things that chapters would like PASS HQ to do for them. Time and again I’ve watched other people in the community step up and build something to fill a void in the PASS structure. In the early days hosted websites for chapters until PASS HQ got the infrastructure in place. We lean on other tools like Google groups or to get other things done as well but aren’t controlled by PASS or PASS HQ. It always strikes me as odd that infrastructure related items are always on the list and are always backlogged. We are a professional organization of technology people and deal with stuff like this every single day.

So, I have decided to help out. I’m staring up The goals are pretty simple to start with.

Provide an easy way to email your user group.
Provide an easy way for your users to RSVP.
Provide an easy way for group leaders to manage lists.
Provide an easy way for group leaders to track RSVP’s.

Provide an easy way to email your user group.
Sounds pretty straight forward. Just fire up outlook and BCC your group the email field. For a long time that is basically what I did. It was a pain to manage email changes, RSVP’s and bounced email. That led me to setup an email list server setup and moved that list there as a read only list. That was better, it provided bounce management but it was still hard to get people on to the list. Luckily, it used a SQL Server back end and I wrote an integration point with our then DotNetNuke website. If you singed up via DNN it automatically added you to the email list. If your email ever bounced you were deactivated from the list. You couldn’t change your email though, or RSVP easily ether. Now that we have moved off DNN I’ve lost the signup integration point and have fallen back to telling people to subscribe using again.

Provide and easy way for users to RSVP.
I got nothing on this one. I’ve tried using but it pushes your users to another website from your own and another barrier for them to easily RSVP. Basically, I get emails from people saying they will be there I pad the numbers and add some fudge in and order the food.

Provide an easy way from group leaders to manage lists.
If you have ever used a traditional list server everything is done via email with commands embedded in the body of the mail. It isn’t the slickest of user experiences. I was just editing the list server tables by hand, being a SQL Server expert and all.

Provide an easy way for group leaders to track RSVP’s.
Over time, you like to see how your RSVP’s stack up to actual attendance and watch the growth of your group over time. Again, I did this with a high tech piece of kit, pen and paper.

This is my goal for “1.0” feature sets.
user groups can have a personalized email.
lists are <email> For example my local UG would be This account is used to receive, process, and send all emails.
List owners are the only people allowed to email the list for distribution. You can have multiple list owners so one person isn’t stuck sending out the email.
List management is handled two ways. If you want to subscribe via email you send an email with subscribe in the subject to and it handles the rest. If you are a list owner you can manage the list via the web. Things like adding users, marking users as list owners and deactivating users is done via web.
To RSVP the only thing you have to do is hit the reply button. The list server tracks what users have replied to what email. As a list owner you can look at response rate via the web site.

The list server part is done. I wrote a windows service that handles processing the emails. The web UI will be done by the end of the week(Keep your fingers crossed). I am horrible at web stuff and have asked a couple of other folks to help out. This first iteration is beta stuff to flesh out functionality.

This is where you come in. Do you need something like this? If you want to use it just drop me an email admin (at) wesworld (dot) net or hit me up on twitter @WesBrownSQL. I need some folks to test out the base functions and start suggesting things for the 2.0 like twitter integration and post to posterous.

Oh, did I mention this is free? It is something I needed for my UG and figured others would like it too.