Thursday, November 01, 2018

SQL Server Management Studio (SSMS) from Command Prompt

When using SQL Server Management Studio I feel it be a pain and waste of time to choose the same SQL server instance, authentication details again and again.

As a workaround, I use to make use of the "ssms" command

If SQL Authentication: 
ssms -s MySQLServer2017ENT -d testbed -u demo -p demo

-s: Server details
-d: Database to connect
-u: username
-p: password

For Windows Authentication:
ssms -s MySQLServer2017ENT -d testbed

But opening command prompt and typing this each time doesn't make sense either. So created a batch file and placed it in the desktop. Just double clicking the batch file is all one has to do. Mainly while working on my personal laptop this comes in very handy.

Content of the batch file:

start ssms -s MySQLServer2017ENT -d testbed -u demo -p demo

Monday, January 01, 2018

Lessons 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 the control never reaches during the normal flow. The code might look decent enough while reviewing, but unless you had made sure control comes to that part of your code and test it nothing is guaranteed to work.

Sounds obvious, doesn't it? Think how many times you would have faced this scenario by having used some test data which never takes you to an "else" part of the code (or) "case" of a switch statement etc.,

2: Logging, Error Handling to be part of the code from the very beginning.

While developing a new feature/module/project add logging and error handling from the beginning of the development as both of them would be really useful & help you be more productive. You always need a way to know what is happening in the program like how much time important parts of the code are taking, exceptions being thrown etc.,

Sooner you know about the issues in your code easier it is to get them fixed.

3: Always change only one thing at a time

Always make sure to do short iterations, confirm that it works, move on to the next one & repeat the same process. It is easier to identify the root cause of the failure if you had made just one feature change at a time.

I used to follow the same principle while committing changes to source control as well. So that if I need to revert back any specific feature it becomes easier.

You might think to make multiple fixes (or) adding multiple small features quickly and then add the code to source control thinking you have control over things. But that is just a good case scenario. What if something messes up in the code (or) some features were pulled out of the release at the last minute?

4:  When in doubt use paper or whiteboard

Whenever I get stuck while writing a program I just stop, move away from my laptop, pick a piece of paper or a whiteboard marker and start writing the program there. Many times I had found it to be useful to recollect my thoughts, don't worry about the syntax, just think about the actual problem & solve it quickly.

5: Load test your code

Do not claim the code to be complete by just checking your code with few hundred sample data in the database. Try to simulate the load of the actual scenario of your production environment.

With just 10 or 100 records most code would run faster without many issues but maybe the table you hit in your production database might have few million records and it might take forever to return you the data. Maybe in your production environment, there might always hundreds of users using it at the same time but you had tested with just one user connection.

6: Unit Testing should be made compulsory 

All code change should be accompanied by a unit test. Though it will make developing any change slightly slower it's worth it because it makes the code base scalable. Also, need to make sure automated unit testing is in place at the earliest.

I find that writing unit tests actually increase my programming speed - Martin Flower

7: Talk to your team frequently

If you tend to talk only to your peers, upper management over and over again there is a high possibility of you missing out on important feedbacks, suggestions which your team might have.

8: Share credit.

It's sad we have come to a level where this had to be mentioned separately.

Many times have seen leads, managers claiming that they did all the hard work to make something work. On any failure, the same folks would put the blame squarely on the team. Your team would have made 90% of the code to work and get stuck with some 10% of the tasks. You would have helped them fix it, fair enough, but you shouldn't take credit for the whole 100%.

It's very small world and in no time your team would come to know of this. One - your team would be demotivated, Second - you lose your teams trust.

Always go out of your way to mention who all contributed to this and don't ever steal somebody's credit.

"If anything goes bad, I did it. If anything goes semi-good, we did it. If anything goes really good, they did it." - Bear Bryant
In life, one has to be learning all the time. How important it is to never stop growing. That being said, would love to hear your feedback on this post.

Saturday, December 02, 2017

Stack 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 Billion page views per month
  • They transfer ~55 TB data per month
  • 4 SQL Servers (organized as 2 clusters)
  • Stack Overflow serves 528 Million queries per day (Peak 11000 queries per second)
  • Stack Exchange, Careers, meta serves 496 million queries per day (Peak 12800 queries per second)
  • Over 360 databases with the same schema, which changes frequently
  • They made use of Microsoft Bizspark program before getting graduated
  • All their production traffic is served using physical servers & 
  • Cloud services are being used only for storing encrypted offsite backups (Glacier) and for DNS (Route53)

Programming stack used:

  • C# + ASP.NET MVC, 
  • Dapper ORM, 
  • StackExchange.Redis, 
  • DotNetOpenAuth, 
  • MiniProfiler, 
  • Jil

Deployment on a typical day:

  • 25 times per day code deployment to the development server (just Stack overflow Q&A alone)
  • 5 to 10 times a day production deployment happens!

Page rendering time:

  • Homepage renders @ 12.2 millisecond
  • Questions page renders @ 18.3 milliseconds

Source: &

Friday, November 24, 2017

What 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 (re)use web components - HTML, CSS and JavaScript in the creation of desktop applications. 
  • Then it can be distributed across platforms - Windows, Mac OS X, or Linux.

Saturday, November 11, 2017

Ten 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 interesting 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 a lot of changes and they started embracing open source which initially was surprising to me.

So for me, it was a no-brainer to pick his book "Hit Refresh" from the store immediately once it was released. The first half of the book was more interesting where he was talking about his life in India, about his kids, love for Cricket and how over a period he got more interested in Computers than Cricket.

Microsoft CEO Satya Nadella's Book

One anecdote of how he was first interviewed at Microsoft was exciting. He was asked
- "Imagine you see a baby laying in the street, and the baby is crying. What do you do?".
- As a young engineer, he has answered the question exactly as I would have: "You call 911".
- The interviewer's response was cooler: "You need some empathy, man. If a baby is laying on the street crying, pick up the baby.".

By the way, these are the 10 quotes from this book which I found to be Inspiring. 

  • The C in CEO stands for Culture
  • Success can cause people to unlearn the habits that made them successful in the first place.
  • Learning to fly is not pretty but flying is.  
  • It is not the device that is mobile. It is you.
  • Culture eats strategy for breakfast.
  • We needed to build deeper empathy for our customers and their unarticulated and unmet needs. It was time to hit refresh.
  • Empathy grounds me and centers me
  • A leaders job is to "Find rose petals in a field of shit"
  • Leadership means making choices and rallying the team around these choices.
  • For anything great to happen – great software, innovative hardware, or even a sustainable institution – there needs to be one great mind or a set of agreeing minds.

I loved his thoughts on how the world is not about Man vs Machine but their coexistence, to make this world a better place. In my opinion, overall, "Hit Refresh" is a great read and after reading the book, I'm convinced that Microsoft picked the right CEO at the right time :)

Wednesday, June 21, 2017

Make it WORK then Make it BETTER

Mostly this mantra is followed by majority of the development teams (in particular startups) & it certainly makes sense as long as it gets understood completely.

In my nearly 2 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/bad estimation.


Because once the minimal viable product is made people start pulling resources out of that, start assigning next module so that they can "Make it work". The assumption was we can work on refactoring the code tomorrow or day after which in reality never happens. Ultimately the development folks don't find time to "refactor" their initial code to "Make it better".

"The problem with waiting until tomorrow is that when it finally arrives, it is called today." - Jim Rohn

So what? It is already working anyway! 

"Make it work" which is not followed by refactoring sessions to "Make it better" will undoubtedly break down when we start to scale. Over a period of time code base would become complicated & the cost of change at that time would be too high which might even jeopardize the business altogether.

Make it work 
- If need be, do research and implement a solution to achieve the desired behavior/result.
- The solution might not be having a good design,
- Code will not be optimized and
- It won't be easily maintainable.

Make it better
- Now that desired result is in hand, refactor the code.
- Organize the code base properly to have a good design and
- Make sure it's maintainable.
- Optimize the code to achieve the desired performance goals of the application.

Thursday, January 26, 2017

Is Banning Coke/Pepsi the solution?


1. I support Jallikattu and had even posted my thoughts about it here - "Jallikattu needs your support"
2. It's been almost 3 years since I stopped consuming any aerated drinks (Coke, Pepsi, Fanta, ThumsUp, Limca, Sprite etc.,). So I always request people to stop drinking any aerated drinks and instead drink Tender coconut, buttermilk, Fresh juices (without ice or sugar :) ) etc.,

What is the reasoning for asking a BAN?

From what I understand, the reason as to why protesters are asking for a ban is because of the depletion of Thamirabarani river. The depletion that is caused by these companies affect farmers and other people in the surrounding locality. Drought kind of situation is staring us. So the root cause is "water scarcity".

My 2 cents:

Definitely, we got to support our farmers who are the backbone of our country and if something is affecting them then everyone should do our bit to clear the hurdle for them.

While thinking about it the questions which came to my mind are:

-  "Are these companies the only reason for water scarcity?"

- "Who is responsible for ALL encroachment on all our water bodies in Tamil Nadu?" - Shouldn't we Ban encroachments & restore those water bodies?

- "Why selectively Ban Pepsi & Coke alone? Why not other companies which manufacture aerated drinks?" - If the product is the issue, shouldn't one avoid all aerated drinks? As we all know Bovonto is a local Tamil Nadu based company which is there since 1916 and have avoided numerous attempts by other giants to take over them & survived. But at the end of the day, they too manufacture aerated drink only? And they would as well be sucking water from somewhere so won't it affect that locality?

- "What do we do with bottled mineral water like Aquafina (Pepsi), Kinley (Coke)?"

- "After encroachments, the other main culprits are Sand Mining but why isn't anyone serious about stopping it?" - This is actually changing course of river flow, groundwater collapses, rivers gets dried up etc.,

- "How much water is needed to manufacture 1 liter of bottled mineral water, soda, wine, beer & Hard alcohol?". In this October 2013 article (which is based on North American companies) I found these data points:
* 1 liter of bottled mineral water on an average needs 1.39 liter of water
* 1 liter of soda on an average requires 2.02 liters of water
* 1 liter of beer on an average needs 4 liters of water
* 1 liter of wine on an average needs 4.74 liters of water
* 1 liter of hard alcohol on an average requires 34.55 liters of water

I couldn't find any similar data points for Indian companies but I believe it gives us an idea of how much water is getting used to manufacture those products kept on the shelf of our Tasmac!

Though the "Water" problem is for real the proposed solution of selective banning doesn't seem to be a complete solution. To me, it sounds more like an emotional decision than a decision based on facts.

Newton's third law is: For every action, there is an equal and opposite reaction.

By saying we are banning selected companies we would be sending a wrong signal. I am not very sure whether Tamil Nadu can survive without foreign investments and outsourced job in the present globalized environment?

- Aren't we fine with American outsourced jobs in India?
- Aren't we fine with our kids, relatives going for any of the university in the US for higher studies?
- As a reaction, if these companies lobby in the US and try to stop the import of Indian goods there what would we do?

So banning something is not a permanent solution. If those companies have flouted any rules then penalize them based on that. Also if we have proof stating it has pesticides and it's not safer for human consumption maybe take it up with Food safety & standards authority of India (or whoever is supposed to regulate it).

Possible solutions:

1. We have regulations in our system but are those getting really implemented properly? Got to monitor that. So the best place to start with would be to have better regulation and make sure the regulations are implemented properly.
2. Instead of banning we should work towards creating a better product than these and let them lose their market share.
3. Create awareness about the health hazards and educate our friends, relatives to stop using their products. When there is no market for them they themselves will move away.

Reference material for further reading:

1. Article about Sand Mining in Tamil Nadu
2. Quora discussion - Is Bovonto healthier than Pepsi/Coke?
3. Sand Mining issue - Impact cannot even be calculated
4. How much water is needed to make manufacture 1 liter of mineral water, wine, beer, hard alcohol?