SQL Server development

Storing documents as XML in SQL Server 2005

Tuesday, February 19th, 2008

There will be occasions where you will want to store documents in SQL Server. This isn’t just for the convenience of having everything in one place to simplify backup - in many systems, documents can form part of the data being modelled so should be included in the logical and physical design of the database.

Improving ASP.NET Performance and Scalability: SQL Server Database access

Tuesday, February 12th, 2008

Your database interactions are among the most expensive operations you’ll perform in an ASP.NET application.