This Week I Learned - Week #61

This Week I Learned:

• The debug console page in the Azure Kudu tool offers a File explorer for your site, where you can view your site’s content, download files (or full folders), delete files (or folders), edit files and even upload files using drag and drop. When you download a folder via the file explorer, it’s delivered to you as a ZIP file containing the entire folder structure.
• A SQL subquery may contain another subquery. In fact you can nest as many levels as you need.  However, for most applications more than four levels is an indication of poor database design
• "Some data scientists say that they can spend up to 70% of their time in data wrangling (extracting and cleaning data) data munging"
• JSNice.org can nicify JavaScript through Statistical renaming, Type inference and Deobfuscation 
• India is the world's second largest textile exporter lagging behind China whose exports are nearly seven times higher
• Today, based on the HTTP Archive data, the average website has 18 scripts
• Ideals vs Commerce: As graduate students at Stanford, Sergey Brin and Larry Page wrote that “advertising-funded search engines will be inherently biased toward the advertisers.” Then they started Google, which makes money from advertising. Mark Zuckerberg of Facebook used to talk about a society of complete openness, while mining people’s lives to sell ads. 
• The Twitter handle SavedYouAClick gets you the meat of news articles with catchy titles acting as click-bait by giving you the summary in a single tweet. I've been similarly trying to put answers from Google WebMaster Central YouTube videos as a single sentence. 
• Betteridge's law of headlines is an adage that states: "Any headline which ends in a question mark can be answered by the word no."
• The biggest cause of death in Japan is cancer at 28.8%, followed by cardiac disease at 15.5% and pneumonia at 9.7%. Cancer has been the top cause of death since 1981 and has continued to increase. Source - WSJ
• Kerala, Maharashtra, Bihar, Orissa, Assam, Rajasthan, Arunachal Pradesh, Himachal Pradesh and Jammu & Kashmir charge taxes from e-commerce companies.
• India is the world's second largest textile exporter lagging behind China whose exports are nearly seven times higher
• Only in Hyderabad - According to their own ad, Hyderabad Metro Rail has won "several prestigious" awards even before it has commenced operations! Touted as the world's largest Metro rail project in Public Private Partnership mode, the phase 1 covering 72 km is expected to cost Rs 14,132 crores or $ 2.3 billion (at Rs 60 a $). Construction for Phase 1 started in April 2012 and a small stretch is targeted to be operational by March 2015.