title: How do I determine a public holiday in Sql server?
body: <p>I have an application written in c# that cannot run on a public holiday or a weekend.  I've looked around a bit and haven't found anywhere (official) that provides all the public holidays for the next say 50 years.  </p>
  
  <p>If I can get these, I will simply bulk insert them into my sql server Holidays table and use that.  However, I can't find this data anywhere.</p>
  
  <p>Does anyone know if Sql server has any support for public holidays or an algorithm of some sort to work them out?  Or does anyone have somewhere official that I can bulk insert from.</p>