How do you find a mobile simulator for Android smartphones?

  You have built a web application on your PC or laptop.  Now,  you want to see how it appears on a mobile device. This is the use case for a mobile simulator, an extension that displays how your site would appear on a handheld. It is a responsive testing tool.

It is available on Google Chrome Webstore. It can simulate 5 models of Android smartphones and 11 models of Apple smartphones.

Deatils here: Mobile Simulator

From the above site you can add it to Microsoft Edge where it will show as one of the extensions as shown.

How do you test it?

Just bring up a web page (any) as shown here:

Now click on this icon and see the simulator getting displayed as shown:

There is another web site here with some operational buttons on the right.

What is dynamic locking in Windows 10?

 It is a security feature that locks up your computer/laptop when you are away (out of the Bluetooth range) from the computer. You can use this feature with your Bluetooth-enabled SmartPhone, Bluetooth headset, etc.

It is possible to lock the computer with Windows Key+L but the dynamic key can be useful when you forget to log out or go to sleep.

The "Dynamic Locking" feature is by default inactivated but you need to activate it.

Here are some screens that may be useful to you. I have paired my Samsung smartphone with my laptop.

What version of Windows 10 are you running on your laptop/PC presently?

 You can find it in Settings/System. Go to the very bottom of this page and look up About.

There are issues in everything, and here is a link to resolved issues for the above version:

https://docs.microsoft.com/en-us/windows/release-health/resolved-issues-windows-10-21h1

How to fix the error, "Error writing to temporary file. Make sure your temp folder is valid"?

 This is quite a frequent error many folks are confronted with while installing some new software.  I encountered this problem trying to install Android Studio on my Windows 10 (x64).

What is Windows 10 controlled folder access?

Controlled folder access is an anti-ransomware feature in Windows 10 that helps protect your file system on your computer from modification by suspicious or malicious apps (especially ransomware). You should find this in "System Protection"

Controlled folder access in Windows Security reviews the apps that can make changes to files in protected folders and blocks unauthorized or unsafe apps from accessing or changing files in those folders.

Access the relevant feature page in the Control Panel as follows:

Select Start  > Settings  > Update & Security  > Windows Security > Virus & threat protection.

In Virus & threat protection settings, select Manage settings.

Under Controlled folder access, select Manage Controlled folder access.

Although I could have looked through other options for managing, I wanted something which was quick to test my hunch but it cannot be a permanent solution.

I took a calculated risk. chose to switch the access to OFF temporarily. I then initiated the install process for the Android Studio and when it was installed, I switched the protection ON. 

I did not get any more notifications and the software was installed successfully.

What folders are protected?

In the above image, you can click on Protected folders to review them. Here is a partial list.

How do you edit Windows 'hosts' file in Windows 10?

 Windows 'hosts' file contains mappings of IP addresses to hostnames.

You can find the file in the Windows System32 folder if you run your DOS program with administrative privileges as shown.

You can open this file with Notepad also run with administrative privileges. There is another 'hosts' file related to iCalendar.

It is just a text file that you can edit and save with your changes.

More here:

https://hodentek.blogspot.com/2009/07/in-vista-home-premium-computer-name-is.html

You can also use the "Hostsman" application to edit the "hosts" file:

https://www.abelhadigital.com/hostsman/#downloads

Is there a DNA based vaccine for the COVID-19 virus and its variants?

 One more arrow at the heart of this Wuhan virus.

"BENGALURU, Aug 20 (Reuters) - India's drug regulator has granted emergency use approval for Zydus Cadila's COVID-19 vaccine, the world's first DNA shot against the coronavirus, in adults and children aged 12 years and above." - Reuters

This is the second homegrown vaccine ( Zycov-D  ) made by the generic drug maker Cadila Health Care of India. The first one, also approved is the Covaxin. It is a needle-free vaccine that does not need very low temperatures. The late-stage trial had 28000 participants with about 1000 in the lower age group (12 to 18).

https://www.zyduscadila.com/

More here:

https://www.bbc.co.uk/news/world-asia-india-57774294 

https://www.axios.com/india-first-dna-covid-vaccine-f07c5105-893c-473f-8c60-8b5aaef28e5a.html

https://www.reuters.com/business/healthcare-pharmaceuticals/india-approves-zydus-cadilas-covid-19-vaccine-emergency-use-2021-08-20/

How do you access Amazon Web Services Cloud Storage using a Python client?

 You can develop a client application using React with Python and access the AWS's S3 bucket via  Flask server.

Here are some relevant links that you may want to look up or quick tutorials to get the hang of it.

How to create a React+Flask Project?

https://blog.miguelgrinberg.com/post/how-to-create-a-react--flask-project

https://rajrajhans.com/2020/06/2-ways-to-upload-files-to-s3-in-flask/

