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: