Skip to main content

Blog @ Codonomics

Democratizing Knowledge & Experience

Search This Blog

Pages

About Me
Blog
Limelight
@ LinkedIn
@ Medium
My Quotes
Testimonial

Showing posts from November, 2021

Posts

Buy @ Amazon

SQL Dev Interview - Optimize SQL Server Table With Many Indexes For Performance

on November 22, 2021

Interview Question Performance Tuning SQL Server

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Partitioning in SQL Server

on November 12, 2021

Partitioning SQL Server

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Quick Notes On Various Insurance Plans

on November 10, 2021

Endowment Policy Health Insurance Insurance Plans Life Insurance Term Insurance

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Bulk Copy in SQL Server

on November 08, 2021

Bulk Copy SQL Server

+

Get link
Facebook
X
Pinterest
Email
Other Apps

User Defined Functions in SQL Server

on November 05, 2021

SQL Server User Defined Functions

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Subscribe

Posts

Posts

All Comments

All Comments

Followers

Archives

2024 21
- October 5
- September 3
- July 1
- June 4
- May 1
- March 1
- February 1
- January 5

2023 22
- December 1
- September 3
- August 4
- July 6
- May 3
- April 3
- March 1
- January 1
2022 9
- September 1
- August 2
- July 1
- June 2
- March 1
- January 2
2021 28
2020 45
- December 2
- November 2
- October 7
- September 5
- August 10
- July 6
- June 2
- May 3
- April 2
- March 2
- February 1
- January 3
2019 31
- December 1
- October 1
- September 4
- August 2
- July 1
- June 1
- May 1
- April 2
- March 5
- February 6
- January 7
2018 22
- December 7
- November 2
- August 5
- April 3
- March 5
2017 20
- December 2
- November 1
- October 1
- September 4
- August 7
- July 3
- June 1
- March 1
2016 12
- August 3
- July 1
- April 2
- March 3
- February 2
- January 1
2015 5
2014 33
- September 4
- August 6
- May 3
- March 5
- February 7
- January 8
2013 9
- December 3
- July 1
- May 5
2012 7
- December 1
- October 1
- August 2
- May 3
2011 26
- November 4
- October 5
- September 3
- June 4
- May 1
- April 3
- March 2
- February 2
- January 2
2010 12
- December 1
- November 2
- October 2
- September 3
- August 3
- July 1

Show more Show less

Labels

10 commandments
12 Factor App Principles
Aadhar
AB Testing
Acer Predator Triton 300
achievement
Adopt AWS Rightly
Advice
Agile
agile adoption

Show more Show less

Stack Exchange User Flair

Popular Posts

Should I buy refurbished laptop from Amazon?

This post is based on my experience with amazon.in and guess it to be true on all other platforms as well. At least you can check out and verify for these pointers before you make that decision to buy renewed/refurbished laptop on Amazon with your hard earned money. I see this question propping up in several forums and on many different occasions. In the recent past, I had my 5 year old dell laptop that gave up because its motherboard failed. One of the options that I had in my mind was to re-use the HDD and the 16GB DDR4 RAM of that old laptop in the one that I purchase next as secondary. I had come to a conclusion that it is not worth buying a refurbished/renewed laptop at all. Why? For the following reasons, most of which I see as BIG #RedFlags: You got to remember that Amazon provides a platform for 3rd party sellers to sell their products as well. So in your search for refurbished laptops you wouldn’t want to choose some random 3rd party seller who Amazon doesn’t endorse. You...

Clustered Vs Non-Clustered Index In SQL Server

The comparison table below should be a quick refresher to those DB Specialists attending technical interviews or ones wanting to take a decision of whether or not to create an index for a table in the live server. Clustered Index Non-Clustered Index Helps you to store Data and index together. Stores the data at one location and indices at another location. Non-clustered Index store key values only and has Pointers to Index rows (for Clustered table) or RID (for Heap/Non-Clustered table). Stores data pages in the leaf nodes of the index. Never stores data pages in the leaf nodes of the index. You can sort the records and store clustered index physically in memory as per the order. A non-clustered index helps you to creates a logical order for data rows and uses pointers for physical data files. Doesn’t require additional disk space Require additional disk space to store the index ...

Android Activity's onDestroy() Ain't Your Reliable Friend

Look at the Android Activity life-cycle events in the picture beside. The lifecycle isn't something new. You're familiar with it right? You're also that good Android developer that writes clean code, wherein you consciously override onDestroy() method to include resources clean-up code and save some state, right? Per Android doc , it is okay and usually the practice to write cleanup code in this method but not anything beyond that. So if you are to write code to persist state in this method, or anything else beyond resource clean-up (like threads associated with an activity), you're better off to push it up the life-cycle, either in onStop() or onPause() method. That is how I settled in the first iteration of new learning but wasn't happy. Why? To quote Android Doc:

How to disable gnome-ssh-askpass?

Today we had setup Git repo with access to it through corporate's LDAP authentication. From the client machines we can access it using the .netrc (where the machine, login and password are configured). However, for some wierd reason, upon trying to pull/push commits from/to the Git repository, the bash shell tries to open the gnome-ssh-askpass dialogue and it fails. I wanted to prevent the bash shell from attempting to launch the dialogue box. To do this, all I had to do is run the following command in the terminal: $ unset SSH_ASKPASS To prevent it in future, you can add the above line in your .bashrc or .bash_profile. Wish you trouble-free working!

AWS Cloud Services Marked For Sunset By 2024 Year-end

AWS Cloud services is going through an overhaul in the past couple of years with the sunsetting of even some notable service. Listed below are some of the notable services that are marked for sunset latest by the end of year 2024: AWS OpsWorks: is a managed service for Chef/Puppet, a configuration management tool. It has reached its end of life in AWS Cloud. AWS Cloud9: is a cloud-based integrated development environment. If you are still using it, you may want to consider checking out their blog post titled, " How to migrate from AWS Cloud9 to AWS IDE Toolkits or AWS Cloudshell ". AWS CodeCommit: is a serverless version control repository service and AWS has recently cut out access to it for new customers and that implies it is marked for sunset. You can confirm this from its VP Jeff Barr's tweet , if you were to follow him. They later published a blog post titled, " How to migrate your AWS CodeCommit repository to another Git provider ", that should be o...

My Past Speaking Engagements

Powered by Blogger

Copyright 2021