Home > Sai Kirat

SQL NULL Value – Simplified

In SQL, NULL approximately represents an unknown value.An arithmetic operation involving a NULL returns NULL. For example, NULL minus NULL yields NULL, not zero and NULL plus NULL is NULL as well.A boolean comparison between two values involving a NULL returns neither true nor false, but unknown in SQL's three-valued

This Article is TAGGED in , , , , , , . Read more

Web Developer Pre-release Testing Checklist

When we talk about an emerging full-stack web developer, there are certain things that are bound to be missed owing to a developer background and a programmer mindset. A checklist with all things that should be considered before release to QA or launch will help a developer to deliver a not

This Article is TAGGED in , , , , , , . Read more

Database CUBE – simplified

Complicated stuff first -- Cube is a method of storing data in a multidimensional form, generally for reporting purposes. In cubes, data (measures) are categorized by dimensions. Cubes are often pre-summarized across dimensions to drastically improve query time over relational databases.Simple stuff -- Cube is a data storage mechanism beyond

This Article is TAGGED in , , , , , , , . Read more

SQL Keys – Simplified

Keys are generally properties applied to a column of a database table that signify it's worth in that table. Following keys will help you understand the similarities and differences in the various column key options presented by MS SQL Server. In simple words, key in database is something that can

This Article is TAGGED in , , , , , , , , , , . Read more

SQL Indexes – Simplified

Indexing in SQL is a simple topic when it comes to discussion with an SQL Expert, but over the past 10 years as a developer, I have seen people with good knowledge and experience fail to portray the primary meaning of indexes and their types. Indexes help in retrieving data faster

This Article is TAGGED in , , , , , . Read more