Category Archives: Databases

Why would you use Common Table Expressions?

Introduction In this article I suppose that you have a good understanding of SQL already. I will introduce some concepts very briefly before moving on to Common Table Expressions. Below you can find the relevant database diagram of the database … Continue reading

Posted in Codeproject, Databases, Development, SQL | Tagged , | Leave a comment

What is the role of the database?

Introduction Most non-trivial applications will use a database to store data. This database can be relational or not, but some data store will be needed. Most modern database management systems (DBMS) can do much more than just storing data, and … Continue reading

Posted in Architecture, Codeproject, Databases, Development, Entity Framework | Tagged | 2 Comments

Database Normalization

Introduction After I published last week’s article somebody asked me why I stated that (in this case) the problem didn’t originate in having a function with logic, but merely having to work with a database that is not normalized. So let’s talk … Continue reading

Posted in Codeproject, Databases, Development | Tagged , | Leave a comment