Check out the new look of Cotega – SQL Azure Monitoring Service

February 9th, 2013

I am the founder of a startup called Cotega and also a Microsoft employee where I work as a Program Manager. This is a series of posts where I talk about my experience building a startup outside of Microsoft. I do my best to take my Microsoft hat off and tell both the good parts and the bad parts I experienced using Azure.

It has been some time since I have posted an update, but the past few months have been quite busy. One of the things that I have been working on is a major update to the Cotega service. I heard a lot of feedback from people on the v1 version of Cotega and I think one of the biggest things I heard was in the area of ease-of-use. There are a lot of things that people want to be able to monitor for their database and I just made it too hard to add all of the things needed. So I decided to step back and try to come up with a new way to set up your database monitoring. Now, you simply point Cotega to your database, provide an email to send notifications and you are ready to go.

In addition, there is now a “Free” subscription that does not require a credit card and allows you to try out the service before making a commitment. The key difference between the Free plan and a paid one is that monitoring is only done once every 2 hours (as opposed to every 10 min for a paid account). In additions paid accounts will send email notifications when database issues occur.

Cotega Dashboard

How to Host a Website on Azure and Link it to a Domain like .IO

October 6th, 2012

.COM addresses are becoming harder and hard to come by.  It seems each time you look, it is harder to get the name you want.  Many startups have become creative in the way they name their site, for example if you wanted to create a site called score.com, you might try calling it scorable.com or scorability.com.  Another option that seems to be getting more and more popular is to use non .COM domains such as instant.ly or ordr.in or ginger.io.  Many of these domains are easier to get, but the downside for many is that they are typically more expensive and the process of configuring them is often harder.  I want to talk about how I managed to create URL using the io domain which used a site hosted on Windows Azure (where all the html pages are hosted).  I am going to assume you already know how to create a web site on Windows Azure.

Getting the Domain Name

In the past, I have used GoDaddy as the place that I set up most of my domains.  For .COM’s this is incredibly cheap (most of the time you can find a promo code for just about anything) and I have found them to be extremely supportive and easy to work with.  However, in this case I wanted to get a .IO domain which is actually a Indian Ocean domain because the .COM was owned by someone else trying to sell it.  To do this, I used http://nic.io where it cost ~$93 for the year (as opposed to ~$8 for a .COM domain).

DNS Server Configuration

After I purchased the .io domain from nic.io, I learned that they needed to be provided with DNS settings requiring a Primary and Secondary DNS Server.  This was kind of frustrating since GoDaddy provided me with this whenever I created a .COM address.    So after looking a little more I learned that I could just use GoDaddy for this.  In my case, I could just log into my existing GoDaddy account and configure this for no extra charge.  For you, you could either look at another DNS Server provider or create an account with GoDaddy to do this.

GoDaddy DNS Configuration

Within my GoDaddy account, I launched the DNS Manager and chose to create a new Offsite Domain.  This was pretty hidden which is why I am adding a screen shot of where I went.

GoDaddy DNS Configuration

In the Domain Name text box I entered my .IO domain name, clicked Next and copied the 2 DNS servers that were provided.  Copy these as you will need them in a minute.

Create A Record

The next step is to configure the GoDaddy DNS servers so that when a request for my domain .io is requested, it know where to point the user to.  In my case it is a Windows Azure website with a .cloudapp.net name.    To do this config, in the GoDaddy DNS Dashboard you click on “Edit Zone” under the domain you just added.  In the A Host section, choose “Add Record” and for “Host” use @, and for “Points To” add the IP address to your Azure hosted site.

Choose Save

Configure A Record

Add DNS Servers to NIC.io.

The final step is to configure NIC.io so that it knows to use the GoDaddy domain servers you just configured.  Log in to the admin panel for NIC.io and choose to Manage the DNS Settings.  In the “DNS Servers or Mail & Web Forwarding Details”, for the primary server enter the first DNS server you copied from the previous steps and in the Secondary Server enter the second.    If you only have one DNS server, I think that is probably ok.  At the bottom choose “Modify Domain”.

Give it an hour or two

It usually takes an hour or two for these configurations to fully get updated.  However, after that you should be all set to go.

Using Cloud Services to send Notifications with Windows Phone

July 28th, 2012
I am pretty excited because this week one of my other personal side projects called the “Windows Phone Baby Monitor” just won that “2012 Appies People’s Choice Award”, an internal contest for Microsoft colleagues.  What I would like to do in this post is give you some background on how I managed to implement SMS, Phone and Email notifications from Windows Phone for this app.
Baby Monitor for Windows Phone

Background

This application basically turns your Windows Phone into a baby monitor.  You leave the phone near your baby while it is sleeping and then when it detects crying it will send a notification by phone, email or SMS.  There are a number of things that I do within the application to set the decibel level and length of time the crying lasts to avoid false notifications like doors slamming.

Sending Notifications with Windows Phone API’s

When I first started building the application, I figured this would be very simple to implement because I could just write to some sort of Windows Phone API that would allow me to send the SMS, email or phone notifications.  Although there is an API for doing this, the main issue I had was the fact that the user needed to physically click an approve button for the notification to complete.  Since I figured it was somewhat unrealistic to expect a baby to sit up, move to the phone and click a button when it was done sleeping, I needed to come up with another solution.

Using Services to Send Notifications

From my work with Cotega (which is a monitoring service for SQL Azure databases), I had a little background experience on how to send notification.  For that service, I used Amazon’s SES  to send email notifications.  For this Baby Monitor, I chose to use a different service called SendGrid to send email notifications.  I used this service over Amazon SES because I wanted to compare the two and also because there was a great offer of 25,000 free emails / month for Azure services.  Since SendGrid does not support sending SMS or making phone calls, for this part I chose to use Twilio.

SendGrid

SendGrid was incredibly easy to implement within my MVC service.  The way it works with the Baby Monitor is that when the phone detects crying, it makes a WebClient request to my MVC service, passing some details like the Windows Phone device id, decibel level and the email address that needs to be contacted.  From that point the service makes a SendGrid request to send the email.  As you can see, the controller code is pretty simple and looks like this.

using SendGridMail;
using SendGridMail.Transport;
// Create the email object first, then add the properties.
SendGrid myMessage = SendGrid.GenerateInstance();
myMessage.AddTo(emailAddress);
myMessage.From = new MailAddress("\"Cotega Baby Monitor\" ", "Cotega Baby Monitor");
myMessage.Subject = "Baby Monitor Alert!";
myMessage.Text = "Crying was detected by the Baby Monitor.  Decibel Level: " + maxDecibels + ".  ";

// Create credentials, specifying your user name and password.
var credentials = new NetworkCredential("[myusername]", "[MyPassword]");

// Create an REST transport for sending email.
var transportREST = REST.GetInstance(credentials);

// Send the email.
transportREST.Deliver(myMessage);

Twilio for Sending SMS and Phone Notifications

This part was a little more complex because although sending notifications through Twilio is pretty cheap within North America, I still needed a mechanism to limit the ability for people to send unlimited notifications.  For this, I chose to implement a token based system that was linked to the device id of the phone.  When they download the app, I give them a certain number of tokens to send SMS and make phone calls (emails are free), and if they wish to purchase more they can do so and tokens are applied to their account.  There are some really cool things about Twilio such as:

  • Text to Voice for phone calls:  This allows me to send some text to the Twilio service such as “Your baby is crying” and when Twilio makes a call to the the person’s phone, the person hear’s a computer like voice stating “Your baby is crying”.
  • Attaching audio files to phone calls:  When I call the Twilio service, I can pass it a link to a URL that contains an audio file.  When Twilio makes the call to the person, the audio file can be played over the phone.  This is really useful because I can attach a snippet of audio of their baby crying to allow them to ensure that it is really their baby crying and not a jack hammer in the background or something else.

Just like SendGrid, the code used in the MVC controller is really very simple using the TwitML api.  Here is what it looks like for sending SMS messages.

using Twilio;
using Twilio.TwiML;
//twilioAccountSID and twilioAuthToken values are store in the web.config (hopefully encrypted)
public string twilioAccountSID = ConfigurationManager.AppSettings["twilioAccountSID"];
public string twilioAuthToken = ConfigurationManager.AppSettings["twilioAuthToken"];
//This it the controller code that sends the SMS message
var twilio = new TwilioRestClient(twilioAccountSID, twilioAuthToken);
string smsMessageBody = "Baby Monitor Alert! Crying detected at decibel Level: " + maxDecibels + ". ";
if (fileName != null)
    smsMessageBody += "http://cotega.com/audio/" + fileName + ".wav";
// if phone number is 10 digits I need to add the +1
if (phoneNumber.Length == 10)
    phoneNumber = "+1" + phoneNumber;
var msg = twilio.SendSmsMessage("+1[mytwilionumber]", phoneNumber, smsMessageBody);

There is a little bit of code that I have not show before and after that first checks a SQL Azure database to see if they have enough tokens to send a notification, and then updates their token count after the message is sent.

The code for making the phone call is very similar.

// Create an instance of the Twilio client.
TwilioRestClient client;
client = new TwilioRestClient(twilioAccountSID, twilioAuthToken);

// Use the Twilio-provided site for the TwiML response.
String Url = "http://twimlets.com/message";
Url = Url + "?Message%5B0%5D=" + "Hello.%20Crying%20was%20detected%20by%20the%20baby%20monitor.";
if (fileName != null)
    Url += "&Message%5B1%5D=" + "http://www.cotega.com/audio/"+fileName+".wav";

