Surendra Ganti – Medium

Surendra Ganti

Getting Police Clearance Certificate (PCC) for India from Canada

As part of my Canada Permanent Residency (PR) journey, I need to get my PCC for all the places I lived before coming to Canada; as a person…

5 min readMay 8, 2023

--

--

Surendra Ganti

JSON Path Vs String Concatenation

I do have a scenario where I need to make a JSON in a batch for a million rows in a sql server table. Ideally my first inclination is to…

1 min readMay 3, 2021

--

--

Surendra Ganti

Microsoft Project Color Coding tasks based on outline number

We have a created a huge Microsoft project, but understanding the level of the tasks is always difficult visually unless we color code…

1 min readAug 25, 2019

--

--

Surendra Ganti

Microsoft Project and Jira Integration

I am running a project where we are doing planning in Microsoft project (MPP) files and using Jira for our regular work (like requirement…

1 min readAug 25, 2019

--

--

Surendra Ganti

Electron APP and classic windows APP integration

Electron is new kid in the town to develop all the desktop applications, supporting multiple platforms and using javascript (node.js)+ HTML…

5 min readMay 31, 2018

--

3

--

3

Surendra Ganti

Amazon Fake reviews

I love buying items from Amazon, it is very convinient and makes things easy and saves a lot of time. In the good old days I used to go to…

2 min readSep 27, 2017

--

Amazon Fake reviews

--

Surendra Ganti

Windows 10 & Bluetooth headphones

If you buy a new pair of bluetooth headphones and want to use them with windows 10, you might run into trouble just like I did, I want to…

2 min readSep 5, 2017

--

Windows 10 & Bluetooth headphones

--

Surendra Ganti

AWS Athena performance optimization

Amazon Athena is an interactive query service that makes it easy to analyze data stored in Amazon S3 using almost Standard SQL.

3 min readAug 11, 2017

--

AWS Athena performance optimization

--

Surendra Ganti

Convert CSV to Apache ORC format

Apache ORC is a columnar format. We started looking into ORC format from the time Athena showed up as a service on AWS. A quick 101 of…

2 min readAug 10, 2017

--

--

Surendra Ganti

Surendra Ganti

A techno functional expert in the financial domain, A Versatilist, with a lot of experience in developing on SQL Server. Thoughts and opinions are my own.

Following

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams