Click here to Skip to main content
15,075,353 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
Posted: 22 Mar 2019   Updated: 22 Mar 2019   Views: 2,770   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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
Posted: 30 Mar 2019   Updated: 30 Mar 2019   Views: 2,921   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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
Posted: 9 Mar 2019   Updated: 9 Mar 2019   Views: 8,000   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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
Posted: 25 Jan 2016   Updated: 25 Jan 2016   Views: 3,280   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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.
Posted: 25 Jan 2016   Updated: 25 Jan 2016   Views: 3,980   Rating: 3.00/5    Votes: 2   Popularity: 0.90
Licence: The Code Project Open License (CPOL)      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.
Posted: 26 Jan 2016   Updated: 26 Jan 2016   Views: 10,681   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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.
Posted: 14 Sep 2014   Updated: 14 Sep 2014   Views: 4,650   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
How to conditionally sort records
Posted: 11 Oct 2014   Updated: 11 Oct 2014   Views: 6,170   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Table value parameter and how to use it
Posted: 28 Apr 2018   Updated: 28 Apr 2018   Views: 23,754   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
What is collection & how to manage it in PowerApps?
Database Development
Posted: 6 Oct 2014   Updated: 6 Oct 2014   Views: 4,910   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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
Posted: 26 Feb 2015   Updated: 26 Feb 2015   Views: 6,370   Rating: 4.50/5    Votes: 2   Popularity: 1.35
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
Contained Database–A new feature in SQL SERVER 2012 TIP #81
Posted: 22 Apr 2018   Updated: 22 Apr 2018   Views: 2,770   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
How to easily unpivot pivot data in SQL Server
Enterprise
Posted: 26 Feb 2015   Updated: 26 Feb 2015   Views: 5,240   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
How to configure memory in SQL Server? Tip #83
Hosted Services
Azure
Posted: 10 Mar 2019   Updated: 10 Mar 2019   Views: 4,030   Rating: 4.68/5    Votes: 6   Popularity: 3.64
Licence: The Code Project Open License (CPOL)      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
Posted: 8 Mar 2019   Updated: 8 Mar 2019   Views: 4,551   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
How to import PDF data in Power BI
PowerApps
Posted: 22 Apr 2018   Updated: 22 Apr 2018   Views: 4,090   Rating: 2.67/5    Votes: 2   Popularity: 0.80
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
How to start PowerApps controls
Posted: 22 Apr 2018   Updated: 22 Apr 2018   Views: 4,500   Rating: 2.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
In this post, we are going to create our first PowerApp.
Posted: 22 Apr 2018   Updated: 22 Apr 2018   Views: 8,902   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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#
Posted: 7 Oct 2019   Updated: 7 Oct 2019   Views: 1,040   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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
Posted: 22 Apr 2018   Updated: 22 Apr 2018   Views: 5,662   Rating: 4.15/5    Votes: 4   Popularity: 2.50
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Filter, map & reduce function in JavaScript
SQL
Posted: 25 Jan 2016   Updated: 25 Jan 2016   Views: 4,680   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Step by step merge join transformations
Posted: 9 Oct 2014   Updated: 9 Oct 2014   Views: 6,300   Rating: 4.67/5    Votes: 5   Popularity: 3.26
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Good to know SQL jargon
Posted: 14 Sep 2014   Updated: 14 Sep 2014   Views: 4,080   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Find first not null value from different columns
Posted: 23 Apr 2018   Updated: 23 Apr 2018   Views: 13,231   Rating: 4.93/5    Votes: 6   Popularity: 3.84
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 0
Please Sign up or sign in to vote.
New feature in SQL Server 2016
Posted: 13 Sep 2014   Updated: 13 Sep 2014   Views: 4,690   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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
Posted: 22 Apr 2018   Updated: 22 Apr 2018   Views: 5,311   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
Row Level security SQL Server 2016
SSIS
Posted: 26 Jan 2016   Updated: 26 Jan 2016   Views: 4,000   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Conditional split transformation
Web Development
HTML
Posted: 24 Jun 2014   Updated: 24 Jun 2014   Views: 7,881   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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
Posted: 10 Nov 2013   Updated: 10 Nov 2013   Views: 8,650   Rating: 4.57/5    Votes: 6   Popularity: 3.56
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
A unique feature of SQL SERVER Loop with Go statement
Posted: 11 Nov 2013   Updated: 11 Nov 2013   Views: 10,570   Rating: 4.91/5    Votes: 6   Popularity: 3.82
Licence: The Code Project Open License (CPOL)      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.

Rajat-Indiandotnet
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.