Saturday, December 10, 2022

How can I download Windows Update in Windows 10?

 Sometimes you are not able to download Windows Update. Without Windows Updates chances are your computer/laptop is not working well.

This screen shows the related issues with Windows Update.


Before getting into more diagnostics and web searches you make sure this service is turned in the Control Panel's Services window.


This service is by default 'Manual'. You can 'Start', "Stop" or "Restart" this service in the Control Panel-> Services node.

If you look closer this Windows Service requires another service "Remote Procedure Call" running.

In the Control Panel's Services node you can 'Start', "Stop" or "Restart" this procedure is also "Manual" by default.

If you have to do any of the above, you must have administrative rights over the computer/laptop. 

Even after doing all this if the Windows Update does not work, you should look for other problems.





Thursday, October 20, 2022

What does Microsoft Math Solver do?

 It can help you to work with a number of math problems from areas from arithmetic to matrices. It's an app you can download for both iPhone and Android phones.


This may help you with your studies and you may ace the SAT exam. There is a download link to get your copy of the APP on your smartphone. It also shows the steps in the calculation which is very invaluable.

Here is a picture of the site in English and you can use other languages also. To type an equation you need to use the pertinent math problem you are interested in. It ranges from Pre_Algebra to Matrix Calculation. 

Give it a try.

Good luck


Here is the link:   https://mathsolver.microsoft.com

Wednesday, August 3, 2022

How is Bigdata handled, RDBMS or NoSQL?

 Here is a reasonable article comparing SQL vs. NoSQL. Here you can also look up the differences between RDBMS and Document Databases. 

https://phoenixnap.com/kb/sql-vs-nosql

While Amazon has its own DocumentDB, MongoDB is used in a lot of places (Forbes, Toyota, etc) and Amazon's DocumentDB is compatible with MongoDB. 

Of course, Microsoft's SQL Server is a mature product and it can even handle BigData using Polybase virtualization. You can query data from any SQL Server, Oracle, Teradata, MongoDB, and other data sources using external tables. 

https://docs.microsoft.com/en-us/sql/big-data-cluster/big-data-options?view=sql-server-ver16

Connectivity to HDFS now uses published REST APIs instead of the Java Hadoop client. all you need to do is to configure connectors while configuring the AZURE Storage.

Here is a schematic from Microsoft's documentation of BigData storage and processing in the Microsoft platform.


Also, storing data in itself is not sufficient and Microsoft has POWER BI which also visualization of data from a huge number of database products. It is hard to beat Microsoft at this game.

I am somewhat slanted towards Microsoft due to my association with Microsoft database products for a long time. I have not received any remuneration from Microsoft for this post.

Sunday, May 15, 2022

Can a folder turn into a file?

 It did recently. I had a USB drive with many folders and sub-folders. One of the folders had many sub-folders and text files, Word and Excel documents, and image files.

I had a shortcut for the folder on my desktop (Windows 10).  One fine morning, the folder shortcut was replaced with a file. I am not sure if it happened during a Windows Automatic Update event. This file turned out to be a binary file with many Chinese characters among many other characters.

I tried Microsoft help and it did not amount to anything. The staff who came to me was not of much help. He did say that he has had the same experience and concluded that it was some corruption of the file system. Very much like GP"s saying it is a viral infection. NOTHING CAN BE DONE.

It is also reported by others besides my experience.






Monday, May 9, 2022

How and where to get a Social Security Number?


If you fall into any of these categories you can get a Social Security Number by going to this link:

https;//WWW.SSA.GOV/ssn

The following are the categories:

1. A lost stolen or damaged card

2. Update or correct your personal info

3. To get a Social Security Number for the first time.

You may need to carry your identifying documents such as a valid Passport, valid Driver's License, Greencard, etc. However, you can get online and identify yourself. After answering a questionnaire that requires your details and that of your parents you will be directed to visit the local SSA office nearest to you with the identifying documents you said you have online.

