MS SQL Server BackEnd Programming MS SQL Server 

Violation Of 1NF and how to deal with it

What is 1 NF? The first normal form (1NF) is one of the most violated rules while designing and developing a database.TheĀ First normal form (1NF) is a property of a relation in a relational database. A relation is in first normal form if and only if the domain of each attribute contains only atomic (indivisible) values, and the value of each attribute contains only a single value from that domain. The benefits of Normalization are: Greater overall database organization Reduction of redundant data Data consistency within the database A much…

Read More
MS SQL Server MS SQL Server SQL Windows Server 

How to configure SQL server to access it remotely

How to configure SQL server to access it remotely?, Actually this is not a big issue there are some straightforward steps to configure, but there might be a possibility of giving problem after configure using the same steps also. So go through the below steps carefully. To establish a successful remote connection is to set up ports through the Window Firewall. In SQL Server there are two types of instances. First is a default instance and the second is a named instance. To connect to the default instance of Database…

Read More