// Instantiate the call options that are passed to the outbound call
CallOptions options = new CallOptions();

// Set the call From, To, and URL values to use for the call.
// This sample uses the sandbox number provided by
// Twilio to make the call.
options.From = "+1[my twilio number]";
options.To = "+1" + phoneNumber;
options.Url = Url;

// Make the call.
Call call = client.InitiateOutboundCall(options);

Notice how I can attach a string of text along with a url to http://twimlets.com/message. For example, try clicking this link and see the XML that is created.  If you passed this to Twilio it would make a phone call and say “Hello from Liam”.  Notice also, how I attached a link to a WAV file.  Twilio will take that audio and play it when the person answers the phone.  Very cool right?

As I mentioned, I did not go into many details of how I linked the Windows Phone device ID to the service to allow me to verify they have enough tokens before making the call, but if you are interested in this, let me know and I can help you get going.

Liam

How to use PayPal with ASP.NET MVC

June 12th, 2012

I talked previously about why I chose to use Stripe with Cotega to allow me to accept credit card payments. In it I talked about how excellent their support was and how easy it was to take their samples and implement it into my service. I am still extremely pleased with my choice of using Stripe and I have no intention of moving away from it. I have however always wanted to investigate using PayPal as an alternative payment option because occasionally International customers will have credit cards that are not acceptable by Stripe or they just plain prefer to use PayPal. For this reason, I decided to take some time and understand what it would take to implement PayPal into my MVC based service.
Unfortunately, I did not find this to be quite as simple to implement as it was with Stripe. Although PayPal has a number of examples, none of the ones I could find were targeted for MVC and there did not seem to be any good tutorials on this subject to get me started. I hope this blog post will help anyone thinking to implement PayPal with MVC. I do want to caveat this with the fact that I am far from a PayPal expert and I do not claim that this is the “PayPal preferred” way to implement this other than to say that I have tried to convert other examples as best I can and it has worked well for me so far. If you have any comments or suggestions, I am very interested to hear your feedback.

Step 1 – Choosing PayPal IPN vs. PDT vs. Express

One of the first things I needed to decide on was the appropriate “PayPal Responder” to use. A responder is like a callback that PayPal does when the transaction is complete (successful, unsuccessful, invalid, etc.). It can also return custom variables that you set when the user first clicks the “Pay Now” button.
Since we are using MVC, we first need to create a View that initiates the transaction to PayPal. This is where the user clicks the “Pay Now” button and is re-directed to PayPal where they enter their credit card or PayPal account information. After this is complete, PayPal can initiate a responder which calls your service with the results of the transaction. The flow of the process looks something like this:

PayPal payment process

You really only need to use a responder in the cases where you need to continue with some process after that transaction completes. For example, in my case I want to be able to enable a user subscription once the transaction completes. If you are simply accepting payments, there may be no need to go to the complexity of using responders.
There is lots of information on responders but I found that Instant Payment Notifications (IPN) was the best choice for me, and probably yourself as well if you simply want a callback from PayPal to your MVC controllers.

Step 2 – Implementing the View and Form

The next step is to create a payment page using a View where the user can choose to start the PayPal process. Here is an example of a HTML form that I used.

@*
*@

 

There are a couple of things you should notice in this form:
• The commented out section allows me to either submit the payment request to the PayPal sandbox (test) environment or to the actual live PayPal url.
• Notice all the input type=”text” types. These are values that are returned to my controller after the transaction is complete. When I load the page, I set the “device-id” input type to a custom value that I want PayPal to return when the transaction completes. I can use this value to update the user’s status in my SQL database (assuming the transaction is successful).
• The “return” input type URL defines where the user will be redirected to after the transaction is complete. It is important that you don’t rely on this as a method for completing a transaction because most users will never click on this link. Don’t forget to create this page.
• The notify_url input is the IPN URL that PayPal will call after the transaction completes.
• Remember to associate the business input type email address with the PayPal address you used for your sandbox or live account
• There are a lot more custom values you can use and learn more about here.

Step 3 – Creating an IPN Controller in MVC

Next we will want to create a new ActionResult controller that will receive the responder request from PayPal after the transaction completes. I want to give credit to this page where I was able to leverage a lot of code for this controller. You should also remember to actually create an IPN view (IPN.cshtml) page because PayPal will continue to call this controller until it gets a successful page returned.

public ActionResult IPN()
{
// Receive IPN request from PayPal and parse all the variables returned
var formVals = new Dictionary();
formVals.Add("cmd", "_notify-validate");

// if you want to use the PayPal sandbox change this from false to true
string response = GetPayPalResponse(formVals, false);

if (response == "VERIFIED")
{
string transactionID = Request["txn_id"];
string sAmountPaid = Request["mc_gross"];
string deviceID = Request["custom"];

//validate the order
Decimal amountPaid = 0;
Decimal.TryParse(sAmountPaid, out amountPaid);

if (sAmountPaid == "2.95")
{
// take the information returned and store this into a subscription table
// this is where you would update your database with the details of the tran

return View();

}
else
{
// let fail - this is the IPN so there is no viewer
// you may want to log something here
}
}

return View();
}

