abhaypsingh

Slides for Re:Invent conference

• Re:Invent 2015
• Re:Invent 2014
• Re:Invent 2013
• Re:Invent 2012

### Re:Invent 2015 * [(SPOT301) AWS Innovation at Scale](http://www.slideshare.net/AmazonWebServices/spot301-aws-innovation-at-scale-53890277) * [(MBL305) You Have Data from the Devices, Now What?: Getting the Value of the IoT](http://www.slideshare.net/AmazonWebServices/mbl305-you-have-data-from-the-devices-now-what-getting-the-value-of-the-iot)

abhaypsingh

Code is clean if it can be understood easily – by everyone on the team. Clean code can be read and enhanced by a developer other than its original author. With understandability comes readability, changeability, extensibility and maintainability.

---

General rules

1. Follow standard conventions.
2. Keep it simple stupid. Simpler is always better. Reduce complexity as much as possible.
3. Boy scout rule. Leave the campground cleaner than you found it.
4. Always find root cause. Always look for the root cause of a problem.

Design rules

abhaypsingh

##########
# Tweaked Win10 Initial Setup Script
# Primary Author: Disassembler <disassembler@dasm.cz>
# Modified by: alirobe <alirobe@alirobe.com> based on my personal preferences.
# Version: 2.20.2, 2018-09-14
# Primary Author Source: https://github.com/Disassembler0/Win10-Initial-Setup-Script
# Tweaked Source: https://gist.github.com/alirobe/7f3b34ad89a159e6daa1/
# Tweak difference:
#
#    @alirobe's version is a subset focused on safely disabling telemetry, some 'smart' features and 3rd party bloat ...

abhaypsingh

Amazon Cloud Drive Advisory

Over the past few days, a security issue came to light regarding an authentication service used by another tool, acd_cli. acd_cli had its authentication keys for Amazon Cloud Drive blocked after Amazon engineers reviewed their source code for their authentication service and found a security issue.

This morning, rclone's authentication keys were apparently blocked by Amazon. No reason has been brought forth at this time, and rclone does not use a cloud service to authenticate users - it uses a local web server. Theories include an influx of rclone users after acd_cli was blocked, people extracting the API authentication keys from rclone and using them with acd_cli, a combination of both, or Amazon wanting to clamp down on heavy users with several terabytes of data, and blocking the tools they use to do so.

The Amazon rep that I spoke with over the phone speculated that it "may be because of a recent event," but offered nothing more. I was offered a full refund, four month

abhaypsingh

Updated, easy to remember numbers for back-of-the-envelope calculations in system design interviews

Powers of two table

Power    Approx Value (Bytes)       Bytes
-----------------------------------------
10                 1 thousand        1 KB
16                16 thousand       64 KB
20                  1 million        1 MB
30 1 billion 1 GB

abhaypsingh

What to Expect and Tips

• 45-minute systems interview, focus on responding to real world problems with an unhealthy service, such as a web server or database. The interview will start off at a high level troubleshooting a likely scenario, dig deeper to find the cause and some possible solutions for it. The goal is to probe your knowledge of systems at scale and under load, so keep in mind the challenges of the Facebook environment.
• Focus on things such as tooling, memory management and unix process lifecycle.

Systems

More specifically, linux troubleshooting and debugging. Understanding things like memory, io, cpu, shell, memory etc. would be pretty helpful. Knowing how to actually write a unix shell would also be a good idea. What tools might you use to debug something? On another note, this interview will likely push your boundaries of what you know (and how to implement it).

Design/Architecture 

Interview is all about taking an ambiguous question of how you might build a system and letting

abhaypsingh

Setting Up MCP Servers on Windows

A step-by-step guide to setting up Model Context Protocol (MCP) servers for Claude Desktop on Windows.

Prerequisites

1. Install Node.js (v18.x or later)
   • Download from: https://nodejs.org/
   • Verify installation by opening Command Prompt (CMD) and running:

     node --version
     npm --version

abhaypsingh

SELECT 
  CONCAT(table_catalog, '.', table_schema, '.', table_name) AS `table`,
  column_name,
  data_type
FROM system.information_schema.columns 
ORDER BY 1



SELECT

abhaypsingh

#!/usr/bin/env python3

#
# usage: wacz-images.py <wacz_file>
#
# This program will extract images from the WARC files contained in a WACZ 
# file and write them to the current working directory using the image's URL 
# as a file location.
#
# You will need to `pip install warcio` for it to work.

abhaypsingh

#!/usr/bin/env python3
# coding: utf-8
"""
Causal Great Gatsby: estimate causal impact of 'wealth language'
on sentence sentiment using PyWhy/DoWhy.
"""

import re, requests, io, textwrap, sys, tqdm
from vaderSentiment.vaderSentiment import SentimentIntensityAnalyzer
import pandas as pd