This Week I Learned - Week #29 2022

This Week I Learned - 

* If you have a second monitor, you can undock the developer tools to that one

* Mobile versions of web sites tend to be slimmer, easier to use and not full of popups and demands to sign up for services and the like. Many video sites also use a native HTML5 player on a mobile interface instead of one with lots of interaction and popups. This allows you to save videos in an easy fashion. 

* Azure Backup pricing estimator [Excel] - Usage guide 

* Oracle Database Cloud Exadata Service is equivalent to an on-premises Oracle Exadata, just with a different consumption model. For an on-premises consumption model equivalent to our public cloud, behind your firewall, there’s the Cloud at Customer service delivered by Exadata Cloud Machine.

* You can write SQL in Google Sheets? It's one of the most powerful tools a Data Analyst could use. Here's why...

- You can easily query from another sheet.

- Filter out the columns you want with the SELECT statement.

- Filter data even further with the WHERE clause.

- Aggregate the data like you would in SQL with GROUP BY.

- Sort the data using ORDER BY.

Here is an example of a query referencing another sheet.

=QUERY("sheet URL","sheet name!A1:F50"), "SELECT B, C WHERE C > 20 ORDER BY B desc",1)

* Citrix DaaS Standard for Azure (formerly Citrix Virtual Apps and Desktops Standard for Azure) is the simplest, fastest way to deliver Windows apps and desktops from Microsoft Azure. Citrix DaaS for Azure is a Citrix Cloud service. Citrix Cloud is the platform that hosts and administers Citrix Cloud services.

* Google Search Appliance was discontinued in 2018

* Discontinued products from Apple, Google and Microsoft

* IBM QRadar is an enterprise security information and event management (SIEM) product. It collects log data from an enterprise, its network devices, host assets and operating systems, applications, vulnerabilities, and user activities and behaviors.

* PaperCut has a suite of cloud print solutions for enabling and managing print with the cloud. Print management in the cloud isn’t about replacing on-prem infrastructure. It’s about enhancing the print management space by utilizing cloud and IoT (Internet of Things) technologies. Cloud printing facilitates remote printing over the internet. Cloud print management tracks and coordinates printing with the cloud, rather than with on-premise infrastructure.

* The scale required to build artificial intelligence systems is too complex, too obscured by intellectual property law, and too mired in logistical complexity to fully comprehend in the moment. Yet you draw on it every time you issue a simple voice command to a small cylinder in your living room: ‘Alexa, what time is it?” - Anatomy of AI 

* Dee Hock is the visionary founder of Visa Inc. who built a system for modern electronic payments infrastructure that transformed how money changes hands. 

* Geetanjali Shree is the first Indian writer to win the International Booker Prize. Her novel Tomb of Sand, a family saga set in the shadow of the partition of India, follows an 80-year-old woman after the death of her husband. The International Booker Prize, which started in 2005, is awarded to a book which is translated into English and published in the UK or Ireland. It is different from the Man Booker Prize, which is awarded to a work written in English, and has been won in the past by Indians.

* Population statistics are like crystal balls -- when examined closely, they can help predict a country’s future (and give important clues about the past). A visual tool called a population pyramid helps policymakers and social scientists make sense of the statistics, using three different countries' pyramids as examples.

* Ocean Spray cooperative grows over 60% of the world's cranberries

* Caffeine and mainly theobromine present in chocolate is dangerous for dogs. Cats can't detect sweet taste and are therefore not interested in chocolate. Felines' taste receptors can't detect sugar. Humans, like most other mammals, have five different receptors—salty, bitter, sour, umami (savory), and sweet. The taste receptor for sweet is encoded in two genes that code for two proteins, both of which are involved in our ability to enjoy sugary treats. Humans can digest caffeine and theobromine at moderate levels.

* Accurate recording of body temperature became possible in the eighteenth century when the Dutch inventor Farenheit introduced the thermometer. 

* Carl Langenbuch performed the first successful cholecystectomy (surgical procedure to remove gallbladder) at the Lazarus hospital in Berlin on July 15, 1882. In 1985 (103 years later), Prof Dr Erich Mühe of Germany performed the first laparoscopic cholecystectomy (LC). Several species of mammals (including horses, deer, rats, and laminoids), several species of birds (such as pigeons and some psittacine species), lampreys and all invertebrates do not have a gallbladder. Gall bladder is responsible for storing bile which is produced by the liver and used in the digestion of fats in the intestines. Animals that eat frequently, without long intervals, constantly need bile acids, so an organ to store the acids is unnecessary.

* Hemispherectomy is a very rare neurosurgical procedure in which a cerebral hemisphere is removed, disconnected, or disabled. This type of brain surgery helps control severe seizures that come from one side of the brain. 

* Form 16 is issued annually by an employer after the end of the financial year. The TDS certificate shows the information for the financial year gone by. The last date for issuing Form 16 is June 15. In case an employer fails to provide you with a Form 16 after having deducted TDS – the minimum penalty that the employer will pay is Rs 100 for every day the default continues.You can write about this failure of your employer to the Assessing Officer who may take appropriate action against the employer, including levying penalty as mentioned above and also carrying out further proceedings against the employer.

* The National Remote Sensing Centre is hosting an experimental map showing low-lying vulnerable areas in Hyderabad. The map shows the contours of land and the areas that are likely to be flooded in the eventuality of heavy downpour.  

Bhuvan map shows pink and magenta as low-lying areas in Hyderabad