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

550 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

554 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

587 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,139 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

500 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

494 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

615 reads

Blogs

Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables

By Eduardo Pivaral

Every PostgreSQL migration eventually hits the same fork in the road. The database is...

A Spread of Vacation

I’m off on vacation today. Which is a little weird as I just got...

How AgentDBA Identifies Backup Failures

Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...

Read the latest Blogs

Forums

Have you done a Mid year check in?

Comments posted to this topic are about the item Have you done a Mid...

From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline

By Cláudio Tereso

Comments posted to this topic are about the item From SQL Server On-Premises to...

Independence Day 2026

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Independence Day 2026

Visit the forum

Question of the Day

Independence Day 2026

In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.

See possible answers