Microsoft Visual Studio provides full support for almost any kind of project:

https://code.visualstudio.com/docs/python/tutorial-flask

https://code.visualstudio.com/docs/nodejs/reactjs-tutorial

https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-s3-features-now-available-aws-toolkits-for-visual-studio-code/

You can get a link to download the latest community version(free) here:

https://hodentek.blogspot.com/2021/07/visual-studio-2022-preview-available.html

Is it possible to convert from .json format to .xlsx format?

 The easiest way to do this is to use Windows Powershell as described here. It is enough if you convert .json to .csv. File format .cssv can be opened with EXCEL and saved.

This is the .json file:

============

{

   "Name": "James Bond",

   "Age": "35",

   "Profession": "Professional Killer",

   "Location": "London, UK"

}

===================

This file, JamesBond.json  is saved on my desktop.

Let us say that is the code you need to convert to from .json to .csv format

Create the above text in Notepad and save it with the extension .json (default is .txt for Notepad)

Open the Windows PowerShell ISE

Type in the following code (try to see what else you can convert from and convert to in the above images):

Get-Content C:\Users\TestUser\Desktop\JamesBond.json | ConvertFrom-Json|ConvertTo-Csv

Run the code in the Windows PowerShell ISE

You will see this result:

==========================

"Name","Age","Profession","Location"

"James Bond","35","Professional Killer","London, UK"

---------------------------------

You get the answer as shown. 

This is in CSV format and this can be opened with EXCEL.

This can be saved as .xlsx or various other formats.

Is Microsoft Visual Studio available for Mac? What is the latest edition?

 

Yes. It is available. 

Go here and download: https://visualstudio.microsoft.com/downloads/

The Visual Studio for both Windows 64-bit and Mac are available for preview presently.

Is Hydrogen a colorless gas?

Yes, it is colorless. This is what elementary chemistry tells you. But people may be wondering why they are adding a color attribute to hydrogen.

The color attribute of hydrogen comes about by the way it is produced on an industrial scale. There are three colors presently:

Grey hydrogen:

Basically from fossil fuels such as coal or natural gas.

https://www.coalage.com/features/hydrogen-from-coal/#:~:text=H%202%20produced%20by%20steam%20methane%20reforming%20%28SMR%29,hydrogen%20that%20includes%20carbon%20abatement%2C%20such%20as%20CCUS.

https://tinyurl.com/yey9fegt

By far most of the hydrogen presently produced/used is grey hydrogen.

Green hydrogen:

Hydrogen from Electrolysis of water.

This is completely free of carbon in its production.

http://www.chem.gla.ac.uk/cronin/media/papers/Chisholm-Chapter_16_2016.pdf#:~:text=The%20production%20of%20hydrogen%20from%20water%20via%20electrolysis,has%20two%20main%20applications%20as%20an%20energy%20vector.

or

https://tinyurl.com/4y6hektf

Blue hydrogen:

It is similar to Grey hydrogen but the carbon in the process is captured and stored (so-called carbon neutral).

https://www.msn.com/en-us/news/technology/blue-gas-could-become-a-tesla-killer/ar-BB1dOsgr#:~:text=So-called%20%27blue%27%20hydrogen%20is%20the%20name%20given%20to,water%20are%20converted%20into%20hydrogen%20and%20carbon%20monoxide.

https://tinyurl.com/e5k7zrxe

Is there an online compiler for multiple programming languages?

 Yes. There is indeed one I recently came across. It can compile a couple of programming languages as shown here (copied from its website).

I just tested a demo SQL query. It worked.

It has a simple interface. Just enter your code and click RUN and you are done.

Just click RUN after entering your code as shown (I just modified the demo query a little bit).

The result of the query is shown. I have not tested other languages.

Here is the site where you can do it. You need to register to use this program.

https://www.mycompiler.io/new/sql

How do we work with MS Access to access SQL Server Database?

 I will show you in four simple steps.

1. Create a new MS Access database file

2.    You need to provide a name instead of accepting the default.

3.    Click the Menu item 'External Data' 

4.    Go to New Data Source as shown and choose SQL Server.

Follow the red line and choose From SQL Server

Which of Microsoft's SQL Tools provide a Graphical User Interface?

Some people like GUIs more than scripting languages. They can still manage to work with SQL Servers.

Databases reside in the database servers. These servers may reside on your laptops, computers running with various operating systems such as Windows, Linux, and macOS. These servers may run in the cloud such as Azure. The tools, however, may not reside on the same platforms but allows you to connect to the various above-mentioned servers.

In brief, the tools are the following:

1. Azure Data Studio uses the operating systems, Windows, macOS, and Linux

This tool can run on-demand queries and save data as text, JSON, or Exel. It has a lightweight editor

2. SQL Server Management Studio (SSMS)

It is a full-featured GUI as well as it can run TSQL statements. It has tons of features.

It is a one-stop database management tool.

It can connect to the cloud, Azure SQL Database, Azure Synapse Analytics, etc.

Developers and DBMs of all skill levels can use this tool.

3. SQL Server Data Tools(SSDT) 

Using this you can build relational databases, Azure SQL databases, Analytical services, integration services, reporting services, etc

4. Visual Studio Code

Using the "mssql extension" for Visual Studio Code you can connect to SQL Servers

You can do scripting with a lightweight editor after connecting to SQL Server in Visual Studio.

You can find extensive references to complete articles on the following sister blogs:

http://hodentek.blogspot.com

http://hodentekMSSS.blogspot.com

More on GUI tools here:

https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver15

How do you open backdoor in Venza 2021 Limited?

 You can open the Venza 2021 Limited's backdoor in a number of ways including from inside the car. The power switch should be on.

The backdoor can be opened and closed in a number of ways. In all cases make sure your fingers are not holding on to the opening door you may get your fingers damaged while closing).

1. Using the door opening switch in the Remote Key.  You need not unlock the car but should have the  Remote key on your person.

 

2. Even if the car is locked (but you should be having the key on your person) you can open the backdoor by

   Sweeping your feet standing in the center of the car about a foot from the door. You will see the side mirrors opening and you get an audible signal that the door will open. stand away from the door.

3. Once the door is open, you can see controls that can be used to close the door or lock it in position to adjust to the height of the user.

4. Directly under the logo behind the car there are two controls, to open and close. You may need to feel them as they are not seen looking directly. This was photographed with the door open.

5. When the Power is on you can open the door from inside the car using control shown. You need to make sure that there are no obstructions or people standing nearby as the backdoor would swing-out. Probably, it is better to use this method only in an emergency and make sure you use the 360 -degree view system.

How do you adjust the Head Up Display (HUD) in your Toyota Venza?

 The HUD display is only available in Toyota Venza Limited edition.

If the HUD has been set up, the display is on whenever the Power is ON.


The height of the display and its brightness can be controlled. The height may need adjustment depending on the seat position.

The following screen shots show how this may be adjusted:


Step 1: You need to get to the "Settings" on the large display as shown. When you press "i" (left bottom shown) the "Settings" control will be available. 

The "Settings" gives access to the "Meter Control Switches" These are available on the left side of the steering wheel.

The Left-Right < > control switches the various functions such as 'HUD". The "UP" and "DOWN" allows other selections. The return symbol above the 'Phone" icon returns to previous.

When "Settings" is chosen this is what you will see on the "Instrument Cluster" as shown.

Step 2: Using the left (<) and right (>) controls you can move on the 4 functionalities shown. There are more than four functionalities. Pressing the right control after the rightmost marked PCTA gets you to the next set of functionalities.

Step 3: When you come to 'HUD" as shown above you can turn on or off the HUD control. If you HOLD down on "OK" in the "Meter-control" on the steering wheel, you get the sub-menu under "HUD" as shown.

Step 4: Now you can work on left (<) and right (>) controls to adjust brightness of the display and using the top and down arrows you can raise or lower the HUD. While making these adjustments you should be seeing the HUD on the wind screen.

After the adjustment you can get back to "Settings" and back to Info.

The HUD display is shown here. The outside light is strong when this photo is taken but you can see the HUD.

This next one is cropped from the above.

You can see the 'lanes' and it is in 'Parked (P)" position

Can you create a query in MS Access using a SQL Statement?

Microsoft Access is designed such that even if you do not know SQL or SQL syntax you could still use the application. As a consequence, there is no obvious starting point to write a SQL Statement and execute it. However, it does allow you to write a SQL Statement, save the query and execute it.

Open access application. I have just one simple table 'BOOK1'.

In the 'Queries' tab of Create click on Query Design to open a tabbed page 'Query 1" as shown.

Query 1 has two panes. The top one is empty and it is here you can write a SQL Statement and the bottom pane is where you can compose a query using visual elements.

Right-click in the empty top pane to show this drop-down.

Click on 'SQL View'. This view is not the same as 'View' in SQL Server. This opens a text editor where you can write a query. Note that it has just the 'SELECT'. It expects you to write a "SELECT" statement.

Note that there is a Table 1 called 'Book1' shown here.

Now I write a SQL query against this table.

SELECT ID, Field2 

From Book1

Here is the statement in the SQL View's editor pane.

Now save the query, Query1. You need to click on the tab to save as shown.

You can save it with a different name which is usually recommended. I saved it as BookQry as shown.

Now double click on BookQry on the left to open the query to show the result.