tag:blogger.com,1999:blog-58492652024-03-13T06:14:56.228+05:30Vadivel's blogI write about things which I am passionate about.Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.comBlogger442125tag:blogger.com,1999:blog-5849265.post-3456378251745818272021-01-01T12:26:00.000+05:302021-01-01T12:26:15.092+05:30New Year MessageCongrats & Good Luck2020Undoubtedly 2020 was a challenging year for most of us, and Congratulations on all those little things you still managed to accomplish last year.2021 - New Year Always remember, Today is the tomorrow you were worried about yesterday. So don't give up. Just keep fighting, be bold, do the right thing, and believe great things are bound to happen to you sooner or Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-82961335377934354072020-09-18T10:03:00.005+05:302020-09-18T13:46:23.591+05:30General Hiring StrategyEven while looking for members with specific technical skills, I generally look for these in any candidate: 1. Lots of people can raise issues and surface problems. But the best people identify the problem, propose a real solution to it, and help do the work to implement it. Those people are incredibly rare and incredibly valuable.Does this candidate look like one among them? 2. Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-60948000143601543892018-11-01T23:09:00.001+05:302020-09-18T13:53:37.567+05:30SQL Server Management Studio (SSMS) from Command PromptWhen using SQL Server Management Studio, I feel it's a pain and waste of time to choose the same SQL server instance, authentication details repeatedly.As a workaround, I use to make use of the "ssms" command.
If SQL Authentication:
ssms -s MySQLServer2017ENT -d testbed -u demo -p demo
here,
-s: Server details
-d: Database to connect
-u: username
-p: password
For Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-20930033430003002612018-01-01T16:22:00.000+05:302018-01-01T16:22:09.024+05:30Lessons learned over a period of time as an IT developer
Have listed down few Lessons learned on the field which I found useful over a period of time.
1: Always execute every line of your code
After developing a feature one needs to obviously test it. Make sure every line of your code has been executed at least once. Many times see bugs on a certain line of code which had never been run by the developer. Kind of a condition within your code where Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-32437849559260865842017-12-02T19:29:00.000+05:302017-12-02T19:29:38.912+05:30Stack overflow is built using ASP.NET, C#, SQL Server, Windows, IIS...
Irrespective of what technology we work with how many times have we landed on Stack Overflow / Stack Exchange website on a daily basis? If we ask this to any developer the answer would mostly be MANY times in a day :)
Site was launched in 2008 and is built using Windows, SQL Server, IIS, and ASP.NET along with HAProxy, Redis, and ElasticSearch, all served via Fastly CDN.
Fun Facts:
1.3 Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-73301358759586139862017-11-24T09:23:00.004+05:302017-11-24T09:23:44.856+05:30What is common between these apps?
What is common between these desktop applications/tools?
Slack
Wordpress
GitHub Atom Editor
GitHub desktop
Microsoft Visual Studio Code
Microsoft SQL Operations Studio
All are built using Electron Framework (Open Source)
Electron framework lets us write cross-platform desktop applications using JavaScript, HTML, and CSS. It is based on Node.js and Chromium.
It allows us to (Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-53849322745778512842017-11-11T20:49:00.001+05:302020-09-28T12:11:06.662+05:30Ten Quotes From Satya Nadella's Book "Hit Refresh" That Inspired Me
A few years back, Microsoft offered a free upgrade to Windows 10. That was an exciting move as their main competitor Apple was doing it for a long time now. As a consumer felt that Satya Nadella becoming CEO of Microsoft has brought in quite many changes, and started embracing open source, which was initially surprising.So for me, it was a no-brainer to pick his book "Hit Refresh" from the storeVadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-48267391481873885142017-06-21T22:50:00.002+05:302020-09-25T19:09:32.962+05:30Make it WORK then Make it BETTER
Mostly this mantra is followed by most development teams (in particular startups) & it certainly makes sense as long as it gets understood completely.In my nearly two decades of experience, I have seen teams strive tirelessly to "Make it work" and deliver a minimum viable product. But are indirectly forced to skip the "Make it better" part due to lack of time/lousy estimation.
Why? Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-2889203593074781912017-01-09T17:24:00.000+05:302018-10-15T08:28:19.182+05:30SQL Server Always Encrypted - At a high level how does it works?
One of the excellent feature introduced in SQL Server 2016 is "Always Encrypted". This gives an extra layer of protection as no one (including the production DBA's) will be able to access the actual data without having the appropriate key.
A high-level overview of how SQL Server 2016 Always Encrypted work:
1. Always Encrypted is a client-side encryption technology in which a SQL Server client Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-35612351449473075102017-01-07T20:36:00.002+05:302017-01-08T19:32:33.984+05:30Quickly removing spam images from WhatsApp
One of the major issues with Whatsapp is in no time it produces numerous "spam images" which would eat up our smartphone's memory.
Initially tackled it by exiting out of many groups and mostly used it for direct one-on-one conversations alone. It helped in cutting down on those useless images (memes, screenshots, quotes, images with good morning/evening messages etc.,) but it didn't completely Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com1tag:blogger.com,1999:blog-5849265.post-61534822916206634552017-01-06T13:02:00.001+05:302017-01-07T14:40:44.295+05:30Universal Basic Income
"Universal Basic Income" - Heard about this only recently via an Elon Musk interview in November 2016 since then been reading about it. Understood it being discussed for many decades now and certainly not a new idea.
What does it mean?
A government would guarantee citizens a regular fixed sum of enough money to cover a basic standard of living, they can spend however they want, no Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-64238904326085390752016-12-17T19:18:00.000+05:302016-12-18T07:42:49.881+05:30Is your SQL Server Database backup good enough? Can it save you during a disaster?
Met a DBA from a company who are in business for ~2 years. During the conversation came to know they have never tested their backup file - not even once. Also, they have very rarely used DBCC CheckDB command. Should I call it as surprised or shocked?
It has become common to see Database Administrators to have fancy DB Backup plan, automate it and that's it. Their idea is whenever the need Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-7143558076448716392016-12-15T12:34:00.000+05:302016-12-16T09:41:47.628+05:30Positives of Cyclone Vardah - Unity, Humanity, Self-help
Chennai, Cyclone Vardah (Dec 12, 2016) - In person, have never witnessed anything as close to this in my life. The winds were so powerful it has uprooted close to 15 trees in our colony, the howling sound of the winds blowing was so scary which gives me goosebumps even thinking of it now. It was a complete carnage by "Vardah" on that day.
Our colony had ~50 trees and out of which we lost 15 oddVadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com1tag:blogger.com,1999:blog-5849265.post-28032172800266259042016-12-12T18:26:00.000+05:302016-12-12T18:26:07.043+05:30How I got billed even though I had registered as an AWS Free Tier user
Amazon AWS offers 12 months free tier to get started with their services. At a high level went through this link and created a free tier account to play around.
Approximately after a month checked the Billing dashboard and was surprised to see that I am getting billed $0.81 for some usage under the heading "Elastic Cloud Compute" (EC2).
Points mentioned about EC2 in AWS Free tier - 12 Months Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-18303961586123174102016-12-09T13:39:00.000+05:302016-12-09T13:39:19.145+05:30From a Windows Machine - Connect (ssh) to Linux Instances running in a Private Amazon VPC
To start with the following tools need to be downloaded:
1. PuTTY
2. PuTTYGen
3. Pageant
If you are a Windows user & trying to connect to (SSH into) an AWS EC2 instance then you need to use PuTTY.
During the process of provisioning an EC2 instance, you would have created/downloaded a key pair file which would be in a .pem format. But PuTTY doesn't support the .pem format and it Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-5740931980655461702016-12-05T00:42:00.002+05:302016-12-05T00:42:37.699+05:30AWS fatal error: An error occurred (400) when calling the HeadObject operation: Bad Request
While using AWS and trying to copy a file from a S3 bucket to my EC2 instance ended up with this error message.
Command Used: aws s3 cp s3://mybucketname/myfilename.html /var/www/html/
Error: fatal error: An error occurred (400) when calling the HeadObject operation: Bad Request
The error goes off if we add the region information to the command statement. I am using Asia Pacific (Mumbai) so Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-72826539758670803572016-11-18T19:08:00.000+05:302016-11-18T19:08:00.821+05:30Is Auto Close Enabled in your SQL Server database?
In SQL Server, one of the Database Properties options is Auto Close. This is an option to be used (auto close = True) if our intention is to shut down cleanly and free the resources once the last user accessing that database exits. If after the last user exits we still want to keep the database alive without shutting down then set auto close as FALSE.
But having this setting enabled in a Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-15169996935541879552016-11-17T18:22:00.003+05:302016-12-18T17:42:58.722+05:30Creating & Executing SQL Queries in Visual Studio Code
Visual Studio Code is a modern, lightweight (but powerful) source code editor which runs on your desktop and is available for Windows, Mac, and Linux.
A new extension has been announced which would support creating and executing SQL queries from within Visual Studio code editor.
Setting up the environment:
1. Download and install Visual Studio code from here - https://Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-53253518029913476262016-09-19T12:55:00.000+05:302016-09-19T12:55:35.733+05:30Enable thumbnail preview in Windows 10
By default "Always show icons, never thumbnails" option would be enabled in Windows 10. Just follow these two steps to change that setting.
1. Go to windows explorer and click on "Options"
2. Uncheck the "Always show icons, never thumbnails" option
That's it just click on OK and you should be able to see the thumbnail of images.
Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-54115162027196350402016-09-12T22:59:00.001+05:302016-09-12T22:59:54.254+05:30To run dex in process, the Gradle daemon needs a larger heap. It currently has approximately 910 MB
Warning / Error: To run dex in process, the Gradle daemon needs a larger heap. It currently has approximately 910 MB
Solution which worked for me:
Android Studio 2.1.* has a feature named Dex In Process. To make use of it we need to update our gradle.properties file and increase the amount of memory allocated to the Gradle Daemon VM to a minimum of 2 GB.
So just added the below line in my Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-2272185746347593832016-08-12T08:33:00.000+05:302016-08-12T22:42:16.462+05:30List all stored procedures which are modified recently in a SQL Server database
In SQL Server Management Studio:
Navigate to your database > Programmability
Press F7 (or) View > Object Explorer Details
In the Object Explorer Details window right click anywhere on the header row and select "Date Last Modified" field (in case it isn't selected already)
T-SQL Script to achieve the same result:
Option 1:
SELECT
name,
Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-1935701053413546102016-05-12T21:53:00.000+05:302016-05-12T21:53:39.692+05:30Transform your fear to success
During my days as an MVP (Microsoft Most Valuable Professional), I used to mentor few juniors from the community. One of them used to be very low on confidence and fear of failure was hurting him more than anything. Recently while cleaning up my mailbox found few of the old emails which I have sent him - cleaned it up a bit and just compiled all those into this article.
Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-52233101147550093602016-05-12T21:49:00.000+05:302016-05-12T21:49:35.889+05:30Important Life Lessons from Cycling
Over the past two years, I acquired many life lessons from cycling. However, after careful thought, I have decided to share the most significant life lessons I have learned in this article
Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-59047037589393065582015-07-30T10:51:00.000+05:302015-07-30T10:54:08.265+05:30#ComeBackHome - Join hands to find missing children
In continuation to my earlier post Finding Missing Children in India I have been looking out for more ways by which we can help track and find a missing child. In that process came to know from my friend about comebackhome.org
On the first look it definitely sounded like a great idea. The concept of this plugin is by just adding one single line of code in all websites we can get the entire Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0tag:blogger.com,1999:blog-5849265.post-37090369993139979892015-07-13T09:43:00.001+05:302015-07-30T10:51:52.516+05:30Finding missing children in India
Recently I come across at least one missing child information shared by my contacts in social media every week. The thought of what might their near and dear one's be going through in those period until they find the child is very disturbing. How on earth somebody is able to kidnap a child? Has money become so important in life that we lost all our moral values?
Few days back came to know Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.com0