Author: Shahzad Khan

Software developer / Architect

Karachi Biryani

This is the recipe;

Karachi Bryani (Don’t add any onion)

USE sela rice (Paka Basmiti not simple Basmiti)
I Kg rice (3/4 water) in recipe – masala
Black pepper Corn – Kali mirch sabat
Green Cardamom – Sabaz Alachi
Star Anise – badiyan ka pool
Cinamon sticks – Dar chini
Gumin – Zeera
Cloves – long
Nutmeg – jayfill ka tukra
Mace – javatri ka chalka
Dried plum – alu bkukra 50 g
Turmeric – Haldi
Corriander Powerder – Sooka daniya
Plain yougert – Dahi
Bay leaves – Teez pata
Orange Food color
Lemon – Lemoo
Coariander Leaves – Danyia (more is better)
Mint Leaves – Poodinya (more is better)
Oil bottle – (add at time of dum. if not rice will break)

For Rice, 1 KG should have 2 teaspoon salt

cover for dum
first 5 minute high flame – 5 minute teze aag
20 minute slow flame – 20 minute halki aag

This is the video;

Hope you will enjoy this.

Window server core configuraiton

Windows Core is mostly PowerShell and command driven. Here are some key questions and answers to get you started with this flavor.

Is there any way I can tell windows to automatically try to find drivers for all devices (of course after I establish network connection) so I don’t have to click on each device?

Try configuring windows (with the help of sconfig.cmd) to search windows updates for device drivers. Check the following links

https://docs.microsoft.com/en-us/windows-server/get-started/sconfig-on-ws2016

https://technet.microsoft.com/en-us/library/cc753091(v=ws.11).aspx

How can I Install drivers manually on core?

You can manually install drivers on Windows Server core with Pnputil. Check the following link,

Installing Drivers on Windows Server Core

Is there a way to use device manager from remote server?

Yes, you can use access the device manager of your core server from other computers MMC snap-in. Check the following link (section 1.3)
https://technet.microsoft.com/en-us/library/jj574205(v=ws.11).aspx

Excel dropdown list with number and text

There are two methods;

Data validation drop down

There is a list option in Data validation. If this is combined with a VLOOKUP formula you would be able to convert the selected value into a number.

The steps in Excel 2010/2019 are:

  • Create your list with matching values.
  • On the Data tab choose Data Validation
  • The Data validation form will be displayed
  • Set the Allow dropdown to List
  • Set the Source range to the first part of your list
  • Click on OK (User messages can be added if required)

In a cell enter a formula like this

=VLOOKUP(A5,$E$5:$F$8,2,FALSE)

which will return the matching value from the second part of your list.

Form control drop down

Alternatively, Form controls can be placed on a worksheet. They can be linked to a range and return the position number of the selected value to a specific cell.

If you don’t see Developer tab in Excel ribbon, follow this link;

Show the Developer Tab

The steps in Excel 2010/2019 are:

  • Create your list of data in a worksheet
  • Click on the Developer tab and dropdown on the Insert option
  • In the Form section choose Combo box or List box
  • Use the mouse to draw the box on the worksheet
  • Right click on the box and select Format control
  • The Format control form will be displayed
  • Click on the Control tab
  • Set the Input range to your list of data
  • Set the Cell link range to the cell where you want the number of the selected item to appear
  • Click on OK