Rajat Jaiswal

I am Rajat Jaiswal.
I have around 9 years of industry experience.
I have always found technology and programming to be very interesting and for me, programming is not something that ends when I step out of the office.
I love exploring new stuff and databases amuse me the most.
I started blogging in 2006 on http://rajatjaiswal.blogspot.com and http://indiandotnet.wordpress.com, http://sqlRaaga.blogspot.com
I am quite active on my blogs and often post entries on Microsoft technologies like C#, ASP.NET, SQL Server, Silverlight & Windows Phone 7.

Interests: I am always interested in Microsoft Technology specially asp.net & SQL server. Other than this I love Singing ,dancing and playing musical instruments.

How easy it is to check which statements consuming most of the CPU & RAM–TIP #68

by Rajat Jaiswal

Rajat Jaiswal-337252

Problem:- One of the most important question comes in our mind what is the cause of slow SQL SERVER.
We...

2014-11-01

256 reads

How to take Transaction Log backup ? TIP# 68

by Rajat Jaiswal

Rajat Jaiswal-337252

As we discussed in earlier tips how to take full backup and differential backup now in this tip we will...

2014-10-30

892 reads

How to take differential backup ? TIP #67

by Rajat Jaiswal

Rajat Jaiswal-337252

Friends,
We were discussing backup from last few post. Now lets take a look one more feature of backup which is...

2014-10-28

520 reads

Oh! I forgot When I took last Database Backup ? How to determine this? TIP # 66

by Rajat Jaiswal

Rajat Jaiswal-337252

In last few tips TIP #64 & TIP #65 we get information how to take backup & How to ensure it can...

2014-10-25

285 reads

Blogs

KDA: Echoes of Deception - Onboarding

I’ll walk through the KDA UI and tackle the first challenge before diving into...

Kusto Detective Agency - Intro

While I mostly write about SQL Server, I have a soft spot for Kusto....

The Book of Redgate: Customer Quotes

Many organizations list customer testimonials and quotes on their websites or literature. It makes...

Read the latest Blogs

Forums

How to take a backup as a .bak file while omitting some tables?

Hi Guys, I'm not sure if this is possible or not, but let me...

Life Moves Pretty Fast

By Grant Fritchey

Comments posted to this topic are about the item Life Moves Pretty Fast

Parse XML data from SQL table using temp tables and variables

Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...

Visit the forum

Question of the Day

Multiple Collations

Can I have a collation expression like this in SQL Server 2022?

...
WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS
...

See possible answers