Kapil Singh

Hi friends, I am Kapil Singh Kumawat and I am from Jaipur in Rajasthan, India. I have been working with SQL Server for the last four and a half years and am currently working with Cognizant Technology Solutions as an SQL Server Developer. I have experience in performance tuning, SSIS, data migration, database designing and writing queries. My other interests include travelling, watching football and listening to music.

All authors

SQL Server Execution Plan formats

by Kapil Singh

Kapil Blogs

Execution plan helps in knowing how a query gets executed and troubleshooting a query which is performing poor. In SQL...

2016-09-14

862 reads

Importance of Database Backup In SQL Server

by Kapil Singh

Kapil Blogs

Overview To save any organisation from any big future loss, one needs make a proper strategy or disaster plan that...

2016-09-01

498 reads

Limitation of In-Memory OLTP in SQL Server 2016 – Sp_rename not allowed

by Kapil Singh

Kapil Blogs

Hi friends, one more limitation of In-Memory OLTP is SQL Server 2016 is that sp_rename is not allowed to change...

2016-07-21

516 reads

Getting started with In Memory OLTP in SQL Server 2016 – Part 1

by Kapil Singh

Kapil Blogs

In Memory OLTP (Hekaton) introduced in SQL Server 2014 is a new database engine component which is optimized for OLTP...

2016-07-18

710 reads

Limitation of In-Memory OLTP in SQL 2016 – Create Index is not supported

by Kapil Singh

Kapil Blogs

Hi friends, in this blog I will discuss another limitation of In Memory OLTP in SQL Server 2016. Once you...

2016-07-17

484 reads

Introduction to Row Level Security in SQL 2016

by Kapil Singh

SQLServerCentral.com

SQL Server 2016

In SQL 2016 several new security features gets introduced which will help users to protect their data in many ways. New security feature Row Level Security (RLS) which implements the security inside the database itself, not at application level.