What is SQL Aggregate function

By on February 11, 2015

Let’s learn about SQL aggregate function in this article. Requirement for Aggregrate function is that a data should be grouped  into some sort of group. This function produces records to retrieve one value for whole group and if record is grouped by group clause than only one value will be returned for each group. Also if Read More...


Explanation of a SQL Server Database

Explanation of a SQL Server Database

By on January 22, 2015

SQL stands for Structure Query Language used to maintain records in RDBMS. RDBMS is relational database management system based on relation modal; RDBMS support: sql, ms-sql, and ms-access. In the following chapter we will take a look at the SQL Server Database that includes: Databases, Schemas, and Objects. Database: SQL server stores data in database. Database is Read More...

5 Tips for Boosting Your Code Quality

5 Tips for Boosting Your Code Quality

By on January 19, 2015

How do you achieve better code quality, if not by continuously writing and analyzing the code you write? The fact of the matter is, there are many ways to write code, and there are many languages to do it in. Every language has its own standards and ways of writing good quality code. The thing Read More...


Pinterest wallpaper

5 Pinterest Snippets for Webmasters & Developers

By on January 7, 2015

Pinterest is the number one social media network for sharing images, hands down. Ever since it made its appearance on the web, it has quickly (and swiftly) made its way into the top ten social networks to be a part of, even if data claims that majority of the audience are females. In very recent Read More...


ASP.NET Wallpaper

Examples of Data Normalization in ASP.NET

By on January 6, 2015

In this post we’re going to take a look at how we can use different forms of database normalization to normalize our designs, and overcome their violation. Database normalization is a database design technique that consists of 1NF, 2NF, and 3NF normalization forms. Database normalization ensures no redundancy of data in tables. Lets take a Read More...


ASP.NET Wallpaper

Examples of Data Integrity in ASP.NET

By on January 6, 2015

Data integrity is a composed set of business rules that ensure the reliability, accessibility, consistency and accuracy of data store in a database. Data integrity is an important aspect to the design of a database that store records of any relational model. A database that utilizes rules such as data integrity; can increase performance, accuracy Read More...


haskell

Top 5 Haskell Books to Get You Started

By on January 5, 2015

I’m always intrigued to learn how other people approach their initial “learning to program” steps, during my research over the years, it seems that books are still one of the most favorable way of consuming new content, or in this case – for learning a new programming language. Haskell might seem and sound like a Read More...