string GetPayPalResponse(DictionaryformVals, bool useSandbox)
{

// Parse the variables
// Choose whether to use sandbox or live environment
string paypalUrl = useSandbox ? "https://www.sandbox.paypal.com/cgi-bin/webscr"
: "https://www.paypal.com/cgi-bin/webscr";

HttpWebRequest req = (HttpWebRequest)WebRequest.Create(paypalUrl);

// Set values for the request back
req.Method = "POST";
req.ContentType = "application/x-www-form-urlencoded";

byte[] param = Request.BinaryRead(Request.ContentLength);
string strRequest = Encoding.ASCII.GetString(param);

StringBuilder sb = new StringBuilder();
sb.Append(strRequest);

foreach (string key in formVals.Keys)
{
sb.AppendFormat("&{0}={1}", key, formVals[key]);
}
strRequest += sb.ToString();
req.ContentLength = strRequest.Length;

//for proxy
//WebProxy proxy = new WebProxy(new Uri("http://urlort#");
//req.Proxy = proxy;
//Send the request to PayPal and get the response
string response = "";
using (StreamWriter streamOut = new StreamWriter(req.GetRequestStream(), System.Text.Encoding.ASCII))
{

streamOut.Write(strRequest);
streamOut.Close();
using (StreamReader streamIn = new StreamReader(req.GetResponse().GetResponseStream()))
{
response = streamIn.ReadToEnd();
}
}

return response;
}

Step 4 – Enabling Sandbox and IPN

I highly recommend that you first test this with the PayPal sandbox. You need to sign up separately for a sandbox account from your live PayPal account from the developer page here.
For sandbox accounts, you do not need to enable IPN, but for live accounts you do. Once you are ready to switch to live, log in to your PayPal account and go to Profile | More Options | My Selling Tools | Choose Update for “Instant Payment Notifications” and then enable IPN and set the URL that you wish PayPal to call (which is the IPN controller we created above).

Summary

At this point you should be ready to go. One of the real pains of this system is that there is no easy way to debug your IPN controller if you are running the MVC app on a remote machine that does not have Visual Studio installed. For this reason, I chose to log each of the steps to a “Log” table that I created in my database. That way I could log all the variables that PayPal returned and still get an idea of what was happening or determine if there were any issues.
I am still testing this and have not yet implemented this into my Cotega service for monitoring SQL Azure databases. For now, if you would like to see this working I am using it in a Windows Phone Baby Monitor app that I wrote.
If you have any suggestions or problems I look forward to hearing from you.

How to Create an RSS Feed from Windows Azure Table Storage Data

May 3rd, 2012

Today I am going to talk about how you can create an RSS feed from Azure Table Storage data. Realistically, you could very easily change this code to create a feed from SQL Azure or any store for that matter (if you get stuck email me at Liam AT Cotega dot com). The code that I am going to use is based on a sample created by DeveloperZen. I am also going to use the trick I blogged about to return the top X rows from Table Storage in reverse chronological order.

The reason I did this is because I needed to be able to provide my customers with a RSS / XML feed of the most recent items logged by the Cotega service. This service logs database statistical information on a users database such as query performance, blocked queries, etc. By providing this data as an RSS feed it is easy for my customers to then embed the feed into their own monitoring systems if they do not wish to use the Cotega dashboard. I am also hoping to use this feed (or another I am creating in JSON) to allow people to build mobile apps so that they can monitor their database from a smartphone. By the way, if you are interested in helping with this, let me know.

How it Works
At the bottom of this post, I have included an MVC3 project that shows how this works. If you open the solution in Visual Studio, you will want to focus on the HomeController.cs file which is located in the /Controllers folder.

For this to work, I will use the ServiceModel Syndication namespace for RSS and the Windows Azure namespaces to connect to my storage. As such, I have added the following to the controller.

using System.Xml;
using System.ServiceModel.Syndication;
using Microsoft.WindowsAzure;
using Microsoft.WindowsAzure.StorageClient;
using Microsoft.WindowsAzure.ServiceRuntime;
using Microsoft.WindowsAzure.Diagnostics;

