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.

Limitation of In-Memory OLTP in SQL Server 2016 – TRUNCATE table not supported

by Kapil Singh

Kapil Blogs

Hi friends, another limitation that we will discussed is TRUNCATE table command is not supported with memory optimized tables. Let’s...

2016-02-03

1,390 reads

Limitation of In-Memory OLTP in SQL Server 2016 – LOB datatypes not supported

by Kapil Singh

Kapil Blogs

Hi friends, Wish you all a very Happy New Year. This is my first blog of 2016 and starting it...

2016-02-01

544 reads

SQL Server – Check the status of active Trace Flags

by Kapil Singh

Kapil Blogs

Hi friends, few days back I was exploring data masking features introduced in SQL Server 2016. I got stuck in...

2015-12-14

552 reads

SQL Server – Trace flag changes in Dynamic data masking in SQL Server 2016 CTP 3.0

by Kapil Singh

Kapil Blogs

Hi friends, In new CTP version SQL server 2016 which is 3.0, I was trying to explore the new masking...

2015-12-10

485 reads

SQL SERVER – Random function in Dynamic Data Masking in SQL Server 2016 CTP 3

by Kapil Singh

Kapil Blogs

Hi friends, With new CTP version of SQL Server 2016 many new functionality are added and modified. As with introduction...

2015-12-08

579 reads

SQL Server – DROP IF EXISTS in SQL Server 2016

by Kapil Singh

Kapil Blogs

Hi friends, in SQL Server 2016 to check the existence of the object a new optional clause IF EXISTS gets...

2015-11-27

1,134 reads

Steps to create SQL database at Azure

by Kapil Singh

Kapil Blogs

Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into...

2015-11-26

876 reads

Steps to install SQL Server CTP 3 on Windows Azure

by Kapil Singh

Kapil Blogs

Hi friends, SQL Server 2016 CTP 3 is available now and it can be downloaded on Azure. So I tried...

2015-11-23

493 reads

How Client Statistics helps in improving performance in SQL Server

by Kapil Singh

Kapil Blogs

Client Statistics is SQL Server data tool which is very helpful in determining the statistics that how much data received...

2015-11-17

492 reads

SQL Server – Columnstore Index creation error: A columnstore index cannot have INCLUDED columns

by Kapil Singh

Kapil Blogs

Hi friends, in my previous blog we learnt that sparse column cannot be part of columnstore index. In this blog...

2015-10-26

607 reads

Blogs

Questions and Answers from Running a Local LLM

I had a few random questions from my Running a Local LLM on Your...

Overview of Claude AI Models: Which One to Choose?

For those entering the AI space whether professionally or personally I wanted to give...

Houston AI-Lytics 2026–Powerpoint Slides

Thanks to everyone for attending my session on running a Local LLM. If you...

Read the latest Blogs

Forums

SSIS package failing intermittently on last Excel Component

Good Afternoon, I have a Job which "fires" off an SSIS package (that is...

T-SQL in SQL Server 2025: JSON_ARRAYAGG

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Spring Connections and Learning at PASS On Tour

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Spring Connections and Learning at...

Visit the forum

Question of the Day

Multiple Sequence Values

How do I easily get the next 12 sequence values from a sequence object?

See possible answers