Tag: Databases

Install SQL Server 2014 Step by Step

August 26, 2015

I was just recently assigned to a project where we need to migrate large database servers from SQL server 2008 R2 – 32 bit to SQL server 2014 – 64 bit First thing we need to do is install SQL server 2014 on the new servers. Here is a step by step installation guide. Open SQL … More Install SQL Server 2014 Step by Step

Database Normalization

April 7, 2015

Database Normalization This is a brief quick description of database normalization.Database normalization is the process of organizing information in a relational database into tables to minimize redundancy.Normalizing a database allows scalability and it is easier to maintain, query and work with. There are 5 steps to normalize a database, my personal experience is that unless … More Database Normalization