Within this controller there is one key functions and two classes. The first class defines the structure of the data that will be queries from Azure table storage and the second defines an ActionResult for the RSS feed. The Feed function is what gets called when you enter http://x.x.x.x/home/feed in your browser. You may want to set a breakpoint on this when you run the code. Some of the things that this function does is:

  • Receive an agentname and username.  These parameters are used to filter the results that come back from Azure storage
  • Create a connection string to my Windows Azure Table store called storageConnectionString . Notice you will need to replace [ACCOUNTNAME] and [ACCOUNTKEY] with your own credentials.
  • Create an EndDt that is set to todays date.  I use this as a trick to sort the results in reverse chronological order.  For more details on why I do this see this page.
  • Take the results of this query and fill up the RSS feed with the 50 most recent items from Table Storage and returns this to the browser
[HttpGet]
public ActionResult Feed(string agentName, string userName)
{
string storageConnectionString = "DefaultEndpointsProtocol=http;AccountName=[ACCOUNTNAME];AccountKey=[ACCOUNTKEY]";

//Select most recent 50 items in desceneding order of date
DateTime endDt = DateTime.Now.ToUniversalTime();

//create syndication feed
SyndicationFeed feed = new SyndicationFeed("Monitoring Agent Feed", "This is an RSS feed for monitoring agent logged data.",
new Uri("http://127.0.0.1:81/alert/feed"), "075211", DateTime.Now);

try
{
// Get the loggged data
CloudStorageAccount Account;
Account = CloudStorageAccount.Parse(storageConnectionString);

// Connect to Azure Tables
CloudTableClient TableClient = new CloudTableClient(Account.TableEndpoint.ToString(), Account.Credentials);
TableServiceContext tableServiceContext = TableClient.GetDataServiceContext();

// Use rowEndKeyToUse so that I can sort the data in reverse chronological order
string rowEndKeyToUse = string.Format("{0:D19}", DateTime.MaxValue.Ticks - endDt.Ticks);

var results = (from g in tableServiceContext.CreateQuery("logevent")
where g.PartitionKey == userName
&& g.RowKey.CompareTo(rowEndKeyToUse) > 0
&& g.EventType.CompareTo(agentName) == 0
select g).Take(50);

//add feed items
List syndicationItems = new List();

foreach (LogEvent logEvent in results)
{
var syndicationItem = new SyndicationItem(String.Format("{0}", logEvent.EventType),
String.Format("Watching: {0}
Value: {1}", logEvent.Watching, logEvent.EventValue),
new Uri("http://cotega.com"),
// You may want to replace this guid with the rowkey and partitionkey if not concerned about publishing this in the feed
System.Guid.NewGuid().ToString(),
logEvent.Timestamp);

syndicationItems.Add(syndicationItem);
}

feed.Items = syndicationItems;
}
catch (Exception ex)
{
//Log error
}

//return feed
return new RssActionResult() { Feed = feed };
}
}

public class LogEvent : TableServiceEntity
{
public string UserName { get; set; }
public string EventType { get; set; }
public int EventValue { get; set; }
public string Watching { get; set; }
public DateTime EventTime { get; set; }
}

///
 /// RssActionResult class. /// 
public class RssActionResult : ActionResult { public SyndicationFeed Feed { get; set; } public override void ExecuteResult(ControllerContext context) { context.HttpContext.Response.ContentType = "application/rss+xml"; Rss20FeedFormatter rssFormatter = new Rss20FeedFormatter(Feed); using (XmlWriter writer = XmlWriter.Create(context.HttpContext.Response.Output)) { rssFormatter.WriteTo(writer); } } }

That’s it. If you have any questions, let me know in the comments.
Download Sample – Azure RSS Feed

What I Learned Building a Startup on Microsoft Cloud Services: Part 12 – Your Customers are my Customers

April 27th, 2012

I am the founder of a startup called Cotega and also a Microsoft employee within the SQL Azure group where I work as a Program Manager. This is a series of posts where I talk about my experience building a startup outside of Microsoft. I do my best to take my Microsoft hat off and tell both the good parts and the bad parts I experienced using Azure.

Over the years I have constantly been amazed at how customers end up using products I work on.  No matter, how much thought and planning has been put into a product it seems you can never fully appreciate how customers will use your products until they actually start using them.  I suppose that is a key reason for building a “Minimum Viable Product” and to get your product out the door as soon as possible so that you can get this feedback an iterate quickly.

One example of this became very clear early on in the Cotega beta.  Initially, I thought that charting of logged data would be really useful for DBA’s to be able to visualize the trends that were happening over time within their database.  This was a key reason for adding this feature.  After talking with various people, I started to realize that although this was in fact useful to DBA’s, what many of them really felt would be useful would be to take these charts and embed them in their own web site so that their customers could see the health of the system.  In a way, their customers would be my customers.   This was really a surprise to me and something I had never thought of.  As it turned out, it was very easy to implement because it was just a matter of creating a new MVC page that accepted the name of the chart and the user name to be used to builds the chart.  Then I could use either <OBJECT> or <IFRAME> tags to take this page and embed it.  Here is an example that shows a historical look at how long it takes to connect to my SQL Azure database. The numbers to the right indicate how many milliseconds it took to complete the connection.


