I found BlogEngine.NET some time ago. It is simple blog engine with great features:

- Multi-author support
- Pingbacks and trackbacks
- Event based for plug-in writers
- Theming directly in master pages and user controls
- Gravatar and coComments implemented
- Live preview on commenting
- Comment moderation
- BlogML import/export
- Extension model
- Code syntax highlighting
- Mono support
- Full editing and creation of pages that are not posts
- Extended search capabilities
- Tag cloud
- Self updating blogroll
- Runs entirely on XML or SQL Server. Your choice.

BlogEngine.NET can store data in XML files or MS SQL database using provider model. But unfortunately blogengine database is not relational. So, I have modified source database (added relations, changed varchar on nvarchar, changed names of some tables) and created own MS SQL provider (based on BlogEngine.NET MS SQL provider code).

Download database scheme and source code

This code is provided "AS IS" with no warranties. But if you'll find any bug let me know and I'll try fix them.

P.S. Don't forget change web.config :

  <BlogEngine>
    <blogProvider defaultProvider="DevUAMSSQLBlogProvider">
      <providers>
        <add name="DevUAMSSQLBlogProvider" type="DevUA.BlogEngine.MSSQLBlogProvider"/>
       </providers>
    </blogProvider>
  </BlogEngine>