Click here to Skip to main content
15,868,016 members

Articles by Rajat-Indiandotnet (Articles: 3, Technical Blogs: 25, Tip/Tricks: 2)

Articles: 3, Technical Blogs: 25, Tip/Tricks: 2

RSS Feed

Average article rating: 5.00

Hosted Services
Azure
22 Mar 2019   Updated: 22 Mar 2019   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 4,900     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
How to do sentiment analysis using few clicks and see live graphical representation using Power BI live feed
Productivity Apps and Services
Microsoft Office
30 Mar 2019   Updated: 30 Mar 2019   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 4,051     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Live Poll – Analysis using Microsoft Form, Microsoft Flow and Power BI Live
Web Development
HTML
9 Mar 2019   Updated: 9 Mar 2019   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 10,680     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Web scraping for analysis using the Microsoft Power BI tool

Average blogs rating: 3.93

All Topics
25 Jan 2016   Updated: 25 Jan 2016   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 3,580     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
In this post, we will try to implement PIVOT transformation in a few easy steps.
25 Jan 2016   Updated: 25 Jan 2016   Rating: 3.00/5    Votes: 2   Popularity: 0.90
Licence: CPOL    Views: 4,280     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
In this post, we are going to understand Lookup transformation and also see an example of how to implement Lookup transformation in 8 easy steps.
26 Jan 2016   Updated: 26 Jan 2016   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 12,791     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
In this post, we will try to understand what is Derived Column Transformation with the help of a real world example.
14 Sep 2014   Updated: 14 Sep 2014   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 5,140     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
How to conditionally sort records
11 Oct 2014   Updated: 11 Oct 2014   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 6,960     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Table value parameter and how to use it
28 Apr 2018   Updated: 28 Apr 2018   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 26,976     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
What is collection & how to manage it in PowerApps?
Database Development
6 Oct 2014   Updated: 6 Oct 2014   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 5,890     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
A Hidden Feature sp_MSforeachtable–Run on Entire Tables of a Database - TIP# 51
SQL Server
26 Feb 2015   Updated: 26 Feb 2015   Rating: 4.50/5    Votes: 2   Popularity: 1.35
Licence: CPOL    Views: 7,380     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
Contained Database–A new feature in SQL SERVER 2012 TIP #81
22 Apr 2018   Updated: 22 Apr 2018   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 3,450     Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
How to easily unpivot pivot data in SQL Server
Enterprise
26 Feb 2015   Updated: 26 Feb 2015   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 5,920     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
How to configure memory in SQL Server? Tip #83
Hosted Services
Azure
10 Mar 2019   Updated: 10 Mar 2019   Rating: 4.68/5    Votes: 6   Popularity: 3.64
Licence: CPOL    Views: 4,901     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
As a product owner, you always worried about the different security aspects of your application and SQL Server Database is one of the main important parts for which you might worry.
PDF
8 Mar 2019   Updated: 8 Mar 2019   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 6,301     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
How to import PDF data in Power BI
PowerApps
22 Apr 2018   Updated: 22 Apr 2018   Rating: 2.67/5    Votes: 2   Popularity: 0.80
Licence: CPOL    Views: 5,010     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
How to start PowerApps controls
22 Apr 2018   Updated: 22 Apr 2018   Rating: 2.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 5,330     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
In this post, we are going to create our first PowerApp.
22 Apr 2018   Updated: 22 Apr 2018   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 11,452     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
In this article, we will see different inbuilt templates Apps which give us confidence about what the PowerApps can do.
Programming Languages
C#
7 Oct 2019   Updated: 7 Oct 2019   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 1,910     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Objective: In this post, we, try to understand what is Object Storage Service in Alibaba Cloud and how to create your first Object Storage Service. We will try to understand the different business scenario where we can utilize this OSS service.
Javascript
22 Apr 2018   Updated: 22 Apr 2018   Rating: 4.15/5    Votes: 4   Popularity: 2.50
Licence: CPOL    Views: 7,372     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Filter, map & reduce function in JavaScript
SQL
25 Jan 2016   Updated: 25 Jan 2016   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 5,180     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Step by step merge join transformations
9 Oct 2014   Updated: 9 Oct 2014   Rating: 4.67/5    Votes: 5   Popularity: 3.26
Licence: CPOL    Views: 7,130     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Good to know SQL jargon
14 Sep 2014   Updated: 14 Sep 2014   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 4,770     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Find first not null value from different columns
23 Apr 2018   Updated: 23 Apr 2018   Rating: 4.93/5    Votes: 6   Popularity: 3.84
Licence: CPOL    Views: 15,281     Bookmarked: 13   Downloaded: 0
Please Sign up or sign in to vote.
New feature in SQL Server 2016
13 Sep 2014   Updated: 13 Sep 2014   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 5,270     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
First_value & Last_Value according to group set is that easy? Tip# 44
Security
22 Apr 2018   Updated: 22 Apr 2018   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: CPOL    Views: 6,341     Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
Row Level security SQL Server 2016
SSIS
26 Jan 2016   Updated: 26 Jan 2016   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 4,620     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Conditional split transformation
Web Development
HTML
24 Jun 2014   Updated: 24 Jun 2014   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 9,071     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
FIFA World Cup 2014 with Angular.js & ASP.NET - Part II

Average tips rating: 4.74

Database Development
SQL Server
10 Nov 2013   Updated: 10 Nov 2013   Rating: 4.57/5    Votes: 6   Popularity: 3.56
Licence: CPOL    Views: 9,280     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
A unique feature of SQL SERVER Loop with Go statement
11 Nov 2013   Updated: 11 Nov 2013   Rating: 4.91/5    Votes: 6   Popularity: 3.82
Licence: CPOL    Views: 12,430     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Find column or Text in entire stored procedure

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.
Team Leader
India India
I am Rajat Jaiswal from India. I am working as a Technology specialist in one of the reputed company in India with 12+ years of experience. I am a Microsoft Data Platform MVP & Alibaba Cloud MVP.
I have always had an affinity to learn something new in technology. Database, Web development, Cloud computing are the areas of my interests always.
I have been a regular contributor to technologies with more than 300+ tips. Learning & Sharing is one of my aims always. Writing blogs, delivering sessions, helping on forums is my hobby.