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.

SQL Server – Conditions when value of @@error changes

by Kapil Singh

Kapil Blogs

Hi friends, when we do error handling in our SQL code we use different methods like TRY/CATCH, RAISERROR etc. to...

2016-06-02 (first published: 2016-05-24)

1,370 reads

SQL Server – Rollback transaction completely in case of error

by Kapil Singh

Kapil Blogs

Hi friends, I recently found an issue while inserting data into table during transactions that transaction will not completely rollback...

2016-05-26

671 reads

SQL Server – Change in Identity() Property during transactions

by Kapil Singh

Kapil Blogs

Recently while working on a scenario I found that in case of transaction if you are doing insertion operation on...

2016-05-16

565 reads

SQL Server – Row Level Security in SQL 2016 – Part 2

by Kapil Singh

Kapil Blogs

Hi friends, in my previous post we have learnt how to implement Row Level Security feature in our database. You...

2016-05-13 (first published: 2016-05-05)

1,494 reads

Find Unused Database Objects in SQL Server

by Kapil Singh

Kapil Blogs

Overview SQL Server, a relational Database management system is mainly used for storing and retrieving data whenever required by its...

2016-05-12

586 reads

SQL Server – Cleaning Procedure Cache for a particular database

by Kapil Singh

Kapil Blogs

HI friends, most of the time we used DBCC FREEPROCCACHE to clear the procedure cache, clears the specific plan from...

2016-05-11

582 reads

SQL Server – Row Level Security in SQL Server 2016 – Part 3

by Kapil Singh

Kapil Blogs

Hi friends, continuing from the previous post in this post we will learn how to add the blocking predicate to...

2016-05-09

1,020 reads

SQL Server – Row Level security in SQL Server 2016 – Part 1

by Kapil Singh

Kapil Blogs

Hi friends, in SQL 2016 several new security features gets introduced which will help users to protect their data in...

2016-05-03

484 reads

Limitation of In-Memory OLTP in SQL Server 2016 – Merge not supported with memory tables as target

by Kapil Singh

Kapil Blogs

Hi friends, in this post we will discussed another limitation of In-Memory OLTP that in-memory tables as a Target in...

2016-02-12

620 reads

Limitation of In-Memory OLTP in SQL Server 2016 – Seed and Increment value other than 1 not supported

by Kapil Singh

Kapil Blogs

Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment value other than...

2016-02-09

532 reads

Blogs

A Pursuit of Lifelong Learning

By Brian Kelley

The following came across my YouTube feed today. It’s an interview with General James...

Advice I Like: Time and Focus

“You don’t need more time because you already have all the time that you...

Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals

By MarlonRibunal

I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...

Read the latest Blogs

Forums

Layanan BCA KCU KALIMALANG Cs 0823-7497-7784

By layanan 24jam BCA

Wa:082374977784 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit, Kota...

Alamat Telp BCA KCU AMBON Cs 0823-7497-7784

Wa:082374977784 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku 97124

What Did Healthy Look Like?

By Laura Copeland

Comments posted to this topic are about the item What Did Healthy Look Like?

Visit the forum

Question of the Day

DML Trigger Types

How many types of DML triggers are there?

See possible answers