We are mostly creating primary key on column while creating tables, But sometime we also need to have it after creating table or on existing table as per need, So i am sharing the script to add primary key on table....

As per requirement in custom logic we need to require CTE (Common Table Expression) sometime like for the hierarchy, to find duplicate and remove data or for some other stuff. Recently i have used CTE within CTE for one logic and maxrecursion option as ...

As per requirement in custom logic we need to require CTE (Common Table Expression) sometime like for the hierarchy, to find duplicate and remove data or for some other stuff. Recently i have used CTE within CTE for one logic and maxrecursion option ...

I would like to share the script to find open active transactions and sessions at database level, here you can find the same which capture for active transactions initiated by users only. This will results for all the databases but you can make a dat...

I would like to share the script to find open active transactions and sessions at database level, here you can find the same which capture for active transactions initiated by users only. This will results for all the databases but you can make a databa...

Recently i was asked by my friends to delete the files bases on number of files, not based on days. Such a way we can keep number of files every time and rest files get archived. I will give you an example here as i have three folders and want ...

Recently i was asked by my friends to delete the files bases on number of files, not based on days. Such a way we can keep number of files every time and rest files get archived. I will give you an example here as i have three folders and wa...

We have added some enhancements into the comment management module with the goal to stop spam comments on posts....

We just added a new feature that allows you to move a post from one section to another, if you spot a post published in an incorrect category...

As I know database restoration is a best practice on periodically to check and verify database backup copies and issues while restoration due to some stuffs. I have wrote for the database backups as how can we perform full database backup completely ...