AutoHotkey allows user to define a custom combination of two keys (except joystick buttons) by using ampersand (&) between them. As for example:

a & b::MsgBox Hello!!!

Hold down <a> key then press <b> key to trigger the message box.

But by using this way, key <a> will become a prefix key. In other words, it will causes key <a> to lose its original function when it is pressed, i.e. “a” will not appear in text box. To avoid this behaviour, one of the way is to apply the tilde prefix (~) to the key.

For example:

~a & b::MsgBox Hello!!!

Using tilde in front of keys will maintain the native function of the keys used. However, Special hotkeys that are substitutes for alt-tab always ignore the tilde prefix.

Source:

• https://www.autohotkey.com/docs/Hotkeys.htm#combo
• https://autohotkey.com/board/topic/5408-multiple-letter-hotkeys/

When using ReadAllText method to read a log file with a size of 21.83MB, it takes between  7 seconds (for powerful CPU) to 12 seconds (for weak CPU).

Dim file As New FileInfo("path\to\file")

Using reader As StreamReader = file.OpenText()
    While Not reader.EndOfStream
        Dim nextLine As String = reader.ReadLine()
        ProcessLine(nextLine)
    End While
End Using

Const MAX_BYTES As Integer = 1048576 * 5 '=10 MB 
Dim bytesRead(MAX_BYTES) As Char
Dim numBytesRead As Integer
Dim currentPos As Integer = 0
Dim strFileName As String
Dim strm As System.IO.Stream
Dim TextLine As String
Dim FileDetail As IO.FileInfo

OpenFileDialogMain.ShowDialog()
strm = OpenFileDialogMain.OpenFile()
strFileName = OpenFileDialogMain.FileName.ToString()
  
Using reader As System.IO.TextReader = _
System.IO.File.OpenText(strFileName)
  numBytesRead = _
reader.ReadBlock(bytesRead, currentPos, MAX_BYTES)
  TextLine = reader.ReadLine()
End Using

txtEditor.Text = New String(bytesRead)
txtEditor.Text += TextLine
txtEditor.Text = txtEditor.Text & vbCrLf & Now

Test Methodology

Conclusion: stick with ReadAllText method to read a log file.

Problem: If the the post with video attached is edited, even though I did not remove the video, the video will be automatically removed.

Solution: none.

Problem:

1. The default administrator account has problem with uploading video
   
   and accessing “Video library”
   
2. The above 2 errors occurred when used in:-
   1. Opera browser Version:68.0.3618.125 in Asus laptop
   2. Chrome browser Version 83.0.4103.61 (Official Build) (64-bit) in Asus laptop
   3. Chrome browser Version 81.0.4044.138 (Official Build) (32-bit) in  Dell-E6410 laptop
   4. IE 11 in Asus laptop

Solution: add another FB account as “Administrator” and able to solve the above roblem — able to access “Video library” and successfully upload video.

(T, please add here …)

1. Open Windows PowerShell and copy below command into it

   # Create Keys for TLS 1.2 if not exist
   
   new-item -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols" -Name "TLS 1.2"
   
   new-item -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2" -Name "Server"
   
   new-item -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2" -Name "Client"
   
   new-itemproperty -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client" -Name "Enabled" -Value 1
   
   new-itemproperty -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client" -Name "DisabledByDefault" -Value 0
   
   new-itemproperty -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server" -Name "Enabled" -Value 1
   
   new-itemproperty -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server" -Name "DisabledByDefault" -Value 0

2. Reboot server
3. To check whether TLS 1.2 is configured, open Registry Editor and go to this path:

   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols

   

   in this picture, it shows that Windows has “SSL 2.0” and “TLS 1.2” security protocol installed.

1. db_owner role should only be given to the administrator who responsible for the database because this role can DROP the database
2. db_datareader and db_datawriter is the minimum access that should be given to normal user to do the basic SELECT, UPDATE, INSERT and DELETE operation to the database

Source:

1. https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver15
2. https://www.mssqltips.com/sqlservertip/1900/understanding-sql-server-fixed-database-roles/

1. Create an user account on the computer that act as a server, the username and password must used exactly like the account used in client computer
2. In SQL Server Management Studio:
   • Expand “Security” -> expand “Logins” -> “New Login”
     
   • Click “General” -> select “Windows authentication” -> click “Search”
     
   • Type the account name that has been created on server computer, click “Check Names”
     
   • Alternatively you can do this step by clicking “Advanced” button -> “Find Now” -> find the account name in the search results -> click “OK”
     
     
   • Click “Server Roles” -> check for sysadmin
     
   • Click “User Mapping” -> choose database -> check for db_datareader and db_datawriter
     

Note: You do not need to enter the password as SQL Server will ask Windows to validate the user password. (source: https://www.virtual-dba.com/differences-windows-sql-server-authentication/)

1. You can choose what type of login activity that you want the SQL Server to log. By default, SQL Server will log the “Failed logins only” activity only. To choose the login activity, right-click at your “Server <instance name>” -> “Properties”. In Server Properties, click “Security” and choose the activity in Login auditing area:
   • None
   • Failed logins only
   • Successful logins only
   • Both failed and successful logins
     
2. To view the MS SQL Server log files, expand “Management” -> expand “SQL Server Logs“, click any log date that you want to view:
   
3. All the login activities can be viewed in the Log file summary area: