Apple WWDC 2020 Keynote

Apple WWDC 2020 Keynote

iOS 14

Key Highlights:

  • Widgets available on Home Screen to give more information just at a glance and it is also customizable in different size.
  • App Library allows you to organize your apps in various categories, sorted by more recent used.
  • Compact Calls and Siri eliminates the entire screen call design into subtle design.
  • Picture in picture support allows multitasking such as watching tv shows while browsing another app.
  • Translate App allows real-time translation.

Digital CarKey

With iOS 14/iOS 13 apple is releasing digital CarKey and CarPlay feature. This feature provides the ability to save car keys in apple wallet.
This will allow iphone or apple watch to unlock and lock NFC (Near Field Communication) compatible cars. BMW 2021 will be the first car with this CarKey buildin feature. Digital CarKey can also be shared using iMessage.

CarPlay will also support apps such as parking, electric vehicle charging and ordering food.

Apple Watch

  • Watch OS7
  • Sleep tracking feature
  • Track hand washing with 20-second countdown
  • Wind down feature


  • OS 14
  • Enhanced Widgets and UI
  • Universal Search
  • Scribble using your hand to populate text fields


  • Auto connect among apple device

TSQL – Last Time Table was Updated

TSQL – Last Time Table was Updated

If you looking for a script to find out when was the last time a particular table was updated then here it is:

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'DATABASENAME')
sys.dm_db_index_usage_stats ius INNER JOIN
sys.tables tbl ON (tbl.OBJECT_ID = ius.OBJECT_ID)
WHERE ius.database_id = DB_ID()

This normally happens when you don’t have columns such as DateCreated and UpdatedDate in the table.

Live as if you were to die tomorrow. Learn as if you were to live forever.. -Mahatma Gandhi

Windows 10 – Adjusting Search Box in File Explorer

Windows 10 – Adjusting Search Box in File Explorer

In windows 10 the search box area in file explorer is too wide, well for me personally. The good thing about windows 10 is that you have the ability to adjust the search box according to your personal needs.

Move your mouse in between address location box and search box unless you see your mouse cursor changed to Horizontal Move. Slide left or right according to your needs.

The search function will perform correctly with the specified search text even though your specified text is not completely visible in the search box.

File Explorer with horizontal cursor

Happy Learning…..



Coronavirus (COVID) 2019 is a very contagious virus which mainly affects your respiratory system. People with mild symptoms can recover without any special treatment.

How the Virus is Transmitted:

  • Transmitted from droplets of infected person when they cough, sneeze or exhale.
  • In close proximity of the infected person
  • Touching the contaminated surface


  • Fever
  • Tiredness
  • Dry Cough
  • Aches and pain
  • Nasal Congestion
  • Runny nose
  • Sore Throat
  • Diarrhea

On average it takes 5–6 days from when someone is infected with the virus for symptoms to show, however it can take up to 14 days.

To prevent the spread of COVID-19:
• Clean your hands often. Use soap and water, or an alcohol-based hand rub.
• Maintain a safe distance from anyone who is coughing or sneezing.
• Don’t touch your eyes, nose or mouth.
• Cover your nose and mouth with your bent elbow or a tissue when you cough or sneeze.
• Stay home if you feel unwell.
• If you have a fever, a cough, and difficulty breathing, seek medical attention. Call in advance.

Self care

  • You should rest if you are not feeling well.
  • Drink plenty of fluid and have nutritious diet.
  • Clean and disinfect frequently touched areas.



  • We are shifting towards Tele-medicine, Working from home, social distancing.
  • Unemployment is rising
  • Small businesses are closing


Meat processing plants across the US are closing due to the pandemic

Antibody study suggests Covid-19 could be far more prevalent in the Bay Area than official numbers suggest

1st New York Antibody Study Finds Millions Infected, Daily Deaths Hit Lowest Level in Weeks

Physician Office Visits Plunge

Indians stranded in overseas

Two cats in New York are first pets known to have coronavirus in the US

Canada Lift Barrier for International Students Working in Essential Services

Eight babies catch corona at Tokyo centre


Top 50 Global Pharma: 2019

Top 10 Biggest Oil Consuming Countries: 2019


Here is the link for COVID19 Testing.

Trading: Understanding the Basics

Understanding the Basics

How to Measure Risk

Standard Deviation (volatility)

Measures how much price fluctuate over time, high volatility the greater chance of losing more money.

Price to Earnings Ratio (PE Ratio)

Price to earnings ratio (PE ratio) – price of stock divide by earnings per share eg. 20/2 = 10 read more…

Price to Book Ratio (PB Ratio)

Methods of Trading

  1. Algorithmic Trading
  2. Quantitative Trading

Stock Trading Markets (Financial Markets)


What are ETFs?

Exchange traded funds (group of stocks) eg. spy (local and international)


Bid – most someone willing to pay

Ask – most someone willing to sell

Bid-Ask Spread – is the difference deciding whether trade proceeds, the bigger the spread it is less likely for the trade and results in liquidity.

Types of Orders

Market Order: market orders involve buying stock at the best available price, routed the time it is placed.

Limit Order: willing to buy stock at certain price

Trading: Price to Earnings Ratio

Price to Earnings Ratio

Measures how much you are paying for the company’s earning.

The higher the price-to-earnings ratio the more expensive is the stock price.

Higher price-to-earnings ratio indicates that the company is very popular and it attracts more buyers in the market.

Average P/E Ratio = 17

High P/E Ration > 25

High P/E companies are very optimistic about future and stock price are overvalued and when bubble happens investors are more likely to lose quite a lot.

Low P/E

  • Company is undervalued, trading at low price
  • Company most likely have high earnings

It is best to find the correlation between low P/E ratio and above average returns.

Trading: Dollar Cost Averaging

Dollar Cost Averaging

DCA (Dollar Cost Averaging) vs LSI (Lump Sump Investing)

In stock market past performance cannot guarantee the future performance because every bear market decline, crash and panic.

DCA is simply where you invest same amount of money at regular intervals: every month, year or week regardless of market trend.

It will force the invester to buy more when the price is low and less vise versa.

Benefits related to DCA is that the invester will not be devasted by the losses that come along.

DCA encourages you to be patient and stick to the market for a long term during ups and down.

Month 1 : Stock Price $10 Bought 50 shares 
Month 2 : Stock Price $5 Bought 100 shares 
Month 3 : Stock Price $5 Bought 100 shares
Month 4 : Stock Price $15 Total 250 shares

ASP.NET MVC – Project Items

ASP.NET MVC – Project Items


This folder contains private data such as XML Files or databases if you are using SQL Server Express, SQLite, or other file based repositories.

IIS web server will not server any other the contains from this folder.


This folder has core configuration settings about the project, including route definitions, filters and content bundles.


Areas is a way to partition large application into smaller pieces.


Bin consists of the compiled assembly of MVC application along with any referenced assemblies that are not in the GAC.


This folder holds the content for CSS files and images.


This folder contains all the controllers.


This folder has all the view model and domain model classes.


This directory holds the JavaScript libraries.


This directory holds the views and partial views, grouped by the controller name. The web.config file prevents the views to be served by IIS. It must be rendered by action methods in controller class.


This directory holds layouts and views which are not specific to a single controller.


It contains the configuration required to make views work with ASP.NET and prevents views from being served by IIS and the namespaces imported into views by default.


This is the global ASP.NET application class. Its code-behind class (Global.asax.cs) is the place to register routing configuration, as well as set up any code to run on application initialization or shutdown, or when unhandled exceptions occur.


This is the configuration file for the application.

Happy Days!!

Live as if you were to die tomorrow. Learn as if you were to live forever.. -Mahatma Gandhi

Trading: Stock Beginners Guide

Stock Beginners Guide

What is Stock?

Ownership share in a company.

What is investment?

An asset or item purchased that will appreciate in the future, generate income or sold at a higher price.

With money you can buy shares, bonds, mutual funds or do fixed deposit.


When cost of living increases (prices of goods and services increases).

Dividend – share of profits paid out to shareholders

Market Capitalization Analysis

Price * No of shares outstanding = total value of all of the stock outstanding.

RangeStock ValueAnalysis
Nano Cap< $50mHighly Risky
Micro Cap< $250mHighly Risky
Small Cap$250m – $1bPotential growth
Mid Cap$1b – $10b Safety investing and potential growth
Large Cap$10b – $50b Conservative stock investors
Greater safety
Ultra Cap> $50bBiggest of the big eg. Apple, Google

Read More:

Dollar Cost Averaging

Price to Earning Ratio

Getting Started With Windows Server 2016

Getting Started With Windows Server 2016

Recently I got the opportunity to build one Windows Server at my workplace so I am going to share my experience.
Please note that I am not an expert into building server, this is my first step towards building one.

Basic Configuration Steps

1. Open server rack to verify that all the cables are properly connected, there are hard drives as per the requirement. If you ordered with RAID card make sure that it has one.

What is a RAID Controller?
RAID is a virtual data storage which consolidates all the disk drives so that it functions together to boost performance.

2. It is very important to test RAM. One of the server which I ordered had defective RAM and have to ship it back to the vendor for replacement. Once server goes into production then it will cost you more to fix the problem. The sooner you find out the better it is, in terms to time and resource.

One of the method to test RAM it to use the Memtest86 software. Download it to USB stick and run it for approx 24 hours.

Once the RAM test is successful then you are ready to install the operating system.

3. Change the BIOS setting for the boot order
Legacy BIOS Access: DEL, F2, F8, F12 or ESC
In my case I was using USB stick for booting so I changed my setting to USB Hard Disk

Windows Server Installation Steps

1.Check that your hardware meets the minimum requirements.
Minimum requirement Guide

Windows Server 2016 has Standard and Data Center editions and also with Core and Desktop experience but I will go for Windows Server 2016 Core installation.

Step 1: Select the operating system you want to install: Windows Server 2016 Standard

Step 2: Where do you want to install Windows: Minimum requirement to install Windows Server 2016 Core is 32 GB therefore select the disk partition which is greater than 32 GB.

If you have configured to install your operating system using GPT partition scheme then you have to change disk partion from MBR to GPT.

More Information on Converting MBR to GPT

Windows Setup: Installing using the MBR or GPT partition style

Step 3: Installation will resume and then it will reboot asking you to setup Admin credentials.

Setup your Administrator password.

That’s it, the basic installation for the server core.