This chart will be loaded dynamically each time you load this page. Here is the code that I used to embed this chart. Notice how, I used iFrame, which is because WordPress does not work well with the Object tag.

<iframe src=”http://cotega.com/home/charts?agentName=Monitor Customer Database&amp;userName=liam” frameborder=”0″ marginwidth=”0″ marginheight=”0″ scrolling=”no” width=”500″ height=”400″></iframe>

Cloud Competitive Advantage

As it turned out, this ended up being a real competitive advantage for me over traditional on-premises monitoring solutions.  Since Cotega is hosted completely in the Azure environment, it is very easy for me to make these charts available to be embedded in customer’s web sites.   If Cotega was an on-premises system, this would have been much more difficult due to firewall and other issues.  Also, if the charting was only used by DBA’s, this capability to embed charts and data would not be nearly as critical.

Protovis Charting

While I am on the subject, you might be interested to learn how I chose to implement the charting.  In the early stages of the beta, I used a charting control from Infragistics.  This control was great and very easy to use (although certainly not cheap).  In the end, I decided to use a charting control from Protovis because it had the ability to copy and paste charts directly from the Dashboard so that they could be used in something like Excel or Word.    If you are using Internet Explorer, give this a try by right clicking on the above chart and choosing paste into a Word document. Very cool, right? The other nice part about Protovis is that it is easy and free.

What I Learned Building a Startup on Microsoft Cloud Services: Part 11 – Vacation Time, Profitability and Listening to the Customers

April 17th, 2012

I am the founder of a startup called Cotega and also a Microsoft employee within the SQL Azure group where I work as a Program Manager. This is a series of posts where I talk about my experience building a startup outside of Microsoft. I do my best to take my Microsoft hat off and tell both the good parts and the bad parts I experienced using Azure.

Vacation Time

It has been a few weeks since my last post and I apologize for that.  One of the big reasons why I have not posted more recently is because I took a vacation with my family.  One of the downsides of starting a business by yourself is that you are never truly on vacation.  It is important that Cotega is always running and although it is pretty self sufficient and (luckily) I have not had any major issues with the service other than that one Azure outage, I am always concerned that something may happen or a customer has a problem.  With most jobs there is always someone that knows how to get a hold of you if there is a major issue and even if you have a co-founder there is always someone there who can contact you if there is a problem.  I think that is really one of the other big advantages of bringing on a co-founder.

Profitability

Since I last posted, I started charging for the service and I am  happy to say that Cotega is now officially profitable.  Yeah!…   Well, let me be more clear about that.  By profitable, I mean I am officially making enough money to cover the costs of operating the service (including those costs that will come when my BizSpark program ends).  I am still a long way from taking any major salary.  But for me this is a big step because it was one of the main goals of starting Cotega.  If you are  reading this and are thinking of doing a startup, I have to tell you that one of the most exciting things to see are those first transactions coming in to your account.  Even the small transactions are incredibly exciting.  I think it has to do with the realization that there are in fact  customers out there that are interested in what you are doing and are willing to pay for it.

New Features and Customer Suggestions

The other big reason why I have not posted is because I have been focusing on some new features for the service.  Yesterday I deployed an update that allows for monitoring of blocked and poor performing queries.    Each of these new features have come from existing customers I have been working with.  I keep the suggestions in the Github issue repository where I can track the features that are most commonly requested and start working on those first.    The other great source of ideas has been from people I have contacted that are not customers at all.  For example, Microsoft has some amazing MVP’s who work closely with different Microsoft technologies and are absolute experts in these products.  Every MVP I have ever worked with has gone way out of their way to help me and some of the best ideas (that are still in the works) have come from these people.

If any of you have not yet tried the service but are interested in seeing the service, I created this code that you can use to try any of the plans for 30 days free: 30dayfree

Liam

What I Learned Building a Startup on Microsoft Cloud Services: Part 10 – Choosing a Billing System

March 21st, 2012

I am the founder of a startup called Cotega and also a Microsoft employee within the SQL Azure group where I work as a Program Manager. This is a series of posts where I talk about my experience building a startup outside of Microsoft. I do my best to take my Microsoft hat off and tell both the good parts and the bad parts I experienced using Azure.

This past week I was able to move Cotega out of its beta stage and on to the production servers.  Since my beta customers were not being charged to use the service, one final work item I needed to complete before moving out of beta was to implement a billing system.  Since a number of people have asked me about my choices in this area, I thought it would be good if I talked about it today.

Without a doubt one of the most common choices for doing online credit card processing is Paypal.  I really seriously considered using Paypal since I have trusted them so much in the past for my own purchases and I have read that their API’s are quite extensive.  However, since I am building a startup, I felt I should see if there were any startups in the area of credit card processing.  Two of the most interesting ones that I narrowed my choices down to were Stripe and Dwolla.

