Cybersecurity Tips

* SLOW DOWN.
* Stop and Think.
* Don't click. Copy and paste a link into web browser.
* Research first.
* Lock your computer, cellphone when you're away.
* Backup before make any change, on daily, and weekly.
* Using KeePass or KeePassXC on Mac for password manager.
* 7-Zip or Keka for macOS file archiver
* Write it down. Pen and paper are good.
* Email with plain text mode.
* Airplane mode if not in use.
* Power off if not in use.
* Install only necessary app.
* Uninstall if no longer need.
* Use CerUtil or gpg to verify the integrity of downloaded file.
Before installing, you should always verify that your download matches
the signature that is published alongside the release package!
* Use Two-Factor Authentication (2FA) if provide.
* Keep it simple.

Tip: Using Visual Studio Code to reformat SQL script

Here is a no cost to reformat SQL script 

But, no capital keywords

Cloud Computing

Cloud Computing today is a trend. Popular cloud computing are Amazon Web Services (AWS), Microsoft Azure, IBM Cloud, ... 

Cloud Computing like a private Local Area Network (LAN) on the internet. For most business, Cloud Computing is a cost effective. Instead of spend thousand dollars or more per month, they spend less. Instead of maintain a group of Information Technology (IT) professional, they may need only one. They don't need much of network engineer, network administrator.

So, first they are outsource software development. Then, outsource IT help desk. Now, companies outsource the IT infrastructure. 

The questions is:

1. In which scenarios, moving to Cloud Computing is cost saving?
2. How about security, privacy?

PHP: require() vs include()

You can insert the content of one PHP file into another PHP file before the server executes it, with the include() or require() function.

The two functions are identical in every way, except how they handle errors:


include() generates a warning, but the script will continue execution


require() generates a fatal error, and the script will stop

How to determine the version and edition of SQL Server and its components

Using query command:
Select @@version

for more info read https://support.microsoft.com/en-us/kb/321185

Debugging in Visual Studio

Sometime to debug an web application in Visual Studio, you need to run as Administrator user or for other user.
For more info read: http://stackoverflow.com/questions/1287099/runas-a-different-user-when-debugging-in-visual-studio

How many clustered indexes can be in one table?

One clustered indexes per table. 

For more info: https://msdn.microsoft.com/en-us/library/ms143432.aspx