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 to determine table dependencies ? TIP # 86

by Rajat Jaiswal

Rajat Jaiswal-337252

Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which ...

2015-02-24

517 reads

How to Encrypt password in SQL Server ? TIP #87

by Rajat Jaiswal

Rajat Jaiswal-337252

Security is always a concern for every database developer. How to secure valuable information is one of the major and...

2015-02-24

420 reads

“sp_helptext“ – Useful command to view detail TIP #85

by Rajat Jaiswal

Rajat Jaiswal-337252

It might be already known to you but I thought for sharing because I frequently use this command and it...

2015-02-22

384 reads

Easy way to diagnose SQL Server “sp_Who2” TIP #84

by Rajat Jaiswal

Rajat Jaiswal-337252

Why the SQL Server is running slow ?
What are the processes running currently on SQL SERVER instance ?
Many other like...

2015-02-19

433 reads

How to configure memory in SQL SERVER ? TIP#83

by Rajat Jaiswal

Rajat Jaiswal-337252

One of the good sentence I remember “When someone has teeth he/she is not having nuts and when someone has...

2015-02-12

362 reads

How to Enable / Disable Xp_cmdShell in SQL SERVER? TIP #82

by Rajat Jaiswal

Rajat Jaiswal-337252

Friends,
Sometimes it might be possible that you have to run dos command from SQL SERVER. In such situation you have...

2015-02-05

26,390 reads

Contained Database–A new feature in SQL SERVER 2012 TIP #81

by Rajat Jaiswal

Rajat Jaiswal-337252

While working on a project sometimes it happened that we need to shift the database from one server to another...

2015-01-02

488 reads

How to insert value in Identity column ? TIP #80

by Rajat Jaiswal

Rajat Jaiswal-337252

Happy new year 2015 .
Suppose you have a source table and one destination table (Which is exact replica of source...

2015-01-01

273 reads

Change Data Capture (CDC)–An easy way to track data changes of a database–TIP #79

by Rajat Jaiswal

Rajat Jaiswal-337252

In last TIP #78 we have discussed Change tracker (CT) which was introduced in SQL SERVER 2008. CT feature only...

2014-12-27

1,033 reads

Change Tracking–an easy way to track your changes TIP#78

by Rajat Jaiswal

Rajat Jaiswal-337252

I am pretty much sure by the title of this post you had idea of the post content. Although I...

2014-12-21

686 reads

Blogs

Advice I Like: Art

Superheroes and saints never make art. Only imperfect beings can make art because art...

Why Optimize CPU for RDS SQL Server is a game changer

By anup.varier@gmail.com

One feature that I have been waiting for years! The new announcement around optimize...

Performance tuning KubeVirt for SQL Server

By Andrew Pruski

Following on from my last post about Getting Started With KubeVirt & SQL Server,...

Read the latest Blogs

Forums

Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL

Comments posted to this topic are about the item Think LSNs Are Unique? Think...

A Big PK

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Big PK

The AI Bubble and the Weak Foundation Beam

Comments posted to this topic are about the item The AI Bubble and the...

Visit the forum

Question of the Day

A Big PK

In SQL Server 2025, how many columns can be included in a Primary Key constraint?

See possible answers