Count not null null and empty records.

This is a SQL script of get all Databases Backup in particular folder.

In this blog you will learn about Stored Procedure VS Function.

Search string value in all the column of database.

Sometimes we required to generate a comma separated list of columns values like a list of EmailIDs to send mail. In SQL Server, we can make a comma separated list by using COALESCE as shown in below.

This blog describes to insert values form one database table to the another database table.

This blog defines bulk query in SQL.

Using SQL query we will create the DB user and user associate the db role.

This blog defines how we need to store the db backup using script.

In this blog you will learn about Magic Table in SQL Server.

This blog defines stuff in SQL Server.

In this blog we will learn how to add column in table with default value.

This blog explains OLAP feature in SQL Server.

This blog describes indexes on Table by using sp_helpindex.

In this blog am going to talk about some confusing and most frequent asked commands in SQL.

Schema is a blueprint of how database is constructed and also it's design view.

This blog defines ASCII in SQL Server.

This blog defines subquery in SQL Server.

SQL Server 2012 has a new feature called Columnstore Index. I will explain about this feature that how data is stored when using a Columnstore Index.

This blog defines string function in SQL Server.