I found the site very userfriendly and easy to get on with.


Good luck

Tuesday, April 12, 2022

Can IIS Express and IIS be installed on the same machine?

Yes, you can.

Where do I find the IIS EXPRESS installation files?

You can find it here:

https://www.microsoft.com/en-us/download/details.aspx?id=48264


You can install it on these systems: Supported Operating Systems

Windows 10, Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2


You can run it immediately after downloading and running from your chosen location.

These are the benefits of using IIS EXpress:

  • The same web server that runs on your production server is now available on your development computer.
  • Most tasks can be done without the need for administrative privileges.
  • IIS Express runs on Windows 7 Service Pack 1 and all later versions of Windows.
  • Many users can work independently on the same computer.
All information from Microsoft Site.

How do I run IIS Express from command line?

Make sure you have installed it on your machine by checking C:\IISExpress /?

Then you can access using the command line.

Please refer to this document:

https://docs.microsoft.com/en-us/iis/extensions/using-iis-express/running-iis-express-from-the-command-line

What are the differences between IIS and IIS Express?

 There are a number of differences. 

Here is a table I extracted from the Microsoft website:




Can I manage IIS Express in IIS Manager?

 The simple answer is no. 

IIS is managed by IIS Manager and appcmd.exe


IIS Express is managed by Appcmd.exe


IIS Express Management tasks are built into:

WebMatrix

Visual Studio 2010 SP1 and later versions

Saturday, March 12, 2022

Are you unable to connect to the SQL Server Configuration Manager?

 This could happen sometimes even if you have SQL Server installed on your computer (or laptop). Normally on Windows 10, you should see this in the Server Folder shown here.



You can see I do not have SQL Server Configuration Manager. I have two other versions also.  

This problem crops up from time to time because SQL Server Configuration Manager is part of the Microsoft Management Console add-in.

Details to bring it up are described here for SQL Server 2016 I was using one time.


Following the above, I can see all my different SQL Server Configuration Managers here:


Also, You can search for it using SQLServerManager11.msc in the Windows 10 Search as shown:


BTW, my blog "http://hodentekMSSS.blogspot.com " is basically created for Microsoft SQL Server related topics

If you want to know how to open "MMC" read here:



Tuesday, March 8, 2022

How to access Microsoft Management Console in Windows 10 and create Certificate snap-in?

It is not difficult to create a certificate snap-in in Windows 10. Just follow the steps in this step-by-step procedure. The screenshots are self-explanatory but a few comments have been added. You can use a certificate snap-in for the following accounts, Computer Account, My User account, or Service account.

Invoking the Microsoft Management Console.

Just type in MMC in the windows search at the bottom of the desktop and use the Run Command as shown.



Or you can invoke the RUN command and type 'mmc' in it.


Yet another way you may invoke is by typing in 'certmgr.msc' in the Search box as shown.



Adding a snap-in.

In the File menu item choose Add/Remove snap-in as shown.


The Add/Remove snap-in windows get displayed. There are many items you can add as a snap-in. Observe that 'Certificates' is one of the snap-ins you can add. 


Adding the snap-in is easy. Observe the 'ADD' button between the two boxes in the above figure. Highlight Certificate in the left box and click ADD.


A new window opens asking you to choose from 3 of the options for which certificates can be added as shown.




Choosing 'My User Account' brings up this image.


Click 'Finish' adds the Certificate 'Current User'.

Now click OK. The various items related to the certificates of the Current User are displayed as shown.


The current user of this computer has the following certificates as shown.


From here explore for yourself the different items of the current user to learn about them.


Good luck


Thursday, January 13, 2022

Your Samsung phone (21S+5g) suddenly goes black and white. How do you fix it?

 This is probably a settings issue. Happened to me once.

Here is the fix:

There is a mode called 'Bedtime mode'. If it is set for Turn on now make sure it is set correctly. Start with Settings and follow it up.