Stripe is a really interesting company.  They are one of the many companies that have come out of the Y Combinator startup program.  Their prices seemed to be very similar to what you would get from PayPal which is 2.9% + $0.30 / charge.  But what I really liked about Stripe was their support.  Although they have the typical support where you can email questions, they also have a Campfire based chatroom where you can go to ask questions in real-time.  I have logged on a few times and each time there were always a large number of people online to answer my questions.  But what was really surprising was that most of the questions were not in fact answered by Stripe customer support but rather by Stripe customers.  Imagine having the support of customers who would take the time to help out other customers?

The other great part about Stripe were the API’s.  Not only did Stripe offer their own API Library to integrate with languages like Python, Ruby, PHP and Java, but they also had a really extensive set of 3rd party libraries for even more languages (including two for .NET that both work really well).

Dwolla, was also really interesting.  I still don’t completely understand how they keep pricing so  outrageously low.  Their pricing is also pretty simple.  If you charge your customers less than $10 you do not pay anything for that transaction.  If you charge anything more than $10, you pay a flat $0.25 / transaction.  For this unique business model, they were ranked by “Fast Company” as one of the 50 most innovative companies.

Just as an aside.  When I signed up for a business credit card from my bank they kept calling me to see if I wanted to use their credit card processing system.  If I remember correctly, they wanted to charge me something like $100 to setup, plus $30 / month usage fee, plus 2.9% + $0.30 / transaction.  When I told them about Dwolla’s pricing they stopped calling me.  :-)

In the end, I chose to use Stripe.  I had just read so many awesome things about them and their support was just so great that it tipped the scales for me over Dwolla’s amazing pricing.

After spending a lot of time with Stripe and getting my first paid customers, I am still very happy that I chose to use them.  Their administrative dashboard is very extensive and really easy to use.  I also love how easy it is to switch from “live” and “test” mode which allowed me to fully test Cotega with simulated credit cards and subscription plans before going live.  I am still not sure if customers will demand to be able to use PayPal, but Stripe has seemed to give me everything I need for now.

What I Learned Building a Startup on Microsoft Cloud Services: Part 9 – Sending Email Notifications from Windows Azure

March 14th, 2012

I am the founder of a startup called Cotega and also a Microsoft employee within the SQL Azure group where I work as a Program Manager. This is a series of posts where I talk about my experience building a startup outside of Microsoft. I do my best to take my Microsoft hat off and tell both the good parts and the bad parts I experienced using Azure.

A key feature of the Cotega monitoring service is the ability to send email notifications when there are issues with a user’s database. The Windows Azure worker role executes a specified set of jobs against a users database and if there are issues such as connection drops or query performance degradation, then the service will send a notification to the administrator.

Currently there are no SMTP servers available within Windows Azure to allow me to send email notifications. Luckily, there are a huge number of third party email services that work really well with Windows Azure and are extremely cheap.

Sending Email Using Free Email Services

To get started, I first built a prototype that would send notifications from my worker roles. To do this I started with Hotmail as the SMTP server. The code to do this is pretty simple and there are a number of good examples on how to do this, such as here and here. These services worked pretty well.  Ultimately I decided not to move forward with them given the sending restrictions that free email services like Hotmail, Office365, GMail, Yahoo mail have. For example, many of them limit the number of senders you can send to within an hour or limit the total number of emails you could send over a specified period of time. I suspected it would be a long time before the Cotega service reached these limits but I preferred to avoid them if possible.

3rd Party Paid Email Services

I really did not want to host my own SMTP service in Windows Azure.  In fact, I have heard (but not confirmed) that sending emails using your own SMTP servers can have issues where emails will frequently be bounced back or will be tagged inaccurately as spam.  Many third party email services have techniques to minimize this which was very attractive to me.  So for these reasons, I started researching other third party email services. Some of the most promising ones that I found were Elastic EmailSendGrid and Amazon SES (Simple Email Service). Each of these are paid services.  I ended up using Amazon SES primarily because I wanted to get an opportunity to learn more about Amazon’s services and their cost was attractive at $0.10 per thousand email messages. The other interesting thing about Amazon SES is that they start you out at a limited number of outbound emails. This limit is quite high at 10,000 over 24 hours and increases as Amazon learns to trust that you are not sending spam. Plus you can request an increase if needed. The dashboard for monitoring your email traffic is pretty nice and allows you to visually see the number of delivered, rejected, bounced and complaints emails.

After setting up my Amazon SES account, I needed to install the Amazon SDK and include the Amazon.SimpleEmail.Model namespace which would be deployed a a reference to the worker role. Here is a snippet of code that I used which is based on a sample Amazon provides. If you use it, remember to update the [CODE] sections with your SES keys:

