It's simple and gorgeous. The build dashboard is impressive and comforting. It can add tests, and identify artifacts (results of the build) and act on them. You can automate deployment to whatever environment you like. Impressively, AppVeyor restores NuGet packages as well. It's a great example of Software as a Service AppVeyor says they "automate building, testing and deployment of .NET applications helping your team to focus on delivering great apps." Cool. I like automation, I like building, testing and deploying. I'm lazy, as are all good developers, so automated all the things! Their pricing is impressive. It's free for unlimited public repositories, which means I can setup a CI build for all my little utilities and open source projects on GitHub. However, their Pro and Premium options are extremely competitive when compared against running my own VM and CI system in Azure for a month.

The main feature eliminates the need for installing software on your laptop. The need to have a ubuntu system is also removed. Simple yet powerful.

Well, Firstly, its free for open source projects. A good CI build that includes build, test, and deploy means that you don't have to fear your code. When compared to Travis CI which is expensive for active projects, artifacts here are easily available. However for database CI AppVeyor has the major advantage that it comes with a SQL Server database on the build agents by default. This significantly simplifies the setup and avoids the need to provision, setup and teardown database virtual machines on each build.