How do we replace Notepad with Notepad++?

 

You can run the following command to make Notepad++ replace Notepad (run in cmd.exe with Administrator privileges):

reg add "HKLM\Software\Microsoft\Windows NT\CurrentVersion\Image File Execution Options\notepad.exe" /v "Debugger" /t REG_SZ /d "\"%ProgramFiles(x86)%\Notepad++\notepad++.exe\" -notepadStyleCmdline -z" /f

Note that you may need to use

"%ProgramFiles%\Notepad++\"

to substitute for

"%ProgramFiles(x86)%\Notepad++\"

If you have Notepad++ 64-bit installed, or use other path if your Notepad++ is installed in a non-default location.

Use the the following comment to undo the replacement:

reg delete "HKLM\Software\Microsoft\Windows NT\CurrentVersion\Image File Execution Options\notepad.exe" /v "Debugger"

Installing MariaDB on Windows

https://www.youtube.com/watch?v=yQPnCxJMOWI

Installing MariaDB in Windows. The cooling this to note is how he queries from Command prompt. We did this long time ago. :)

What is MariaDB

https://www.youtube.com/watch?v=B_dHsTLt674

What is Maria DB?  It is a 100% backward compatible with mysql) but, 100% open source DB. The bugs DB is open.

History: Mysql was acquired by SUN and then ORacle and then enterpriseonly features were introduced. So Maria DB was started in FEb 2010.

Key Features: Subqueries are usable, 200K possible connections, huge speed increase, group commit.

New features: In MySQL, there is a PAM authentication only in Enterprise version. However, in Maria DB, it is available for all, Extended user stats, Better and safer replication. Show explain.

Whats next: Maria DB 10.0 has ability to use no-sql like CASSANDRA within MAriaDB

Whats in it for us: Performance, Opensource features