ORM wars: Comparing nHibernate, LINQ To SQL & the Entity Framework
Ted Neward described ORM as the “vietnam of computer science” in that it’s a quagmire that starts well, gets more complicated as time passes and ends up as an open-ended commitment with poorly-defined goals and no clear exit strategy.
Posted on Wednesday, November 10th, 2010
Identity over-use: Surrogate vs Composite keys in SQL Server
The SQL Server ‘Identity’ column is a handy way of ensuring a unique primary key, but I have noticed a tendency for some database designs to over-use it.
Posted on Sunday, September 13th, 2009
Improving ASP.NET Performance: SQL Server Database access
Your database interactions are among the most expensive operations you’ll perform in an web application.There are a number of best practices that you should be following when coding a scalable application for SQL Server – here are some of the rules that I swear by.
Posted on Tuesday, February 12th, 2008
Storing documents as XML in SQL Server 2005
When considering how to store documents in SQL Server database it is worth considering that a database is designed to store data, while a file system is designed for storing files. That said, there will be occasions where you will want to store documents in SQL Server. This isn’t just for the convenience of having [...]
Posted on Tuesday, February 12th, 2008