My review on Redmi Note 10 Pro

 I've been using this phone just about 2/3 weeks (will add here if I found something striking in the coming days ;-) ). So, my review will be based on that short period of time. My last phone was Redmi note 4 which was working fine over three & half years and suddenly the battery of Redmi Note 4 working poorly. Means from 40% to zero within moment and hence that phone was far from usable. Therefore I bought this after some research . So though my last phone is quite old model specially where the technology is rapidly evolving, still I try to compare few things with Redmi Note 4 with Note 10 (as some of the features I found is not as good in this newer version of Redmi note that was pretty efficient in the older version)

First of all I'm not a gamer and in Great Indian sale from Amazon, I got this phone just over 15k (clubbing with my credit card cashback offer). Though 2 week is very short period, however I can say around 15k it's one of the best.
The only difference between Redmi note 10 pro & Redmi note 10 pro max is the camera. And again I'm an old fashioned person who still respect DSLR than a mobile phone , so only for 108 MP-I prefer not to spend extra 3k (approx.).
Still for the photo lover, I am attaching a photo that I took with Redmi note 10 pro in night mode, so people can see the quality by themselves.
Performance is decent. However I saw for a long call, screen sometimes suddenly become black and for calls like customer care where in between you may need to use keypad , it's irritating.
Battery : with my above average internet usage e.g. WhatsApp, Twitter etc. last around 24 hours.
Please note 2 points as depicted below:
1) I switch off the GPS once, when it not needed.
2) My blue-tooth generally on as I need to use my wireless earbud.
Now I'm disappointed about couple of things when I am comparing a MAR21 launch with very old model Redmi note 4.
1. When charging (though it takes around 2 hours even in so called fast charging mode), the phone becomes quite hot. My Redmi Note 4 till today is less than 50% hot, compared to this new model and that also (without the so called fast charging feature) been fully charged in less than 2 hours.
2. For the same Vodafone sim, which I pulled out from my old Redmi note 4;I suddenly found more blind places in my locality. The internet signal which may be slow for Note 4, but simply not working for Redmi Note 10 pro. (Like inside many shop in the same locality now my GPAY is not working which worked with some slowness in the older model).
3. In the same Realme earbud , sometimes I saw the blue-tooth connectivity is having the issue in this model  which was never in Redmi Note 4.
So my conclusion: if you are like me, who feel uncomfortable for carrying really costly devices in their pocket, and if your budget is around 15/16k, you can use it.
If I get the same phone in 20k, I'd give 3 star(average) - whereas in 15k price range, I'll comfortably rate above average!

Molecular Story - Behind the mask (Bengali)

অনুগল্প ৩০০ -৩৫০ শব্দের মধ্যে লেখা বেশ চ্যালেঞ্জিং | অনেকটা স্কুল লাইফের প্রেসির মতো - যেখানে খুব সীমাবদ্ধ শব্দসংখ্যা মধ্যে একটি জিনিস কমপ্লিট করতে হবে ! ধন্যবাদ সাহিত্য কালচার টিমকে আমার অণুগল্পটি তাদের ইম্যাগে নির্বাচিত 

করার জন্য  

https://sahityacultureweb.blogspot.com/

Bengali Story - FAGUNER RONG

 শুভ দোলযাত্রা ! মহাভারতের চরিত্রগুলো যেন একেকটি হীরাখন্ডের মতো - পলকাটা ! তাঁদের দিকে এল ফেললে বিভন্ন রঙের আলো বিচ্ছুরিত হয় - বিভিন্ন মানবিক ঘাট প্রতিঘাত সমেত | এরকমই একটি মহান চরিত্র কে নিয়ে একটি ফিকশনাল গল্প 

https://kathakahini1.blogspot.com/2021/04/blog-post_37.html

ADF destination folder in ADLS based on YYYY>MM>>DD hierarchy

 @concat('Output','/',formatDateTime(utcnow(),'yyyy'),'/',formatDateTime(utcnow(),'MM'),'/', formatDateTime(utcnow(),'dd'))

The web-series I loved in Amazon Prime India - part 2(will keep updating)

On the top of my last post - I like to add couple of more here and will update the list as there is unfortunately no timeline of lifting the lock-down

1. Made in Heaven - good content somehow feeling not all the dots been connected properly. In some cases spoils due to bit of overacting : According to me it's 8 out of 10
2. PANCHAYAT - Very nice depiction of rural India in terms of humor (sarcasms ?). Lots of people are happy to see OLD version of Ramayana Mahabharata etc. in TV,I like 2 request them 2 see PANCHAYAT which correctly shows the difference between India and Hindustan. According to me it's 9 out of 10
3. PUSHPAVALI - Enjoyed but yeah somehow feel little over-dramatic. Yet to watch the part 2. After watching the part 2 will add the score card :-)

