-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Rajat Jaiswal-337252

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.

How is easy to work with JSON in SQL SERVER 2016 ?

If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t worry you might use sooner than later. JSON is kind of ecosystem which is most popular in the various area for exchanging the data. If you talk about charting solution,…

Read more

0 comments, 826 reads

Posted in Rajat Jaiswal-337252 on 28 March 2017

How easy it is to implement Row Level Security in SQL SERVER 2016 ?

To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.
Problem 1 Suppose, you have a Multi-tenant e-commerce website and different companies registered on your website and you have centralized single database for all the client. Now as a product owner it is your responsibility that one tenant’s…

Read more

0 comments, 307 reads

Posted in Rajat Jaiswal-337252 on 27 March 2017

Why Do People Think Dynamic Data Masking is a Good Idea? - SQL SERVER 2016 #5

Data security is always one of the important points which can not be ignored. Nowadays if you are working for any specific domain like Banking or Healthcare then there are a lot of compliance rules which you have to follow.
Data Masking is one of the best ways to help…

Read more

0 comments, 459 reads

Posted in Rajat Jaiswal-337252 on 27 November 2016

How DATEDIFF_BIG a new feature of SQL SERVER 2016 Can Keep You Out of Trouble

In the series of SQL SERVER 2016, this is a new post. in this post, we will discuss DATEDIFF_BIG and how it is helpful.
So, before jumping into directly in technical details, we all know that time is very important and every second valuable and countable but sometimes every microsecond…

Read more

2 comments, 393 reads

Posted in Rajat Jaiswal-337252 on 22 October 2016

If You Read One Article About Split String in SQL SERVER 2016s Read this One #3

In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have a comma or other separator string and if you have to split it by separator field then for such task  in previous SQL SERVER versions either you will write a…

Read more

1 comments, 720 reads

Posted in Rajat Jaiswal-337252 on 22 October 2016

Do you know Compress & Decompress function in SQL SERVER 2016 ?

This is another article in the series of SQL SERVER 2016 Journey . I am pretty much sure you might aware of Gzip Compression algorithm. If not then try  this link.

So, SQL SERVER 2016 introduce this two awesome functions for Compress & Decompress the data.
Before…

Read more

2 comments, 488 reads

Posted in Rajat Jaiswal-337252 on 16 October 2016

Here Come New Ideas for DROP IF EXISTS in SQL SERVER

In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a new cool feature which introduced in SQL SERVER 2016 which is DROP IF EXISTS (DIE) .
In our development many times it happens that we need to drop a…

Read more

0 comments, 422 reads

Posted in Rajat Jaiswal-337252 on 15 October 2016

9 Amazing features of SQL SERVER 2016


Although, I know I am bit late to share this thing on our blog but it says in Indian proverb “Der aai durust aai” means it’s OK you came late but you came that is more important.
Anyways, so you all might aware that Microsoft launched SQL SERVER 2016 officially…

Read more

2 comments, 504 reads

Posted in Rajat Jaiswal-337252 on 11 October 2016

MS Build 2016 Live Streaming

Watch Live streaming of MS BUILD 2016

Read more

0 comments, 379 reads

Posted in Rajat Jaiswal-337252 on 29 March 2016

The Unconventional Guide to How to Implement Lookup Transformations TIP #124

This is one the articles in the series of step by step SSIS tutorial. In this post, we are going to understand Lookup transformation and also see an example to implement Lookup transformation in 8 easy steps.
Now, Lookup transformation is one of the interesting transformation which is used…

Read more

2 comments, 622 reads

Posted in Rajat Jaiswal-337252 on 20 December 2015

How to do Step by Step Merge Join Transformations - #123

In last post tip #122, We discussed Merge transformation. Now in this tip, we are going to discuss Merge Join. Although, it might be confusing sometimes Merge & Merge Join. So, let me explain it here.
As explain earlier merge is like a union operation in…

Read more

5 comments, 1,969 reads

Posted in Rajat Jaiswal-337252 on 18 December 2015

Step by Step Merge transformation control in SSIS TIP #122

In the Series of Zero to hero in SSIS  this is another post. In this post we are going to discuss Merge transformation control.

By the name it is clear that Merge transformation do some merge related task. For example suppose there is two sources which are source1…

Read more

0 comments, 517 reads

Posted in Rajat Jaiswal-337252 on 13 December 2015

Step by Step SSIS Multicast Transformation TIP #121

Dear Friends,

This is another post in the series of step by step SSIS ,Zero to hero series. In this post we will discuss another transformation control which is Multicast transformation.

Multicast is a way which help us to provide multiple copy of same source data for different… Read more

0 comments, 852 reads

Posted in Rajat Jaiswal-337252 on 18 October 2015

Step by Step SSIS–Derived Column Transformation TIP # 120

Dear Friends,

In the series of Step by Step SSIS , Zero to Hero in SSIS this is another post in which we will try to understand what is Derived Column Transformation.

Let’s understand this by a real world example. Suppose, we are a shop keeper and our work is… Read more

1 comments, 2,205 reads

Posted in Rajat Jaiswal-337252 on 18 October 2015

Step by Step SSIS–Union ALL tip # 119

 

Dear All,

In the series of  zero to hero SSIS series this is one of the simplest transformation control which known as UNION ALL. 

As you might aware UNION in general term  which means collective. In SSIS UNION all control is doing the same task.

It collect all… Read more

0 comments, 644 reads

Posted in Rajat Jaiswal-337252 on 17 October 2015

Step by Step SSIS–Aggregate Transformation TIP #118

 

Dear Friends,

In the series of step by step SSIS tutorial this is another post. In this post we will see Aggregate Transformation. I am pretty much sure you are aware of aggregation. Although , Just wanted to share that aggregation operation in generally memory expensive operation.

So,… Read more

0 comments, 1,462 reads

Posted in Rajat Jaiswal-337252 on 2 October 2015

Step by Step SSIS - Conditional Split Transformation TIP #117

In the series of Zero to Hero in SSIS this is our next post. In this post we will see Conditional Split transformation.

I am pretty much sure that by the name you got some impression what it would be.

So, a Conditional Split Transformation is a way by… Read more

0 comments, 1,517 reads

Posted in Rajat Jaiswal-337252 on 21 September 2015

Step by Step SSIS learning What Data Conversion use in SSIS ? TIP#116

Dear Friends,

In the series of step by step learning of SSIS this is part #6 in which we are going to learn a new control Data Conversion.  I am sure by the name it clear that this control will be use when we require data type conversion of… Read more

1 comments, 638 reads

Posted in Rajat Jaiswal-337252 on 13 September 2015

How to use SORT control in SSIS ? TIP #115

Dear Friends,

In the series of Learn SSIS step by step this is the 5th post. Now from this post we are going to use each transformation control one by one.

So, lets start with simplest one transformation control which is “Sort”.

By the name it is clear data it… Read more

2 comments, 1,542 reads

Posted in Rajat Jaiswal-337252 on 12 September 2015

Older posts