Remote Technology Jobs

https://www.microsoftedgeinsider.com/en-us/download/?platform=linux-deb

Amazon Neptune lets you choose the Property Graph model and its open source query language, Apache TinkerPop Gremlin or the W3C standard Resource Description Framework (RDF) model and its standard query language, SPARQL. 

DynamoDB has the capability to scale depending upon the size of data.

mysql > SET session transaction isolation level READ COMMITTED; Query OK, 0 rows affected Time: 0.001s mysql > SET session autocommit=1; Query OK, 0 rows affected Time: 0.001s mysql >

mysql > SET TRANSACTION ISOLATION LEVEL READ COMMITTED; Query OK, 0 rows affected Time: 0.001s mysql > SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; Query OK, 0 rows affected Time: 0.001s mysql > SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; Query OK, 0 rows affected Time: 0.001s mysql > SET TRANSACTION ISOLATION LEVEL REPEATABLE READ; Query OK, 0 rows affected Time: 0.001s mysql >

Remove those ' \r' by sed: Example:  ssh -t server.goyun.info 'df -h /; df -h /home' | sed "s/\r//g" | mailx -s "disk dize info" devops@goyun.info

 ssh -t server.goyun.info 'df -h /; df -h /home' | sed "s/\r//g" | mailx -s "disk dize info" devops@goyun.info

Syntax mstsc.exe [<connectionfile>] [/v:<server>[:<port>]] [/admin] [/f] [/w:<width> /h:<height>] [/public] [/span] mstsc.exe /edit <connectionfile> mstsc.exe /migrate Parameters Parameters Parameter Description <connectionfile> Specifies the name of an .rdp file for the connection. /v: <server>[:<port>] Specifies the remote computer and, optionally, the port number to which you want to connect. /admin Connects you to a session for administering the server. /f Starts Remote Desktop Connection in full-screen mode. /w: <width> Specifies the width of the Remote Desktop window. /h: <height> Specifies the height of the Remote Desktop window. /public Runs Remote Desktop in public mode. In public mode, passwords and bitmaps aren't cached. /span Matches the Remote Desktop width and height with the local virtual desktop, spanning across multiple monitors if necessary. /edit  <connectionfile> Opens the specified .rdp fil...