The web-series I loved in Amazon Prime - part 1

Due to lock down in my flat for Corona Virus outbreak, I explored Amazon Prime series.
Earlier due to lack of patience I didn't try many but now as no office journey, working from home hence tried to watch those series.
I know already there are much elaborated reviews with pictures videos for most of them but here I like to share my own views: (I list as per the order I've seen those in last couple of months)
The family man :  It's related with one of the most talked subject matter nowadays in mainstream Bollywood movies viz. sleeping cells, intelligence, terrorism still what I liked the courage of the director of this movie to depict the agony of cops/intelligence persons after a fake or misunderstood encounter. This is the topic where lots of the film side stepped. According to me it's 8 out of 10

The forgotten army : Lots of movies deal with the Netaji Subhas Bose, his life, mysterious death (?) etc but this movie deals the life of INA and their contribution from a different angle. Kudos to the director. IMO - it's 7.5 out of 10.

Inside Edge : Both the session deals with the shadow behind the light in Premier T20 league in India - little larger than life. 7 out of 10 

Mirzapur - A crime story, gang war etc in a small city. A topic which has been touched by quite a few in the mainstream Bollywood but the screenplay, proper editing and acting is the salient feature of this movie. Most of the actors , definitely Pankaj Tripathy - really make this series a treat to watch. Will wait for season 2. According to me it's 8.5 out of 10

Hostel Daze: Enjoyed thoroughly and believe will enjoy everyone who knows about the hostel life of engineering students. Can't wait for the season 2. Can anyone please update? According to me it's 9 out of 10

Will update the list as will see more series

Azure Data Factory: Lookup and foreach example

From the data-side we are having view either in on premise SQL DB/ Azure SQL db.
From that view we'll be creating a SP say GetSalesInfo that is fetching the records.
===================================================

Alter proc demo.GetSalesInfo @ProdCat nvarchar(100)

AS

BEGIN

select h.OrderDate,h.PurchaseOrderNumber,MAX(h.SubTotal) Amount

from SalesLT.SalesOrderHeader h

inner join SalesLT.SalesOrderDetail d

on h.SalesOrderID = d.SalesOrderID

inner join SalesLT.Product p

on d.ProductID = p.ProductID

inner join SalesLT.ProductCategory pc

on pc.ProductCategoryID = p.ProductCategoryID

and pc.Name = @ProdCat

where YEAR(h.OrderDate)= 2008 and h.PurchaseOrderNumber is not null

group by h.OrderDate, h.PurchaseOrderNumber

end

go

=====================================================================

We also need to create a table and sp for logging
=====================================================================
create table demo.ETLLog
( id int identity (1,1) primary key,
DateProcessed datetime default(getdate()),
ProductCategory nvarchar(100) not null,
duration int not null)

Create or ALTER proc demo.updateETLLog
@ProdCat nvarchar(100), @duration int

as

begin

insert into demo.ETLLog(ProductCategory,duration)
values(@ProdCat ,@duration)

end

go

And we require one SP to fetch the lookup data as below

ALTER proc demo.GetProductCategry

AS

BEGIN

select productcategoryid, Name as Category

from SalesLT.ProductCategory

END

In ADF First you need to create a pipeline and then drag

a Lookup from the left pan of the designer.

See the highlighted part for the
Lookup where the category

is coming from the SP enabling

looking thru those category via

Foreach loop

To use from the Lookup value

by foreach loop, inside setting

of the foreach loop we need to

use the below formula inside

the setting tab under item.

Use Foreach as sequential mode

@activity('LookupCategories').output.value

if you double click the foreach loop then you'll be redirecting to the below screen

where you need to add a copy control first

The input parameter if the SP to be supplied from the parameter value
@item().Category

Please note Category is one of the output of the SP demo.GetProductCategry

The sink here is destination.

When you'll go to the tab for

any data-set sink or source,

you'll be having two options

Choosing from the existing or

creation of a new.

I created the new data-set and

then I need to create the link

server

One is for source i.e. Azure SQL DB

For that you need to remember
the SQL credential i.e. UID and

pwd of Azure SQL.

For ADLS you need to add the ADF

pipeline name inside the access
tab

of ADLS data explorer and use the

manage identity option.

I'm not explaining the process for ADLS security not a great extent.

Anyways if you get any security error while testing connection for
ADLS please use the below link

https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-data-lake-store#linked-service-properties

For dynamic creation of files based on category inside folder of ADLS

Use the dynamic file creation

@concat('sales_',item().Category,'.txt')