We now default the NHibernate dialect as well since most users are on
SqlServer anyway. Also cleaned up the acceptance tests becaus of this
simplification