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

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

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 5.00

Hosted Services
Azure	MebhiChokiDAR – Tweet Sentiment Analysis and More Using Microsoft Flow 22 Mar 2019 Updated: 22 Mar 2019 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 3,940 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	Indian Prime Minister 2019 Live Poll – Analysis using Microsoft Form, Microsoft Flow and Power BI Live 30 Mar 2019 Updated: 30 Mar 2019 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 3,521 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	Web Scraping for Analysis using the Microsoft Power BI Tool 9 Mar 2019 Updated: 9 Mar 2019 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 9,860 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
	Why Do People Think Learn Step by Step PIVOT Transformation is a Good Idea? TIP #125 [Technical Blog] 25 Jan 2016 Updated: 25 Jan 2016 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 3,460 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.
	The Unconventional Guide to How to Implement Lookup Transformations TIP #124 [Technical Blog] 25 Jan 2016 Updated: 25 Jan 2016 Rating: 3.00/5 Votes: 2 Popularity: 0.90 Licence: CPOL Views: 4,150 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.
	Step by Step SSIS–Derived Column Transformation TIP # 120 [Technical Blog] 26 Jan 2016 Updated: 26 Jan 2016 Rating: 1.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 12,011 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.
	Interview Question - How to Conditionally Sort the Records? TIP# 43 [Technical Blog] 14 Sep 2014 Updated: 14 Sep 2014 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 4,970 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. How to conditionally sort records
	What is TVP (Table Value Parameter) & How To Use It? TIP #57 [Technical Blog] 11 Oct 2014 Updated: 11 Oct 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 6,630 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Table value parameter and how to use it
	What is Collection & How to Manage a Collection in PowerApps ? [Technical Blog] 28 Apr 2018 Updated: 28 Apr 2018 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 26,024 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. What is collection & how to manage it in PowerApps?
Database Development
	A Hidden Feature sp_MSforeachtable–Run on Entire Tables of a Database - TIP# 51 [Technical Blog] 6 Oct 2014 Updated: 6 Oct 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 5,500 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	Contained Database – A New Feature in SQL SERVER 2012 TIP #81 [Technical Blog] 26 Feb 2015 Updated: 26 Feb 2015 Rating: 4.50/5 Votes: 2 Popularity: 1.35 Licence: CPOL Views: 6,900 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Contained Database–A new feature in SQL SERVER 2012 TIP #81
	How Easily You Can Unpivot the Pivot Data in SQL Server? [Technical Blog] 22 Apr 2018 Updated: 22 Apr 2018 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 3,130 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. How to easily unpivot pivot data in SQL Server
Enterprise
	How to Configure Memory in SQL SERVER? TIP#83 [Technical Blog] 26 Feb 2015 Updated: 26 Feb 2015 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 5,670 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. How to configure memory in SQL Server? Tip #83
Hosted Services
Azure	A Simple Way to Check Vulnerability Status of your SQL SERVER Database [Technical Blog] 10 Mar 2019 Updated: 10 Mar 2019 Rating: 4.68/5 Votes: 6 Popularity: 3.64 Licence: CPOL Views: 4,601 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
	Import PDF Data in Power BI–Really Excited to See [Technical Blog] 8 Mar 2019 Updated: 8 Mar 2019 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 5,761 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. How to import PDF data in Power BI
PowerApps
	Learn How To Start PowerApps Controls [Technical Blog] 22 Apr 2018 Updated: 22 Apr 2018 Rating: 2.67/5 Votes: 2 Popularity: 0.80 Licence: CPOL Views: 4,680 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. How to start PowerApps controls
	The A – Z Guide Of Create the First powerApps [Technical Blog] 22 Apr 2018 Updated: 22 Apr 2018 Rating: 2.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 5,060 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. In this post, we are going to create our first PowerApp.
	It’s All About (the) PowerApps Templates [Technical Blog] 22 Apr 2018 Updated: 22 Apr 2018 Rating: 1.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 10,472 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#	A Beginner step towards Alibaba Cloud OSS (Object storage services) [Technical Blog] 7 Oct 2019 Updated: 7 Oct 2019 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 1,550 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	Do You Know filter, map, reduce in JavaScript? [Technical Blog] 22 Apr 2018 Updated: 22 Apr 2018 Rating: 4.15/5 Votes: 4 Popularity: 2.50 Licence: CPOL Views: 6,722 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Filter, map & reduce function in JavaScript
SQL	How to do Step by Step Merge Join Transformations – #123 [Technical Blog] 25 Jan 2016 Updated: 25 Jan 2016 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 4,950 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Step by step merge join transformations
	Good to Know SQL JARGON – An Interview TIP #56 [Technical Blog] 9 Oct 2014 Updated: 9 Oct 2014 Rating: 4.67/5 Votes: 5 Popularity: 3.26 Licence: CPOL Views: 6,850 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Good to know SQL jargon
	Find First Not Null Value From Different Columns: TIP# 47 [Technical Blog] 14 Sep 2014 Updated: 14 Sep 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 4,440 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Find first not null value from different columns
	Everywhere JSON so why not in SQL SERVER–New feature in SQL SERVER 2016 [Technical Blog] 23 Apr 2018 Updated: 23 Apr 2018 Rating: 4.93/5 Votes: 6 Popularity: 3.84 Licence: CPOL Views: 14,491 Bookmarked: 13 Downloaded: 0 Please Sign up or sign in to vote. New feature in SQL Server 2016
	First_value & Last_Value According to Group Set is that Easy? Tip# 44 [Technical Blog] 13 Sep 2014 Updated: 13 Sep 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 5,030 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
	ROW LEVEL Security SQL SERVER 2016 [Technical Blog] 22 Apr 2018 Updated: 22 Apr 2018 Rating: 5.00/5 Votes: 5 Popularity: 3.49 Licence: CPOL Views: 5,881 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. Row Level security SQL Server 2016
SSIS
	Step by Step SSIS – Conditional Split Transformation TIP #117 [Technical Blog] 26 Jan 2016 Updated: 26 Jan 2016 Rating: 1.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 4,290 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Conditional split transformation
Web Development
HTML	FIFA World Cup 2014 with Angular.js & ASP.NET – Part II [Technical Blog] 24 Jun 2014 Updated: 24 Jun 2014 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 8,511 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	A Unique Feature of SQL SERVER Loop with Go Statement [Tip/Trick] 10 Nov 2013 Updated: 10 Nov 2013 Rating: 4.57/5 Votes: 6 Popularity: 3.56 Licence: CPOL Views: 9,020 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. A unique feature of SQL SERVER Loop with Go statement
	How to find column or text in entire stored procedure of a database? [Tip/Trick] 11 Nov 2013 Updated: 11 Nov 2013 Rating: 4.91/5 Votes: 6 Popularity: 3.82 Licence: CPOL Views: 11,630 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

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.

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

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

Average article rating: 5.00

Hosted Services

Productivity Apps and Services

Web Development

Average blogs rating: 3.93

All Topics

Database Development

Enterprise

Hosted Services

PDF

PowerApps

Programming Languages

Security

SSIS

Web Development

Average tips rating: 4.74

Database Development

Average reference rating:

Average project rating: