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