public static Boolean SendEmailSES(String From, String To, String Subject, String Text = null, String HTML = null, String emailReplyTo = null, String returnPath = null)
{
    if (Text != null && HTML != null)
    {
        String from = From;

        List to
            = To
            .Replace(", ", ",")
            .Split(',')
            .ToList();

        Destination destination = new Destination();
        destination.WithToAddresses(to);
        //destination.WithCcAddresses(cc);
        //destination.WithBccAddresses(bcc);

        Content subject = new Content();
        subject.WithCharset("UTF-8");
        subject.WithData(Subject);

        Content html = new Content();
        html.WithCharset("UTF-8");
        html.WithData(HTML);

        Content text = new Content();
        text.WithCharset("UTF-8");
        text.WithData(Text);

        Body body = new Body();
        body.WithHtml(html);
        body.WithText(text);

        Message message = new Message();
        message.WithBody(body);
        message.WithSubject(subject);

        AmazonSimpleEmailService ses = AWSClientFactory.CreateAmazonSimpleEmailServiceClient("[CODE]", "[CODE]");

        SendEmailRequest request = new SendEmailRequest();
        request.WithDestination(destination);
        request.WithMessage(message);
        request.WithSource(from);

        if (emailReplyTo != null)
        {
            List replyto
                = emailReplyTo
                .Replace(", ", ",")
                .Split(',')
                .ToList();

            request.WithReplyToAddresses(replyto);
        }

        if (returnPath != null)
        {
            request.WithReturnPath(returnPath);
        }

        try
        {
            SendEmailResponse response = ses.SendEmail(request);
            SendEmailResult result = response.SendEmailResult;

            Console.WriteLine("Email sent.");
            Console.WriteLine(String.Format("Message ID: {0}",
                result.MessageId));

            return true;
        }
        catch (Exception ex)
        {
            Helper.LogException("Worker - SendEmailSES", ex.Message.ToString());
            return false;
        }
    }

    Console.WriteLine("Specify Text and/or HTML for the email body!");

    return false;
}

What I Learned Building a Startup on Microsoft Cloud Services: Part 8 – I failed to plan for failure

March 7th, 2012

I am the founder of a startup called Cotega and also a Microsoft employee within the SQL Azure group where I work as a Program Manager. This is a series of posts where I talk about my experience building a startup outside of Microsoft. I do my best to take my Microsoft hat off and tell both the good parts and the bad parts I experienced using Azure.

On Feb 29th, I woke up to learn that Windows Azure (the hosting site of the Cotega monitoring service) was experiencing a service outage.  It surprised me that it wasn’t an email from Windows Azure or from an angry customer that notified me of this issue, but rather I learned it from reading Hacker News.  When I first saw the post I immediately checked the Cotega worker role and sure enough it had stopped monitoring user’s databases.  This was more than a little embarrassing for me since I had tried to follow the golden rule when creating services of “Planning for failure”.  I thought I had done everything possible to deal with failures.  I had multiple worker roles to handle the case where one machine fails.  As I discussed earlier, I even moved my SQL Azure queueing system to Windows Azure queues because of issues I would have monitoring a user’s database if SQL Azure failed.  What I did not plan for, was the case when Windows Azure itself became unavailable. When I first learned of the outage, my first thought was that maybe it was a bad idea to rely so heavily on the cloud for my service.  But soon after I realized that this was really just a failure on my part, not on the cloud.  All services will have issues at some point in time.  This is true regardless of whether they are in the cloud or on premises.  I had not considered all critical failure scenarios.  Not only did I not have a solution to handle failures like this, I did not even know about the failure until I read about it in the news.  In the back of my mind I had always thought either Windows Azure or a customer would notify me if there was an issue like this, but even if they had, this would not have helped me automatically handle the failure.  What I took away from this is that I needed to automate the failover of the monitoring service.  To do this I would need to set up a separate application to watch my worker roles.  Since pinging worker roles is disabled by default and I prefer to avoid opening up this port, the next best thing seems to be to check the logging table from a machine outside of the Windows Azure data centers.  If there were no entries in the log table in last 5 minutes, then there must be an issue and it would then:

  1. Send me an email and SMS notification of the failure
  2. Start running the monitoring from a separate location

Then once Windows Azure was back up and running, I could reset this tool back to the state of pinging the worker roles and disable monitoring from this separate location.  Luckily, the monitoring service is built to handle multiple instances of the monitoring service running at the same time, so when Windows Azure comes back up, the separate monitoring service will just work in parallel to it until I shut it down. The only problem I still need to handle is the case where Windows Azure queues becomes unavailable as this is a central service that is needed by my service.  I’ll have to think about how to handle this failure a little more. In any case, this was a really good test for me to learn from a major service failure and I think this will ultimately make the final service more more solid.