Tips for Database Normalization
Tips for Database Normalization Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies. It is a two step process that puts data into tabular…
Tips for SQL Query Optimization
Tips for SQL Query Optimization The sql query becomes faster if you use the actual columns names in SELECT statement instead of than ‘*’. For Example: Write the query as SELECT id, first_name, last_name, age, subject FROM student_details;…
Tips for Database ConnectionStrings of Various Provider
Tips for Database ConnectionStrings of Various Provider Microsoft SQL Server // ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = “Dsn=DsnName;” + “Uid=UserName;” +…
Tips to Bind Dropdownlist in Asp.net
Tips to Bind Dropdownlist in Asp.net We can bind DropDownList in different ways by using List, Dictionary, Enum and DataSet. To bind DropDownList, we need to set some properties: DataSource DataValueField DataTextField Let’s see how to use these…
Tips to Choose Right Web Hosting For Your Website or Blog
Tips to Choose Right Web Hosting For Your Website or Blog Even armed with the knowledge of what happens when you choose the wrong host, you may still feel overwhelmed and uncertain on how to choose the best host for your needs. Choosing the right web…
Tips to keep track of changes of web page contents
Tips to keep track of changes of web page contents Follow That Page Register to start using Follow That Page, then click on Your Pages to add a new page to monitor. The settings for this service is quite simple. You can set the frequency of checks from…
Mycodetips-list of open source version control tool
Mycodetips-list of open source version control tool Revision control is an excellent way to combat the problem of sharing files between workers. CVS CVS is the grandfather of revision control systems. It was first released in 1986, and Google Code still…
Tips to Create SRS(Software Requirement Specifications) Document
What are software requirements specification (SRS)? Software requirements specification capture system behavior as opposed to non-functional requirements specifications which define attributes as not behavior. In product development, it is important to…
Tips to Create DFD (Data Flow Diagram)
Data Flow Diagram Data Flow Diagrams (DFDs) are charts that represent the transfer of information between various compartments of a specific system. DFDs are used when designing a project plan because they are easily understood visual aides. Many…
Tips to Create your First WordPress Blog or Website
Pre-Requisites Log in credentials for your hosting control panel FTP log in credentials An FTP client (Filezilla,CoreFTP,WSFTP,etc…) Setting Up Your Tools Because we’re going to be connecting directly to our file space on the sever we need access…