Regular Windows keyboard combination Key combination for RDP Description of what hotkeys do Win key or Ctrl+Esc Alt+Home Opens the Start Menu or Start screen Alt+Tab Alt+Page Up Displays the Alt+Tab switcher where pressing Page Up while Alt is held down will switch programs from left to right Alt+Shift+Tab Alt+Page Down Displays the Alt+Tab switcher where pressing Page Down while Alt is held down will switch programs from right to left Alt+Esc Alt+Insert Cycles through open apps in most recently used order ( sends the current active window to the bottom of the Z-order ) Alt+Space Alt+Delete Opens the window menu of the active window Print Screen Ctrl+Alt+'+'(Plus key on numeric keypad) Takes a screenshot of the whole screen to the clipboard which you can paste in Paint Alt+Print Screen Ctrl+Alt+'-' (Minus key on the numeric keypad) Takes a screenshot of the active window to the clipboard which you can paste in Paint Ctrl+Alt+Del Ctrl+Alt+End Sends Ctrl+Alt+Del (Secure A...

start  msedge www.bing.com -inprivate start  firefox -private chrome -incognito

start  msedge www.bing.com -inprivate

From within wsl, run cmd.exe or powershell.exe goyun.info@DESKTOP-goyun.info:/mnt/c/Users/goyun.info$ powershell.exe Windows PowerShell Copyright (C) Microsoft Corporation. All rights reserved. Try the new cross-platform PowerShell https://aka.ms/pscore6 PS C:\Users\goyun.info> wsl * keychain 2.8.5 ~ http://www.funtoo.org * Found existing ssh-agent: 145 * Known ssh key: /home/goyun.info/.ssh/id_rsa goyun.info@DESKTOP-goyun.info:/mnt/c/Users/goyun.info$ cmd.exe Microsoft Windows [Version 10.0.19042.804] (c) 2020 Microsoft Corporation. All rights reserved. C:\Users\goyun.info>

my_print_defaults displays the options that are present in option groups of option files.  The output indicates what options are used by programs that read the specified option groups. bit@goyun.info:~$ my_print_defaults mysql client --auto-vertical-output --auto-rehash --compress --protocol=TCP --user=goyuninfo bit@goyun.info:~$ mysql --print-defaults mysql would have been started with the following arguments: --auto-vertical-output --auto-rehash --compress --protocol=TCP --user=goyuninfo

bit@goyun.info:/tmp $ ssh -O check u.goyun.info Master running (pid=2252) bit@goyun.info:/tmp $ ssh -O exit u.goyun.info Exit request sent. bit@goyun.info:/tmp $ ssh u.goyun.info

gpg --edit-key <KEY_ID> gpg> trust 1 = I don't know or won't say 2 = I do NOT trust 3 = I trust marginally 4 = I trust fully 5 = I trust ultimately m = back to the main menu Choose 5. gpg> quit

If you ever need to change your private key passphrase, you can do so with this command: ssh-keygen -f ~/.ssh/id_rsa -p Enter your old passphrase and then enter a new passphrase.

Passwd command can be used to lock or disable a user account. To lock: # passwd openvpn –l Above command changes the shadow file and adds “!” in front of the user password To unlock # passwd openvpn -u You can also enable account by removing manually the “!” character from the user’s password line in /etc/shadow. bit@goyun.info : ~ $ sudo passwd openvpn -l passwd: password expiry information changed. bit@goyun.info : ~ $ sudo grep openvpn /etc/shadow openvpn:!$6$PotCU3QmMD7JsvbS$cAM5Ti0pcPxgFXw87hwCGJqUWXPhN10eD8SMrRXMu/kUKJAh5sgHcTgSPAGUjeGd1HgmwRB4xDekGASyOBpVj0:18681:0:99999:7::: nm-openvpn:*:18530:0:99999:7::: openvpn_as:!:18673:0:99999:7::: bit@goyun.info : ~ $ sudo passwd openvpn -u passwd: password expiry information changed. bitcoin@goyun.info : ~ $ sudo grep openvpn /etc/shadow openvpn:$6$PotCU3QmMD7JsvbS$cAM5Ti0pcPxgFXw87hwCGJqUWXPhN10eD8SMrRXMu/kUKJAh5sgHcTgSPAGUjeGd1HgmwRB4xDekGASyOBpVj0:18681:0:99999:7::: nm-openvpn:*:18530:0:99999:7::: openvpn_as:!:18673:0:99999:7::...

  SELECT OCTET_LENGTH(blob_content) FROM blob_table WHERE id = 88 ;

It is currently works with the remote desktop app mstsc.exe, not the rdp app from Microsoft Store.

First configure it to start the service without asking a password. Create line in /etc/sudoers.d/ (at WSL to prevent asking password): %sudo   ALL=(ALL) NOPASSWD: /usr/sbin/service xrdp * Create .bat file in  Windows startup directory  with for example the following lines: wsl sudo service dbus start wsl sudo service xrdp start

You can find Windows startup directory by key:  Win + R  and  shell:startup

Use keychain  package  $ sudo apt-get install keychain Then append to your ~/.bashrc /usr/bin/keychain --nogui $HOME/.ssh/id_rsa source $HOME/.keychain/$HOSTNAME-sh

my_print_defaults displays the options that are present in option groups of option files. The output indicates what options are used by programs that read the specified option groups.

The file location is the %APPDATA%\MySQL directory on Windows and the current user's home directory on non-Windows systems.

With an inverted index, you create a secondary index that is the inverse of the primary key for your table. The HASH key for your table becomes the RANGE key in your index, and the RANGE key for your table becomes the primary key for your index.

Table: A collection of DynamoDB data records. Item: A single data record in a DynamoDB table. It is comparable to a row in a relational database. Attribute: A single data element on an item. It is comparable to a column in a relational database. However, unlike columns in a relational database, attributes do not need to be specified at table creation, other than the primary key. Attributes can be simple types such as strings, integers, or Boolean, or they can be complex types such as lists or maps. Primary key: A primary key is a unique identifier for a single item in a DynamoDB table. The primary key name and type must be specified on table creation, and a primary key of the specified type must be included with each item written to a table. A simple primary key consists of a single attribute, and a composite primary key consists of two attributes: a partition key and a sort key. For example, you can create a simple primary key using “UserID” as an identifier, or create a composite pri...

When building an application, you should always take time to design the data models needed in your application logic. This data model design should consider data access needs that will be needed in your application, both for reading and writing data.

jar -xvf /path/to/zip/file/or/jar/file

You can scale up or scale down your tables' throughput capacity without downtime or performance degradation. You can use the AWS Management Console to monitor resource utilization and performance metrics.

<? xml version = " 1.0 " encoding = " UTF-8 " ?> < Configuration status = " DEBUG " > < Loggers > < Root level = " TRACE " > < AppenderRef ref = " RollingFileAppender " level = " INFO " /> < appender-ref ref = " Console " level = " TRACE " /> </ Root > </ Loggers > < Appenders > < Console name = " Console " target = " SYSTEM_OUT " > < PatternLayout pattern = " %d{HH:mm:ss.SSS} [%t] %highlight{%level}{FATAL=bg_red, ERROR=red, WARN=yellow, INFO=green, DEBUG=blue} - %msg%n " /> </ Console > < RollingFile name = " RollingFileAppender " fileName = " logs/goyun.info.log " filePattern = " logs/$${date:yyyy-MM}/email-%d{MM-dd-yyyy}-%i.log.zip " > < Patter...

Empty File Content by Redirecting to Null # > file_to_be_emptied.log

sudo apt-get install keychain You can put the following to .bashrc /usr/bin/keychain --nogui $HOME/.ssh/id_rsa source $HOME/.keychain/$HOSTNAME-sh

Linux Date format is a sequence of characters which specifies how output will appear.  It comprises some combination of the following sequences: %% A literal percent sign (" % "). %a The abbreviated weekday name (e.g.,  Sun ). %A The full weekday name (e.g.,  Sunday ). %b The abbreviated month name (e.g.,  Jan ). %B Locale's full month name (e.g.,  January ). %c The date and time (e.g.,  Thu Mar 3 23:05:25 2005 ). %C The current century; like  %Y , except omit last two digits (e.g.,  20 ). %d Day of month (e.g.,  01 ). %D Date; same as  %m/%d/%y . %e Day of month, space padded; same as  %_d . %F Full date; same as  %Y-%m-%d . %g Last two digits of year of ISO week number (see  %G ). %G Year of ISO week number (see  %V ); normally useful only with  %V . %h Same as  %b . %H Hour ( 00 .. 23 ). %I Hour ( 01 .. 12 ). %j Day of year ( 001 .. 366 ). %k Hour, space padded (  0 .. 23 ); same as...

Windows Environment Variables List Environment Variable Corresponding Path %SystemDrive% C:\ (Operating System drive) %SystemRoot% C:\Windows %WINDIR% C:\Windows %HOMEDRIVE% C:\ (Operating System drive) %HOMEPATH% C:\Users\<Username> %USERPROFILE% C:\Users\<Username> %APPDATA% C:\Users\<Username>\AppData\Roaming %ALLUSERSPROFILE% C:\ProgramData %PROGRAMFILES% C:\Program Files %PROGRAMFILES(X86)% C:\Program Files (x86) %PROGRAMDATA% C:\ProgramData %TEMP% C:\Users\<Username>\AppData\Local\Temp %LOCALAPPDATA% C:\Users\<Username>\AppData\Local %PUBLIC% C:\Users\Public %COMMONPROGRAMFILES% C:\Program Files\Common Files %COMMONPROGRAMFILES(x86)% C:\Program Files (x86)\Common Files

This approach replaces the need for joins in a typical relational database and keeps your application high-performing as you scale up.

In provisioned capacity mode, you specify exactly the amount of read and write throughput you want. You pay for this capacity whether you use it or not. In DynamoDB on-demand capacity mode, you can pay per request. The cost per request is slightly higher than if you were to use provisioned throughput fully, but you don’t have to spend time doing capacity planning or worrying about getting throttled. On-demand mode works great for spiky or unpredictable workloads.

The same attribute in different items can contain entirely different kinds of information.

To start the SSH Agent in the background on Linux, run: eval "$(ssh-agent -s)" To start the SSH Agent automatically on login, add these lines to your ~/.bash_profile: if [ -z "$SSH_AUTH_SOCK" ]; then    # Check for a currently running instance of the agent    RUNNING_AGENT="`ps -ax | grep 'ssh-agent -s' | grep -v grep | wc -l | tr -d '[:space:]'`"    if [ "$RUNNING_AGENT" = "0" ]; then         # Launch a new instance of the agent         ssh-agent -s &> .ssh/ssh-agent    fi    eval `cat .ssh/ssh-agent` fi

If you are on macOS and Linux, enable the ControlMaster feature on your local machine so that OpenSSH runs multiple SSH sessions over a single connection. This will reduce how often you have to enter a password or token. To enable ControlMaster: Add an entry like this to your SSH config file: Host *     ControlMaster auto     ControlPath  ~/.ssh/%r@%h-%p     ControlPersist  600

Batch files don't have access to the full range of .NET tools, making PowerShell often more powerful.

You can put your command in  $HOME/.bash_profile . All commands there are run on login.

The syntax for running a remote command is fairly straightforward: ssh username@host 'command'

If MAILTO is defined (and non-empty), mail is sent to the user instead. MAILTO="sysadmin@goyun.info" @daily /root/scripts/daily.sh MAILTO="cto@goyun.info" * 10 * * * /root/scripts/report.sh # # Disable email alert for rest of jobs # MAILTO="" #Other cron jobs

Setup null password: # usermod -p "" username Only do this on dev/test environment.

Run several commands in the same cron job by separating them with a semi-colon (;)

goyun@u:~$ sudo ufw status numbered Status: active To Action From -- ------ ---- [ 1] 22/tcp ALLOW IN Anywhere [ 2] 443/tcp ALLOW IN 172.16.0.0/12 [ 3] 3389 ALLOW IN 192.168.0.0/23 [ 4] 3389 ALLOW IN 172.16.0.0/24 [ 5] 110 ALLOW IN Anywhere [ 6] 22/tcp (v6) ALLOW IN Anywhere (v6) [ 7] 110 (v6) ALLOW IN Anywhere (v6) goyun@u:~$ sudo ufw delete 3 Deleting: allow from 192.168.0.0/23 to any port 3389 Proceed with operation (y|n)? y Rule deleted goyun@u:~$ sudo ufw status numbered Status: active To Action From -- ------ ---- [ 1] 22/tcp ALLOW IN Anywhere [ 2] 443/tcp ALLOW IN 172.16.0.0/12 [ 3] 3389 ALLOW IN 172.16.0.0/24 [ 4]...

The -p <port> option can be used to specify the port number to connect to when using the ssh command on Linux.  The -P <port> (note: capital P) option can be used with SFTP and scp.  The SSH port number command line setting overrides any value configured in configuration files.

Add more ports to sshd: Inside sshd_config: Port 22 Port 110 Port 443 Port 2222

sudo vim /etc/fail2ban/jail.local [sshd] enabled = true port = 22,2222 filter = sshd logpath = /var/log/auth.log maxretry = 3

Existing sessions will remain active, using the pre-restart config. All new sessions will use the new config. So before restarting sshd, open another session and keep it alive while restarting sshd service.

GitHub Codespaces provides cloud-hosted development environments for any activity - whether it's a long-term project, or a short-term task like reviewing a pull request. You can connect to Codespaces from Visual Studio Code, Visual Studio, or a browser-based editor that's accessible anywhere!

The Host directive can contain one pattern or a whitespace-separated list of patterns.  Each pattern can contain zero or more non-whitespace character or one of the following pattern specifiers: * - Matches zero or more characters. For example, Host * matches all hosts, while 192.168.8.* matches hosts in the 192.168.8.0/24 subnet. ? - Matches exactly one character. The pattern, Host 10.10.8.? matches all hosts in 10.10.8.[0-9] range. ! - When used at the start of a pattern, it negates the match. Host * !fm ProxyJump fm Host * # Does not use ProxyJump here Host * !fm means all hosts except fm

#SSH connection reuse does not currently work on Windows. You currently cannot use ControlMaster and ControlPath on Windows SSH. The workaround is to use wsl on Windows.

Host hop1 HostName hop1.goyun.info Host hop2 HostName hop2.goyun.info ProxyJump hop1 Host hop3 HostName hop3.goyun.info ProxyJump hop2

rsync -rlptzv --progress --delete --exclude=.git "user@hostname:/remote/to/be/synced/path" local/path

Download the Amazon RDS CA file from https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem

You can instantiate a MongoClient object without any parameters to connect to a MongoDB instance running on localhost on port 27017: MongoClient mongoClient = MongoClients.create(); Or you can specify the ConnectionString: MongoClient mongoClient = MongoClients.create("mongodb://hostOne:27017,hostTwo:27018");

Sequential primary keys introduce locks.  Use client-generated keys, such as GUIDs. When you have master-master replication, auto-increment causes conflicts.