Fran Hoey

Freelance .Net Developer Web Developer Trainer Team Leader

Databases and Sql Server

Database design, query design and optimisation

MS SQL is the database system provided by Microsoft. It ties in tightly with the Microsoft .Net Framework which is why I choose to work with it.

I use MS SQL in almost every application I build and I have a lot of experience in designing database and optimising queries.

These days I typically use Entity Framework for 90% of data access. In particular I like the Code First with Migrations features which can be used to upgrade and down grade databases automatically.


  • Design relational databases based on an applications requirements
  • Create tables and relationships
  • Create views and store procedures
  • Query optimisation